GemBox.Spreadsheet.ConditionalFormatting Namespace

Contains types used to format cells conditionally based on their values. GemBox.Spreadsheet, currently, supports reading and writing Conditional Formatting to XLSX format only.

Classes

AboveOrBelowAverageCondition	Represents a condition that formats only cells with values that are above or below average.
ColorScaleCondition	Represents a condition that formats fill of all cells based on their values using a specified 2-point or 3-point color scale.
ConditionalColor	Represents a conditional color used in ColorScaleCondition of a conditional formatting rule to specify color scale point.
ConditionalFormatRule	Represents a conditional formatting rule.
ConditionalFormatRuleCollection	Represents a collection of a conditional formatting rules. Rules are applied in the order they appear in the collection (first rule has highest priority and last rule has lowest priority). Newly added rules are inserted at the beginning of the collection so they are first applied.
ConditionalIcon	Represents a conditional icon used in IconSetCondition of a conditional formatting rule to specify icon and a lower bound of the values onto which the icon is applied.
ConditionalIconCollection	Represents a collection of conditional icons used in IconSetCondition of a conditional formatting rule.
ConditionalLength	Represents a conditional length used in DataBarCondition of a conditional formatting rule to specify data bar length.
ConditionalObject	Represents a base class for conditional objects used in conditional formatting.
ConditionalObjectCollection	Represents a base class for a collections of ConditionalObjects used in conditional formatting.
ConditionalObjectCollection<T>	Represents a base class for a collections of ConditionalObject-derived instances used in conditional formatting.
ContainCondition	Represents a condition that formats only cells that contain value which satisfies the specified criteria.
ContainDateCondition	Represents a condition that formats only cells with date that satisfies the specified criteria.
ContainTextCondition	Represents a condition that formats only cells with text that satisfies the specified criteria.
ContainValueCondition	Represents a condition that formats only cells with value that satisfies the specified criteria.
DataBarCondition	Represents a condition that formats all cells based on their values by displaying a data bar whose length is proportional to cell's value.
DataBarStyle	Represents an appearance settings of a data bar.
FormatCondition	Represents a base class for all conditions that can be specified in a conditional formatting rule.
FormulaCondition	Represents a condition that formats only cells for which the specified formula result evaluates to true.
IconSetCondition	Represents a condition that formats all cells based on their values by displaying an icon from the specified icon set according to cell's value.
TopOrBottomRankedCondition	Represents a condition that formats only cells with top or bottom ranked values.
UniqueOrDuplicateCondition	Represents a condition that formats only cells with unique or duplicate values.

Structs

ConditionalValue

Represents a conditional value used in conditional formatting rules which format all cells based on their values (ColorScaleCondition, DataBarCondition and IconSetCondition).

Enums

ConditionalValueType	Represents a ConditionalValue type.
ContainConditionType	Represents a ContainCondition type.
ContainDateOperator	Represents a ContainDateCondition operator.
ContainTextOperator	Represents a ContainTextCondition operator.
ContainValueOperator	Represents a ContainValueCondition operator.
DataBarAxisPosition	Represents a data bar axis position.
DataBarDirection	Represents a data bar direction.
FormatConditionType	Represents a FormatCondition type.