Class ExcelConditionalFormattingRule

Inheritance

System.Object

XmlHelper

ExcelConditionalFormattingRule

ExcelConditionalFormattingAboveStdDev

ExcelConditionalFormattingAverageGroup

ExcelConditionalFormattingBeginsWith

ExcelConditionalFormattingBelowStdDev

ExcelConditionalFormattingBetween

ExcelConditionalFormattingBottom

ExcelConditionalFormattingBottomPercent

ExcelConditionalFormattingContainsBlanks

ExcelConditionalFormattingContainsErrors

ExcelConditionalFormattingContainsText

ExcelConditionalFormattingDataBar

ExcelConditionalFormattingDuplicateValues

ExcelConditionalFormattingEndsWith

ExcelConditionalFormattingEqual

ExcelConditionalFormattingExpression

ExcelConditionalFormattingGreaterThan

ExcelConditionalFormattingGreaterThanOrEqual

ExcelConditionalFormattingIconSetBase<T>

ExcelConditionalFormattingLessThan

ExcelConditionalFormattingLessThanOrEqual

ExcelConditionalFormattingNotBetween

ExcelConditionalFormattingNotContainsBlanks

ExcelConditionalFormattingNotContainsErrors

ExcelConditionalFormattingNotContainsText

ExcelConditionalFormattingNotEqual

ExcelConditionalFormattingThreeColorScale

ExcelConditionalFormattingTimePeriodGroup

ExcelConditionalFormattingTop

ExcelConditionalFormattingTopPercent

ExcelConditionalFormattingTwoColorScale

ExcelConditionalFormattingUniqueValues

Implements

IExcelConditionalFormattingRule

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 : XmlHelper, IExcelConditionalFormattingRule

Properties

AboveAverage

Above average

Declaration

protected bool? AboveAverage { get; set; }

Property Value

Type	Description
System.Nullable<System.Boolean>

Address

The address of the conditional formatting rule

Declaration

public ExcelAddress Address { get; set; }

Property Value

Type	Description
ExcelAddress

Remarks

The address is stored in a parent node called <conditionalFormatting> in the @sqref attribute. Excel groups rules that have the same address inside one node.

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; 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>

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

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 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

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
eExcelConditionalFormattingTimePeriodType

Type

Type of conditional formatting rule.

Declaration

public eExcelConditionalFormattingRuleType Type { get; }

Property Value

Type	Description
eExcelConditionalFormattingRuleType

Methods

SetStyle(ExcelDxfStyleConditionalFormatting)

Declaration

protected void SetStyle(ExcelDxfStyleConditionalFormatting style)

Parameters

Type	Name	Description
ExcelDxfStyleConditionalFormatting	style

Implements

IExcelConditionalFormattingRule