Interface IExcelConditionalFormattingRule

Interface for conditional formatting rule

Namespace: Experior.Core.Data.OfficeOpenXml.ConditionalFormatting.Contracts

Assembly: Experior.Core.dll

Syntax

public interface IExcelConditionalFormattingRule

Properties

Address

Range over which these conditional formatting rules apply.

The possible values for this attribute are defined by the ST_Sqref simple type (§18.18.76).

Declaration

ExcelAddress Address { get; set; }

Property Value

Type	Description
ExcelAddress

Node

The 'cfRule' XML node

Declaration

XmlNode Node { get; }

Property Value

Type	Description
System.Xml.XmlNode

Priority

The priority of this conditional formatting rule. This value is used to determine which format should be evaluated and rendered. Lower numeric values are higher priority than higher numeric values, where 1 is the highest priority.

Declaration

int Priority { get; set; }

Property Value

Type	Description
System.Int32

StopIfTrue

If this flag is 1, no rules with lower priority shall 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

Type of conditional formatting rule. ST_CfType §18.18.12.

Declaration

eExcelConditionalFormattingRuleType Type { get; }

Property Value

Type	Description
eExcelConditionalFormattingRuleType