Class ExcelConditionalFormattingRule
Inheritance
System.Object
ExcelConditionalFormattingRule
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()
Assembly: EPPlus.dll
public abstract class ExcelConditionalFormattingRule : XmlHelper, IExcelConditionalFormattingRule
Properties
Declaration
protected bool? AboveAverage { get; set; }
Property Value
| Type |
Description |
| System.Nullable<System.Boolean> |
|
The address of the conditional formatting rule
Declaration
public ExcelAddress Address { get; set; }
Property Value
Declaration
public ExcelConditionalFormattingAsType As { get; }
Property Value
Declaration
protected bool? Bottom { get; set; }
Property Value
| Type |
Description |
| System.Nullable<System.Boolean> |
|
Declaration
protected bool? EqualAverage { get; set; }
Property Value
| Type |
Description |
| System.Nullable<System.Boolean> |
|
Declaration
public string Formula { get; set; }
Property Value
| Type |
Description |
| System.String |
|
Declaration
public string Formula2 { get; set; }
Property Value
| Type |
Description |
| System.String |
|
Declaration
public XmlNode Node { get; }
Property Value
| Type |
Description |
| System.Xml.XmlNode |
|
Declaration
protected eExcelConditionalFormattingOperatorType Operator { get; set; }
Property Value
Declaration
protected bool? Percent { get; set; }
Property Value
| Type |
Description |
| System.Nullable<System.Boolean> |
|
Indicates that the conditional formatting is associated with a PivotTable
Declaration
public bool PivotTable { get; set; }
Property Value
| Type |
Description |
| System.Boolean |
|
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 (zero is not allowed and will be converted to 1)
Declaration
public ushort Rank { get; set; }
Property Value
| Type |
Description |
| System.UInt16 |
|
StdDev (zero is not allowed and will be converted to 1)
Declaration
public ushort StdDev { get; set; }
Property Value
| Type |
Description |
| System.UInt16 |
|
If this property 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 |
|
Declaration
public ExcelDxfStyleConditionalFormatting Style { get; }
Property Value
Declaration
protected eExcelConditionalFormattingTimePeriodType TimePeriod { get; set; }
Property Value
Type of conditional formatting rule.
Declaration
public eExcelConditionalFormattingRuleType Type { get; }
Property Value
Methods
Declaration
protected void SetStyle(ExcelDxfStyleConditionalFormatting style)
Parameters
Implements