Skip to main content
A newer version of this page is available. .
.NET Framework 4.5.2+
Row

TableStyleCollection.DefaultPivotStyle Property

Gets or sets the default pivot table style.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.1.Core.dll

Declaration

TableStyle DefaultPivotStyle { get; set; }

Property Value

Type Description
TableStyle

A TableStyle object.

Remarks

Use the DefaultPivotStyle property to specify the default style for pivot tables that can be used in the following cases.

  • If you create a pivot table and do not explicitly specify a style to be applied to the report, the default style will be automatically applied to the created pivot table.
  • If you remove a style that has been previously applied to a pivot table, the pivot table style will be changed to the default style.

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.

SpreadsheetPivotTable_DefaultStyle

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.

See Also