Class PivotViewConditionalFormatSettingBuilder
Inheritance
System.Object
Syncfusion.EJ2.ControlBuilder
PivotViewConditionalFormatSettingBuilder
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: Syncfusion.EJ2.PivotView
Assembly: Syncfusion.AspNetMvc.PivotView.dll
Syntax
public class PivotViewConditionalFormatSettingBuilder : ControlBuilderConstructors
PivotViewConditionalFormatSettingBuilder()
Declaration
public PivotViewConditionalFormatSettingBuilder()PivotViewConditionalFormatSettingBuilder(List<PivotViewConditionalFormatSetting>)
Declaration
public PivotViewConditionalFormatSettingBuilder(List<PivotViewConditionalFormatSetting> collection)Parameters
| Type | Name | Description |
|---|---|---|
| System.Collections.Generic.List<PivotViewConditionalFormatSetting> | 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 PivotViewConditionalFormatSettingBuilder ApplyGrandTotals(bool applyGrandTotals)Parameters
| Type | Name | Description |
|---|---|---|
| System.Boolean | applyGrandTotals |
Returns
| Type |
|---|
| PivotViewConditionalFormatSettingBuilder |
Conditions(Condition)
Allows you to choose the operator type such as equals, greater than, less than, etc. for conditional formatting.
Declaration
public PivotViewConditionalFormatSettingBuilder Conditions(Condition conditions)Parameters
| Type | Name | Description |
|---|---|---|
| Condition | conditions |
Returns
| Type |
|---|
| PivotViewConditionalFormatSettingBuilder |
Label(String)
Allows to set the header text of a specific row/column field to apply conditional formatting.
Declaration
public PivotViewConditionalFormatSettingBuilder Label(string label)Parameters
| Type | Name | Description |
|---|---|---|
| System.String | label |
Returns
| Type |
|---|
| PivotViewConditionalFormatSettingBuilder |
Measure(String)
Allows to set the value field name to apply conditional formatting.
Declaration
public PivotViewConditionalFormatSettingBuilder Measure(string measure)Parameters
| Type | Name | Description |
|---|---|---|
| System.String | measure |
Returns
| Type |
|---|
| PivotViewConditionalFormatSettingBuilder |
Style(PivotViewStyle)
Allows to set the custom styles for the formatting applied values in the pivot table.
Declaration
public PivotViewConditionalFormatSettingBuilder Style(PivotViewStyle style)Parameters
| Type | Name | Description |
|---|---|---|
| PivotViewStyle | style |
Returns
| Type |
|---|
| PivotViewConditionalFormatSettingBuilder |
Style(Action<PivotViewStyleBuilder>)
Declaration
public PivotViewConditionalFormatSettingBuilder Style(Action<PivotViewStyleBuilder> style)Parameters
| Type | Name | Description |
|---|---|---|
| System.Action<PivotViewStyleBuilder> | style |
Returns
| Type |
|---|
| PivotViewConditionalFormatSettingBuilder |
Value1(Double)
Allows you to set the start value for applying conditional formatting.
Declaration
public PivotViewConditionalFormatSettingBuilder Value1(double value1)Parameters
| Type | Name | Description |
|---|---|---|
| System.Double | value1 |
Returns
| Type |
|---|
| PivotViewConditionalFormatSettingBuilder |
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 PivotViewConditionalFormatSettingBuilder Value2(double value2)Parameters
| Type | Name | Description |
|---|---|---|
| System.Double | value2 |
Returns
| Type |
|---|
| PivotViewConditionalFormatSettingBuilder |