Show / Hide Table of Contents

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
XmlHelper.AddSchemaNodeOrder(String[], String[])
XmlHelper.AddSchemaNodeOrder(String[], String[], Int32[])
XmlHelper.GetBoolFromString(String)
XmlHelper.CreatespPrNode(String, Boolean)
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.

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
Back to top Generated by DocFX