XlsxExportOptionsEx.AutoCalcConditionalFormattingIconSetMinValue Property

Gets or sets whether to set the minimum value for the Icon Set conditional formatting rule explicitly.Only available in data-aware export mode.

Namespace: DevExpress.XtraPrinting

Assembly: DevExpress.Printing.v21.2.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

C#

[DefaultValue(DefaultBoolean.Default)]
public DefaultBoolean AutoCalcConditionalFormattingIconSetMinValue { get; set; }

VB.NET

<DefaultValue(DefaultBoolean.Default)>
Public Property AutoCalcConditionalFormattingIconSetMinValue As DefaultBoolean

Property Value

Type	Default	Description
DefaultBoolean	Default	DefaultBoolean.True to specify the conditional formatting rule’s minimum value in the exported document; DefaultBoolean.Default when unspecified and DefaultBoolean.False to leave the rule’s minimum value unassigned.

Available values:

Name	Description
True	true. DefaultBoolean.True has a constant value of 0, while the standard true value corresponds to a value of 1. In Visual Basic, do not use implicit conversion of Boolean values to DefaultBoolean, and vice versa, as the conversion may produce incorrect results.
False	false. DefaultBoolean.False has a constant value of 1, while the standard false value corresponds to a value of 0. In Visual Basic, do not use implicit conversion of Boolean values to DefaultBoolean, and vice versa, as the conversion may produce incorrect results.
Default	The default behavior determined by the control’s logic.

Remarks

The AutoCalcConditionalFormattingIconSetMinValue property can be useful when a control exports the data with the Icon Set Conditional Formatting Rule to the XLSX format. When the property is set to DefaultBoolean.True, the spreadsheet application does not calculate the minimum value for the Icon Set conditional formatting automatically. Instead, it uses the value specified in the rule.

The following pictures illustrates the use of this property.

The source WinForms Data Grid control with conditional formatting looks as follows.

The document exported using different settings is shown in the following table.

AutoCalcConditionalFormattingIconSetMinValue = DefaultBoolean.False	AutoCalcConditionalFormattingIconSetMinValue = DefaultBoolean.True
Icon Set rule’s minimum value parameter is calculated automatically and set to -78.	Icon Set rule’s minimum value parameter is obtained from the document and equals 0.