Interface IExcelConditionalFormattingRule
Interface for conditional formatting rule
Namespace: OfficeOpenXml.ConditionalFormatting.Contracts
Assembly: EPPlus.dll
Syntax
public interface IExcelConditionalFormattingRuleProperties
Address
The range over which these conditional formatting rules apply.
Declaration
ExcelAddress Address { get; set; }Property Value
| Type | Description |
|---|---|
| ExcelAddress |
As
Type case propterty for the base class.
Declaration
ExcelConditionalFormattingAsType As { get; }Property Value
| Type | Description |
|---|---|
| ExcelConditionalFormattingAsType |
Node
The 'cfRule' XML node
Declaration
XmlNode Node { get; }Property Value
| Type | Description |
|---|---|
| System.Xml.XmlNode |
PivotTable
Indicates that the conditional formatting is associated with a PivotTable
Declaration
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
int Priority { get; set; }Property Value
| Type | Description |
|---|---|
| System.Int32 |
StopIfTrue
If this property is true, no rules with lower priority should be applied over this rule, when this rule evaluates to true.
Declaration
bool StopIfTrue { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
Style
Gives access to the differencial styling (DXF) for the rule.
Declaration
ExcelDxfStyleConditionalFormatting Style { get; }Property Value
| Type | Description |
|---|---|
| ExcelDxfStyleConditionalFormatting |
Type
The type of conditional formatting rule.
Declaration
eExcelConditionalFormattingRuleType Type { get; }Property Value
| Type | Description |
|---|---|
| eExcelConditionalFormattingRuleType |