TdxSpreadSheetConditionalFormattingRuleDataBar.MinValue Property

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

Declaration

property MinValue: TdxSpreadSheetConditionalFormattingRuleCustomScaleStop index 0 read; write;

Property Value

Type
TdxSpreadSheetConditionalFormattingRuleCustomScaleStop

Remarks

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

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