Class ConditionalFormatSettings

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

ConditionalFormatSettings

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Syncfusion.Blazor.PivotView

Assembly: Syncfusion.Blazor.dll

Syntax

public class ConditionalFormatSettings

Constructors

ConditionalFormatSettings()

Declaration

public ConditionalFormatSettings()

Properties

ApplyGrandTotals

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

Declaration

[JsonPropertyName("applyGrandTotals")]
public bool ApplyGrandTotals { get; set; }

Property Value

Type	Description
bool	`true`, if the conditional formatting to the grand total is applied. Otherwise, `false`.

Conditions

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

Declaration

[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

[JsonPropertyName("label")]
public string Label { get; set; }

Property Value

Type	Description
string	Accepts the string value.

Measure

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

Declaration

[JsonPropertyName("measure")]
public string Measure { get; set; }

Property Value

Type	Description
string	Accepts the string value.

Style

Allows to set the custom styles for the formatting applied values in the pivot table.

Declaration

[JsonPropertyName("style")]
public Style Style { get; set; }

Property Value

Type	Description
Style	Accepts the string value.

Value1

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

Declaration

[JsonPropertyName("value1")]
public double Value1 { get; set; }

Property Value

Type	Description
double	Accepts the double value.

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

[JsonPropertyName("value2")]
public double Value2 { get; set; }

Property Value

Type	Description
double	Accepts the double value.