Package | Description |
---|---|
com.gembox.spreadsheet |
Contains classes and enums that constitute GemBox.Spreadsheet object model.
|
com.gembox.spreadsheet.conditionalformatting |
Contains types used to format cells conditionally based on their values.
|
Class and Description |
---|
ConditionalFormatRuleCollection
Represents a collection of a conditional formatting rules.
|
Class and Description |
---|
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.
|
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. |
ConditionalLengthCollection
Represents a collection of conditional lengths used in
DataBarCondition of a conditional formatting rule. |
ConditionalObject
Represents a base class for conditional objects used in conditional formatting.
|
ConditionalObjectCollection
Represents a base class for a collections of
ConditionalObject s used in conditional formatting. |
ConditionalObjectCollectionGeneric
Represents a base class for a collections of
ConditionalObject -derived instances used in conditional formatting. |
ConditionalValue
Represents a conditional value used in conditional formatting rules which format all cells based on their values (
ColorScaleCondition , DataBarCondition and IconSetCondition ). |
ConditionalValueType
Represents a
ConditionalValue type. |
ContainCondition
Represents a condition that formats only cells that contain value which satisfies the specified criteria.
|
ContainConditionType
Represents a
ContainCondition type. |
ContainDateCondition
Represents a condition that formats only cells with date that satisfies the specified criteria.
|
ContainDateOperator
Represents a
ContainDateCondition operator. |
ContainTextCondition
Represents a condition that formats only cells with text that satisfies the specified criteria.
|
ContainTextOperator
Represents a
ContainTextCondition operator. |
ContainValueCondition
Represents a condition that formats only cells with value that satisfies the specified criteria.
|
ContainValueOperator
Represents a
ContainValueCondition operator. |
DataBarAxisPosition
Represents a data bar axis position.
|
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.
|
DataBarDirection
Represents a data bar direction.
|
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.
|
FormatConditionType
Represents a
FormatCondition type. |
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.
|
© GemBox d.o.o. — All rights reserved.