Class ExcelPivotTableConditionalFormatting
Defines a pivot table area of selection used for styling.
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: OfficeOpenXml.Table.PivotTable
Assembly: EPPlus.dll
Syntax
public class ExcelPivotTableConditionalFormatting : XmlHelperProperties
Areas
A collection of conditions for the conditional formattings. Conditions can be set for specific row-, column- or data fields. Specify labels, data grand totals and more.
Declaration
public ExcelPivotTableAreaConditionalFormattingCollection Areas { get; }Property Value
| Type | Description |
|---|---|
| ExcelPivotTableAreaConditionalFormattingCollection |
ConditionalFormatting
Access to the style property for the pivot area
Declaration
public IExcelConditionalFormattingRule ConditionalFormatting { get; }Property Value
| Type | Description |
|---|---|
| IExcelConditionalFormattingRule |
Scope
The scope of the pivot table conditional formatting rule. Default is Selection.
Declaration
public ConditionScope Scope { get; set; }Property Value
| Type | Description |
|---|---|
| ConditionScope |
Type
The condition type of the pivot table conditional formatting rule. Default is None. This property only apply to condional formattings for above/below -average, -stdev amd top or bottom.
Declaration
public ConditionType Type { get; set; }Property Value
| Type | Description |
|---|---|
| ConditionType |
Exceptions
| Type | Condition |
|---|---|
| System.InvalidOperationException | If setting this property to Row or Column when having an unsupported conditional formatting rule. |