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.

ExcelConditionalFormattingLast7Days

ExcelConditionalFormattingLast7Days

ExcelConditionalFormattingLastMonth

ExcelConditionalFormattingLast7Days

ExcelConditionalFormattingLastWeek

ExcelConditionalFormattingLast7Days

ExcelConditionalFormattingNextMonth

ExcelConditionalFormattingLast7Days

ExcelConditionalFormattingNextWeek

ExcelConditionalFormattingLast7Days

ExcelConditionalFormattingRule

Abstract base class for all ConditionalFormattingRules

ExcelConditionalFormattingThisMonth

ExcelConditionalFormattingLast7Days

ExcelConditionalFormattingThisWeek

ExcelConditionalFormattingLast7Days

ExcelConditionalFormattingThreeColorScale

ExcelConditionalFormattingTimePeriodGroup

ExcelConditionalFormattingTimePeriodGroup

ExcelConditionalFormattingToday

ExcelConditionalFormattingLast7Days

ExcelConditionalFormattingTomorrow

ExcelConditionalFormattingLast7Days

ExcelConditionalFormattingTwoColorScale

Two Colour Scale class

ExcelConditionalFormattingYesterday

ExcelConditionalFormattingLast7Days

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