Click or drag to resize

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
  ClassDescription
Public classAboveOrBelowAverageCondition
Represents a condition that formats only cells with values that are above or below average.
Public classColorScaleCondition
Represents a condition that formats fill of all cells based on their values using a specified 2-point or 3-point color scale.
Public classConditionalColor
Represents a conditional color used in ColorScaleCondition of a conditional formatting rule to specify color scale point.
Public classConditionalFormatRule
Represents a conditional formatting rule.
Public classConditionalFormatRuleCollection

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.

Public classConditionalIcon
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.
Public classConditionalIconCollection
Represents a collection of conditional icons used in IconSetCondition of a conditional formatting rule.
Public classConditionalLength
Represents a conditional length used in DataBarCondition of a conditional formatting rule to specify data bar length.
Public classConditionalObject
Represents a base class for conditional objects used in conditional formatting.
Public classConditionalObjectCollection
Represents a base class for a collections of ConditionalObjects used in conditional formatting.
Public classConditionalObjectCollectionT
Represents a base class for a collections of ConditionalObject-derived instances used in conditional formatting.
Public classContainCondition
Represents a condition that formats only cells that contain value which satisfies the specified criteria.
Public classContainDateCondition
Represents a condition that formats only cells with date that satisfies the specified criteria.
Public classContainTextCondition
Represents a condition that formats only cells with text that satisfies the specified criteria.
Public classContainValueCondition
Represents a condition that formats only cells with value that satisfies the specified criteria.
Public classDataBarCondition
Represents a condition that formats all cells based on their values by displaying a data bar whose length is proportional to cell's value.
Public classDataBarStyle
Represents an appearance settings of a data bar.
Public classFormatCondition
Represents a base class for all conditions that can be specified in a conditional formatting rule.
Public classFormulaCondition
Represents a condition that formats only cells for which the specified formula result evaluates to .
Public classIconSetCondition
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.
Public classTopOrBottomRankedCondition
Represents a condition that formats only cells with top or bottom ranked values.
Public classUniqueOrDuplicateCondition
Represents a condition that formats only cells with unique or duplicate values.
Structures
  StructureDescription
Public structureConditionalValue
Represents a conditional value used in conditional formating rules which format all cells based on their values (ColorScaleCondition, DataBarCondition and IconSetCondition).
Enumerations
  EnumerationDescription
Public enumerationConditionalValueType
Represents a ConditionalValue type.
Public enumerationContainConditionType
Represents a ContainCondition type.
Public enumerationContainDateOperator
Represents a ContainDateCondition operator.
Public enumerationContainTextOperator
Represents a ContainTextCondition operator.
Public enumerationContainValueOperator
Represents a ContainValueCondition operator.
Public enumerationDataBarAxisPosition
Represents a data bar axis position.
Public enumerationDataBarDirection
Represents a data bar direction.
Public enumerationFormatConditionType
Represents a FormatCondition type.