Class PivotConditionalFormatSettings

Allows a collection of values fields to change the appearance of the pivot table value cells with different style properties such as background color, font color, font family, and font size based on specific conditions.

Inheritance
object
ComponentBase
OwningComponentBase
SfOwningComponentBase
PivotConditionalFormatSettings
PivotFieldListConditionalFormatSetting
PivotViewConditionalFormatSetting
Implements
Inherited Members
Namespace: Syncfusion.Blazor.PivotView
Assembly: Syncfusion.Blazor.dll
Syntax
public class PivotConditionalFormatSettings : SfOwningComponentBase, IComponent, IHandleEvent, IHandleAfterRender, IDisposable

Constructors

PivotConditionalFormatSettings()

Declaration
public PivotConditionalFormatSettings()

Properties

ApplyGrandTotals

Allows to apply conditional formatting to the grand totals of row and column axis in the pivot table.

Declaration
[Parameter]
[JsonPropertyName("applyGrandTotals")]
public bool ApplyGrandTotals { get; set; }
Property Value
Type
bool

Conditions

Allows you to choose the operator type such as equals, greater than, less than, etc. for conditional formatting.

Declaration
[Parameter]
[JsonPropertyName("conditions")]
[JsonConverter(typeof(JsonStringEnumConverter))]
public Condition Conditions { get; set; }
Property Value
Type
Condition

Label

Allows to set the header text of a specific row/column field to apply conditional formatting.

Declaration
[Parameter]
[JsonPropertyName("label")]
public string Label { get; set; }
Property Value
Type
string

Measure

Allows to set the value field name to apply conditional formatting.

Declaration
[Parameter]
[JsonPropertyName("measure")]
public string Measure { get; set; }
Property Value
Type
string

Value1

Allows you to set the start value for applying conditional formatting.

Declaration
[Parameter]
[JsonPropertyName("value1")]
public double Value1 { get; set; }
Property Value
Type
double

Value2

Allows you to set the end value for applying conditional formatting.

This option will be used by default when the operator Between and NotBetween is chosen to apply.

Declaration
[Parameter]
[JsonPropertyName("value2")]
public double Value2 { get; set; }
Property Value
Type
double

Implements