Back to Devexpress

dxSpreadSheetConditionalFormattingRules Unit

vcl-dxspreadsheetconditionalformattingrules-48804a7b.md

latest8.6 KB
Original Source

dxSpreadSheetConditionalFormattingRules Unit

Classes

NameDescription
TdxSpreadSheetConditionalFormattingExpressionStores a parsed formula expression used by conditional formatting rules.
TdxSpreadSheetConditionalFormattingRuleAboveOrBelowAverageAn Above or Below Average conditional formatting rule.
TdxSpreadSheetConditionalFormattingRuleCellIsA Cell Is conditional formatting rule.
TdxSpreadSheetConditionalFormattingRuleColorScaleStopA gradient stop used by the color scale-based conditional formatting rules.
TdxSpreadSheetConditionalFormattingRuleCustomColorScaleThe base class for all classes that implement color scale-based conditional formatting rules.
TdxSpreadSheetConditionalFormattingRuleCustomScaleThe base class for all classes that implement threshold-based conditional formatting rules.
TdxSpreadSheetConditionalFormattingRuleCustomScaleStopThe base class for all classes that implement threshold values for cell range evaluation.
TdxSpreadSheetConditionalFormattingRuleDataBarA Data Bar conditional formatting rule.
TdxSpreadSheetConditionalFormattingRuleDataBarStyleStores appearance settings of data bars displayed by a Data Bar conditional formatting rule in its affected cell areas.
TdxSpreadSheetConditionalFormattingRuleDuplicateValuesA Duplicate Values conditional formatting rule.
TdxSpreadSheetConditionalFormattingRuleExpressionAn Expression conditional formatting rule.
TdxSpreadSheetConditionalFormattingRuleIconSetAn Icon Set conditional formatting rule.
TdxSpreadSheetConditionalFormattingRuleIconSetStopA threshold value used as a criterion for applying a specific icon to data cells affected by the Icon Set conditional formatting rule.
TdxSpreadSheetConditionalFormattingRuleStyleBasedThe base class for all classes that implement conditional formatting rules that apply custom style settings to cells for which the formatting conditions are met.
TdxSpreadSheetConditionalFormattingRuleThreeColorScaleA Three Color Scale conditional formatting rule.
TdxSpreadSheetConditionalFormattingRuleTopBottomValuesA Top/Bottom Values conditional formatting rule.
TdxSpreadSheetConditionalFormattingRuleTwoColorScaleA Two Color Scale conditional formatting rule.
TdxSpreadSheetConditionalFormattingRuleUniqueValuesA Unique Values conditional formatting rule.

Enums

NameDescription
TdxSpreadSheetConditionalFormattingRuleAboveOrBelowAverageComparisonOperatorEnumerates cell value comparison operators for calculating the Abover or Below Average rule’s formatting condition.
TdxSpreadSheetConditionalFormattingRuleCellIsComparisonOperatorEnumerates available criteria under which a Cell Is conditional formatting rule applies custom formatting to cells within the affected areas.
TdxSpreadSheetConditionalFormattingRuleCustomScaleStopValueTypeEnumerates threshold value intepretation modes.
TdxSpreadSheetConditionalFormattingRuleDataBarAxisPositionEnumerates cell axis display modes for data bars.
TdxSpreadSheetConditionalFormattingRuleDataBarDirectionEnumerates the data bar direction options.
TdxSpreadSheetConditionalFormattingRuleDataBarFillModeEnumerates data bar fill modes.
TdxSpreadSheetConditionalFormattingRuleIconSetOrderEnumerates options of the index order within an icon preset.
TdxSpreadSheetConditionalFormattingRuleIconSetStopComparisonOperatorEnumerates operators used to compare a threshold to values in the cells affected in an “Icon Set“ conditional formatting rule.
TdxSpreadSheetConditionalFormattingRuleTopBottomValuesDirectionEnumerates available cell formatting conditions in a Top/Bottom Values conditional formatting rule.
TdxSpreadSheetConditionalFormattingRuleTopBottomValuesValueTypeEnumerates available formatted cell number interpretation modes in a “Top/Bottom Values“ conditional formatting rule.