officefileapi-devexpress-dot-spreadsheet-dot-tablestylecollection-ba80a7e8.md
Gets or sets the default pivot table style.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
TableStyle DefaultPivotStyle { get; set; }
Property DefaultPivotStyle As TableStyle
| Type | Description |
|---|---|
| TableStyle |
A TableStyle object.
|
Use the DefaultPivotStyle property to specify the default style for pivot tables that can be used in the following cases.
You can set the DefaultPivotStyle property to any pivot table style contained in the collection. If the default pivot table style is not explicitly specified, the PivotStyleLight16 built-in style is used as default. The image below shows the pivot table appearance when the PivotStyleLight16 style is applied.
The following code snippets (auto-collected from DevExpress Examples) contain references to the DefaultPivotStyle property.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.
// Set the default style for the pivot table.
pivotTable.Style = workbook.TableStyles.DefaultPivotStyle;
// Set the default style for the pivot table.
pivotTable.Style = workbook.TableStyles.DefaultPivotStyle;
// Set the default style for the pivot table.
pivotTable.Style = workbook.TableStyles.DefaultPivotStyle;
' Set the default style for the pivot table.
pivotTable.Style = workbook.TableStyles.DefaultPivotStyle
' Set the default style for the pivot table.
pivotTable.Style = workbook.TableStyles.DefaultPivotStyle
' Set the default style for the pivot table.
pivotTable.Style = workbook.TableStyles.DefaultPivotStyle
See Also
How to: Apply a Predefined Style to a Pivot Table
How to: Apply a Custom Style to a Pivot Table