Class PivotFieldListConditionalFormatSettingBuilder

Inheritance
System.Object
Syncfusion.EJ2.ControlBuilder
PivotFieldListConditionalFormatSettingBuilder
Namespace: Syncfusion.EJ2.PivotView
Assembly: Syncfusion.EJ2.dll
Syntax
public class PivotFieldListConditionalFormatSettingBuilder : ControlBuilder

Constructors

PivotFieldListConditionalFormatSettingBuilder()

Declaration
public PivotFieldListConditionalFormatSettingBuilder()

PivotFieldListConditionalFormatSettingBuilder(List<PivotFieldListConditionalFormatSetting>)

Declaration
public PivotFieldListConditionalFormatSettingBuilder(List<PivotFieldListConditionalFormatSetting> collection)
Parameters
Type Name Description
System.Collections.Generic.List<PivotFieldListConditionalFormatSetting> collection

Methods

Add()

Declaration
public void Add()

ApplyGrandTotals(Boolean)

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

Declaration
public PivotFieldListConditionalFormatSettingBuilder ApplyGrandTotals(bool applyGrandTotals)
Parameters
Type Name Description
System.Boolean applyGrandTotals
Returns
Type
PivotFieldListConditionalFormatSettingBuilder

Conditions(Condition)

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

Declaration
public PivotFieldListConditionalFormatSettingBuilder Conditions(Condition conditions)
Parameters
Type Name Description
Condition conditions
Returns
Type
PivotFieldListConditionalFormatSettingBuilder

Label(String)

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

Declaration
public PivotFieldListConditionalFormatSettingBuilder Label(string label)
Parameters
Type Name Description
System.String label
Returns
Type
PivotFieldListConditionalFormatSettingBuilder

Measure(String)

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

Declaration
public PivotFieldListConditionalFormatSettingBuilder Measure(string measure)
Parameters
Type Name Description
System.String measure
Returns
Type
PivotFieldListConditionalFormatSettingBuilder

Style(PivotFieldListStyle)

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

Declaration
public PivotFieldListConditionalFormatSettingBuilder Style(PivotFieldListStyle style)
Parameters
Type Name Description
PivotFieldListStyle style
Returns
Type
PivotFieldListConditionalFormatSettingBuilder

Style(Action<PivotFieldListStyleBuilder>)

Declaration
public PivotFieldListConditionalFormatSettingBuilder Style(Action<PivotFieldListStyleBuilder> style)
Parameters
Type Name Description
System.Action<PivotFieldListStyleBuilder> style
Returns
Type
PivotFieldListConditionalFormatSettingBuilder

Value1(Double)

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

Declaration
public PivotFieldListConditionalFormatSettingBuilder Value1(double value1)
Parameters
Type Name Description
System.Double value1
Returns
Type
PivotFieldListConditionalFormatSettingBuilder

Value2(Double)

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
public PivotFieldListConditionalFormatSettingBuilder Value2(double value2)
Parameters
Type Name Description
System.Double value2
Returns
Type
PivotFieldListConditionalFormatSettingBuilder