Class ExcelConditionalFormattingRule

Abstract base class for all ConditionalFormattingRules

Inheritance
System.Object
ExcelConditionalFormattingRule
Implements
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: OfficeOpenXml.ConditionalFormatting
Assembly: EPPlus.dll
Syntax
public abstract class ExcelConditionalFormattingRule : IExcelConditionalFormattingRule

Constructors

ExcelConditionalFormattingRule(ExcelConditionalFormattingRule, ExcelWorksheet)

Copy constructor

Declaration
protected ExcelConditionalFormattingRule(ExcelConditionalFormattingRule original, ExcelWorksheet newWorksheet = null)
Parameters
Type Name Description
ExcelConditionalFormattingRule original
ExcelWorksheet newWorksheet

In case cloning from another worksheet

Properties

AboveAverage

Above average In Excel: Default:True, use=optional

Declaration
protected bool? AboveAverage { get; }
Property Value
Type Description
System.Nullable<System.Boolean>

Address

The range over which these conditional formatting rules apply.

Declaration
public virtual ExcelAddress Address { get; set; }
Property Value
Type Description
ExcelAddress

As

Provides access to type conversion for all conditional formatting rules.

Declaration
public ExcelConditionalFormattingAsType As { get; }
Property Value
Type Description
ExcelConditionalFormattingAsType

Bottom

Bottom attribute

Declaration
protected bool? Bottom { get; }
Property Value
Type Description
System.Nullable<System.Boolean>

EqualAverage

EqualAverage

Declaration
protected bool? EqualAverage { get; }
Property Value
Type Description
System.Nullable<System.Boolean>

Formula

Formula

Declaration
public virtual string Formula { get; set; }
Property Value
Type Description
System.String

Formula2

Formula2 Note, no longer Requires Formula to be set before it. But will still throw error if both formulas not filled at save time.

Declaration
public virtual string Formula2 { get; set; }
Property Value
Type Description
System.String

Operator

Operator

Declaration
protected eExcelConditionalFormattingOperatorType? Operator { get; set; }
Property Value
Type Description
System.Nullable<eExcelConditionalFormattingOperatorType>

Percent

Percent attribute

Declaration
protected bool? Percent { get; }
Property Value
Type Description
System.Nullable<System.Boolean>

PivotTable

Indicates that the conditional formatting is associated with a PivotTable

Declaration
public bool PivotTable { get; set; }
Property Value
Type Description
System.Boolean

Priority

The priority of the rule. A lower values are higher priority than higher values, where 1 is the highest priority.

Declaration
public int Priority { get; set; }
Property Value
Type Description
System.Int32

Rank

Rank (zero is not allowed and will be converted to 1)

Declaration
public ushort Rank { get; set; }
Property Value
Type Description
System.UInt16

StdDev

0 is not allowed and will be converted to 1

Declaration
public ushort StdDev { get; set; }
Property Value
Type Description
System.UInt16

StopIfTrue

If this property is true, no rules with lower priority should be applied over this rule.

Declaration
public bool StopIfTrue { get; set; }
Property Value
Type Description
System.Boolean

Style

The style

Declaration
public ExcelDxfStyleConditionalFormatting Style { get; }
Property Value
Type Description
ExcelDxfStyleConditionalFormatting

TimePeriod

TimePeriod

Declaration
protected eExcelConditionalFormattingTimePeriodType? TimePeriod { get; set; }
Property Value
Type Description
System.Nullable<eExcelConditionalFormattingTimePeriodType>

Type

The type of conditional formatting rule.

Declaration
public eExcelConditionalFormattingRuleType Type { get; set; }
Property Value
Type Description
eExcelConditionalFormattingRuleType

Implements