[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Collapse]Office File API
  Demo Application
  Redistribution and Deployment
 [Collapse]Spreadsheet Document API
   Product Structure
   Getting Started
  [Expand]Spreadsheet Document
   Supported Formats
  [Expand]Cell Basics
  [Expand]Formulas
   Defined Names
   Data Binding
  [Expand]Pivot Tables
  [Expand]Charts and Graphics
  [Expand]Mail Merge
  [Collapse]Examples
   [Expand]Files
   [Expand]Workbooks
   [Expand]Worksheets
   [Expand]Rows and Columns
   [Expand]Cells
   [Expand]Formulas
   [Expand]Import and Export Data
   [Expand]Data Binding
    Sorting
   [Expand]Mail Merge
    Search
   [Expand]Shapes
   [Expand]Charts
   [Expand]Sparklines
   [Expand]Formatting Cells
   [Expand]Conditional Formatting
   [Expand]Group Data
   [Expand]Filter Data
   [Expand]Tables
   [Collapse]Pivot Tables
     How to: Create a Pivot Table
     How to: Refresh a Pivot Table
     How to: Change a Data Source for a Pivot Table
     How to: Move a Pivot Table
     How to: Clear or Remove a Pivot Table
     How to: Change the PivotTable Layout
     How to: Subtotal Fields in a Pivot Table
     How to: Display or Hide Grand Totals for a Pivot Table
     How to: Format Numbers and Dates in a Pivot Table
     How to: Apply a Predefined Style to a Pivot Table
     How to: Apply a Custom Style to a Pivot Table
     How to: Control Style Options
     How to: Change the Summary Function for a Data Field
     How to: Apply a Custom Calculation to a Data Field
     How to: Create a Calculated Field
     How to: Create a Calculated Item
     How to: Sort Items in a Pivot Table
     How to: Filter Items in a Pivot Table
     How to: Group Items in a Pivot Table
   [Expand]Printing
   [Expand]Pictures
   [Expand]Protection
 [Expand]Word Processing Document API
 [Expand]PDF Document API
 [Expand]Excel Export Library
 [Expand]Snap Report API
 [Expand]Zip Compression and Archive API
 [Expand]Barcode Generation API
 [Expand]Unit Conversion API
 [Expand]API Reference
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

How to: Control Style Options

A pivot table style consists of a collection of table style elements (TableStyleElement), each of which specifies formatting for a particular element of a pivot table. The TableStyleElementType enumerator lists supported table style element types. The PivotTable object provides specific properties that allow you to configure PivotTable style options by specifying table elements to be formatted as defined by the corresponding elements of the applied pivot table style.

  • Format Row Headers

    Use the PivotTable.ShowRowHeaders property to enable or disable style formatting for row headers in a pivot table. The appearance of row headers is specified by the TableStyleElementType.FirstRowSubheading, TableStyleElementType.SecondRowSubheading and TableStyleElementType.ThirdRowSubheading elements of the applied pivot table style.

  • Format Column Headers

    Use the PivotTable.ShowColumnHeaders property to enable or disable style formatting for column headers in a pivot table. The appearance of column headers is specified by the TableStyleElementType.HeaderRow, TableStyleElementType.FirstColumnSubheading, TableStyleElementType.SecondColumnSubheading and TableStyleElementType.ThirdColumnSubheading elements of the applied pivot table style.

  • Apply Banded Row Formatting

    Set the PivotTable.BandedRows property to true to shade alternate rows in a pivot table as specified by the TableStyleElementType.FirstRowStripe and TableStyleElementType.SecondRowStripe elements of the applied pivot table style. To specify a number of PivotTable rows to be included into odd and even row stripes, use the TableStyleElement.StripeSize property of these table style elements.

  • Apply Banded Column Formatting

    Set the PivotTable.BandedColumns property to true to shade alternate columns in a pivot table as specified by the TableStyleElementType.FirstColumnStripe and TableStyleElementType.SecondColumnStripe elements of the applied pivot table style. To specify the number of PivotTable columns to be displayed as odd and even column stripes, use the TableStyleElement.StripeSize property of these table style elements.

Is this topic helpful?​​​​​​​