Class ExcelConditionalFormattingRule

Namespace

OfficeOpenXml.ConditionalFormatting

Assembly

Magicodes.EPPlus.dll

public abstract class ExcelConditionalFormattingRule : XmlHelper, IExcelConditionalFormattingRule

Inheritance

object

XmlHelper

ExcelConditionalFormattingRule

Implements

IExcelConditionalFormattingRule

Derived

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

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Extension Methods

ExtensionMethods.IsNumeric(object)

Properties

AboveAverage

protected bool? AboveAverage { get; set; }

Property Value

bool?

Address

public ExcelAddress Address { get; set; }

Property Value

ExcelAddress

Bottom

protected bool? Bottom { get; set; }

Property Value

bool?

EqualAverage

protected bool? EqualAverage { get; set; }

Property Value

bool?

Formula

public string Formula { get; set; }

Property Value

string

Formula2

public string Formula2 { get; set; }

Property Value

string

Node

public XmlNode Node { get; }

Property Value

XmlNode

Operator

protected eExcelConditionalFormattingOperatorType Operator { get; set; }

Property Value

eExcelConditionalFormattingOperatorType

Percent

protected bool? Percent { get; set; }

Property Value

bool?

Priority

public int Priority { get; set; }

Property Value

int

Rank

public ushort Rank { get; set; }

Property Value

ushort

StdDev

public ushort StdDev { get; set; }

Property Value

ushort

StopIfTrue

public bool StopIfTrue { get; set; }

Property Value

bool

Style

public ExcelDxfStyleConditionalFormatting Style { get; }

Property Value

ExcelDxfStyleConditionalFormatting

TimePeriod

protected eExcelConditionalFormattingTimePeriodType TimePeriod { get; set; }

Property Value

eExcelConditionalFormattingTimePeriodType

Type

public eExcelConditionalFormattingRuleType Type { get; }

Property Value

eExcelConditionalFormattingRuleType