windowsforms-devexpress-dot-xtrapivotgrid-dot-pivotgridformatrule-b9268e67.md
Provides access to format rule settings used to apply conditional formatting to data cells.
Namespace : DevExpress.XtraPivotGrid
Assembly : DevExpress.XtraPivotGrid.v25.2.dll
NuGet Package : DevExpress.Win.PivotGrid
[XtraSerializableProperty(XtraSerializationVisibility.Content, 100)]
[DXCategory("Behavior")]
public FormatRuleSettings Settings { get; set; }
<XtraSerializableProperty(XtraSerializationVisibility.Content, 100)>
<DXCategory("Behavior")>
Public Property Settings As FormatRuleSettings
| Type | Description |
|---|---|
| FormatRuleSettings |
The FormatRuleSettings object, that is used to apply conditional formatting to data cells.
|
To specify the PivotGridFormatRule.Settings property in code, create a new FormatRuleFieldIntersectionSettings or FormatRuleTotalTypeSettings class object and define its parameters.
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.
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,
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.
See Also