Class ExcelConditionalFormattingRule
Inheritance
Implements
Inherited Members
Namespace: Experior.Core.Data.OfficeOpenXml.ConditionalFormatting
Assembly: Experior.Core.dll
Syntax
public abstract class ExcelConditionalFormattingRule : XmlHelper, IExcelConditionalFormattingRule
Properties
AboveAverage
AboveAverage
Declaration
protected bool? AboveAverage { get; set; }
Property Value
Type | Description |
---|---|
System.Nullable<System.Boolean> |
Address
Address of the conditional formatting rule
Declaration
public ExcelAddress Address { get; set; }
Property Value
Type | Description |
---|---|
ExcelAddress |
Remarks
The address is stores in a parent node called <conditionalFormatting> in the @sqref attribute. Excel groups rules that have the same address inside one node.
Bottom
Bottom attribute
Declaration
protected bool? Bottom { get; set; }
Property Value
Type | Description |
---|---|
System.Nullable<System.Boolean> |
EqualAverage
EqualAverage
Declaration
protected bool? EqualAverage { get; set; }
Property Value
Type | Description |
---|---|
System.Nullable<System.Boolean> |
Formula
Formula
Declaration
public string Formula { get; set; }
Property Value
Type | Description |
---|---|
System.String |
Formula2
Formula2
Declaration
public string Formula2 { get; set; }
Property Value
Type | Description |
---|---|
System.String |
Node
Get the <cfRule> node
Declaration
public XmlNode Node { get; }
Property Value
Type | Description |
---|---|
System.Xml.XmlNode |
Operator
Operator
Declaration
protected eExcelConditionalFormattingOperatorType Operator { get; set; }
Property Value
Type | Description |
---|---|
eExcelConditionalFormattingOperatorType |
Percent
Percent attribute
Declaration
protected bool? Percent { get; set; }
Property Value
Type | Description |
---|---|
System.Nullable<System.Boolean> |
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
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
StdDev (zero is not allowed and will be converted to 1)
Declaration
public ushort StdDev { get; set; }
Property Value
Type | Description |
---|---|
System.UInt16 |
StopIfTrue
If this flag is true, no rules with lower priority shall be applied over this rule, when this rule evaluates to true.
Declaration
public bool StopIfTrue { get; set; }
Property Value
Type | Description |
---|---|
System.Boolean |
Style
Declaration
public ExcelDxfStyleConditionalFormatting Style { get; }
Property Value
Type | Description |
---|---|
ExcelDxfStyleConditionalFormatting |
TimePeriod
TimePeriod
Declaration
protected eExcelConditionalFormattingTimePeriodType TimePeriod { get; set; }
Property Value
Type | Description |
---|---|
eExcelConditionalFormattingTimePeriodType |
Type
Type of conditional formatting rule. ST_CfType §18.18.12.
Declaration
public eExcelConditionalFormattingRuleType Type { get; }
Property Value
Type | Description |
---|---|
eExcelConditionalFormattingRuleType |