TdxSpreadSheetConditionalFormattingRuleDataBar.MaxValue Property

Specifies the “Data Bar“ conditional formatting rule’s maximum threshold value.

Declaration

property MaxValue: TdxSpreadSheetConditionalFormattingRuleCustomScaleStop index 1 read; write;

Property Value

Type
TdxSpreadSheetConditionalFormattingRuleCustomScaleStop

Remarks

The MaxValue and MinValue properties specify the maximum and minimum numeric values that the “Data Bar” conditional formatting rule can visualize as data bars within the affected cell area(s). The rule does not display data bars in those cells whose values are outside the range between the minimum and maximum thresholds.

The MaxValue.Value and MaxValue.ValueType properties specify the rule’s maximum threshold value and how the conditional formatting controller interprets it, respectively. For instance, the controller uses the maximum numeric value within the affected cell area(s) as the maximum data bar threshold by default (that is, if the MaxVaue.ValueType property is set to cssvtLimitValue), ignoring the MaxValue.Value property value.

Refer to the TdxSpreadSheetConditionalFormattingRuleCustomScaleStop class description for detailed information on all available options.