PivotGridFormatRule.Settings Property

Provides access to format rule settings used to apply conditional formatting to data cells.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v24.1.dll

NuGet Package: DevExpress.Win.PivotGrid

Declaration

C#

[XtraSerializableProperty(XtraSerializationVisibility.Content, 100)]
[DXCategory("Behavior")]
public FormatRuleSettings Settings { get; set; }

VB.NET

<XtraSerializableProperty(XtraSerializationVisibility.Content, 100)>
<DXCategory("Behavior")>
Public Property Settings As FormatRuleSettings

Property Value

Type	Description
FormatRuleSettings	The FormatRuleSettings object, that is used to apply conditional formatting to data cells.

Remarks

To specify the PivotGridFormatRule.Settings property in code, create a new FormatRuleFieldIntersectionSettings or FormatRuleTotalTypeSettings class object and define its parameters.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the Settings property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

winforms-pivot-grid-apply-format-rules-to-data-cells/CS/WinFormsPivotGridFormatRules/Form1.cs#L15

// Creates and specifies a new Settings object.
newRule.Settings = new FormatRuleFieldIntersectionSettings{
    Column = fieldOrderYear1,

VB.NET

winforms-pivot-grid-apply-format-rules-to-data-cells/VB/WinFormsPivotGridFormatRules/Form1.vb#L18

' Creates and specifies a new Settings object.
newRule.Settings = New FormatRuleFieldIntersectionSettings With {.Column = fieldOrderYear1, .Row = fieldSalesPerson}
' Creates a new Rule object and sets its parameters.