Namespace OfficeOpenXml.ConditionalFormatting

Classes

ExcelConditionalFormattingAsType

Provides a simple way to type cast a conditional formatting object to its top level class.

ExcelConditionalFormattingCollection

Collection of all ConditionalFormattings in the workbook

ExcelConditionalFormattingColorScaleValue

ExcelConditionalFormattingIconDataBarValue

18.3.1.11 cfvo (Conditional Format Value Object) Describes the values of the interpolation points in a gradient scale.

ExcelConditionalFormattingRule

Abstract base class for all ConditionalFormattingRules

Interfaces

IRangeConditionalFormatting

Provides functionality for adding Conditional Formatting to a range (ExcelRangeBase). Each method will return a configurable condtional formatting type.

Enums

eDatabarDirection

Direction of Databar

eExcelconditionalFormatting3IconsSetType

18.18.42 ST_IconSetType (Icon Set Type) - Only 3 icons

eExcelconditionalFormatting4IconsSetType

18.18.42 ST_IconSetType (Icon Set Type) - Only 4 icons

eExcelconditionalFormatting5IconsSetType

18.18.42 ST_IconSetType (Icon Set Type) - Only 5 icons

eExcelconditionalFormattingCustomIcon

Enum of all icons for custom iconsets

eExcelconditionalFormattingIconsSetType

18.18.42 ST_IconSetType (Icon Set Type)

eExcelConditionalFormattingOperatorType

Enum for Conditional Formatting Operartor Type ST_ConditionalFormattingOperator §18.18.15

eExcelConditionalFormattingRuleType

Enum for Conditional Format Type ST_CfType §18.18.12. With some changes.

eExcelConditionalFormattingTimePeriodType

Enum for Conditional Formatting Time Period Type ST_TimePeriod §18.18.82

eExcelConditionalFormattingValueObjectNodeType

Enum for Conditional Formatting Value Object Node Type

eExcelConditionalFormattingValueObjectPosition

Enum for Conditional Formatting Value Object Position

eExcelConditionalFormattingValueObjectType

Enum for Conditional Format Value Object Type ST_CfvoType §18.18.13

eExcelDatabarAxisPosition

The position of the axis between positive and negative numbers on databar