Syncfusion.XlsIO.Base
Properties  Methods 

Syncfusion.XlsIO Namespace : IPivotTableOptions Interface

IPivotTableOptions Interface Members

The following tables list the members exposed by IPivotTableOptions.

Public Properties
 NameDescription
 Property Gets or sets the string to be displayed in column header of pivot table in compact layout mode.  
 Property Gets or sets a Boolean value indicating whether custom error string in cells that contain errors must be shown or not.  
 Property Gets or sets a Boolean value indicating whether filter buttons and PivotField captions for rows and columns are displayed in the grid or not.The default value is True.  
 Property Gets or sets a Boolean value indicating whether custom string in cells that contain null value must be shown or not.  
 Property Gets or sets a Boolean value indicating whether field properties are enabled or not.  
 Property Gets or sets the string displayed in cells that contain errors when the DisplayErrorString property is True.  
 Property Gets or sets the indentation increment for compact axis so as to set the Report Layout to Compact Form.  
 Property Gets or sets a Boolean value indicating whether the data area of the PivotTable is editable.  
 Property Gets or sets a Boolean value indicating whether PivotTable report is saved with the workbook or not. The default value is true.  
 Property Gets or sets a Boolean value indicating whether the label must be merged or not.  
 Property Gets or sets the string displayed in cells that contain null values when the DisplayNullString property is True.  
 PropertyGets or sets the PivotPageAreaFieldsOrder in which page fields are added to the PivotTable report’s layout.  
 Property Gets or sets the number of page fields in each column or row in the PivotTable report.  
 Property Gets or sets a Boolean value indicating whether to preserve the format. The default value is True.  
 Property Gets or sets a Boolean value indicating whether to set print titles based on pivot table or not. The default value is false.  
 Property Gets or sets the string to be displayed in Row header of pivot table in compact layout mode.  
 PropertyGets or sets the pivot table PivotTableRowLayout settings.  
 Property Gets or sets a Boolean value indicating whether asterisk must be displayed next to totals.  
 Property Gets or sets a Boolean value indicating whether the "custom lists" option is offered when sorting this PivotTable. The default value is True.  
 Property Gets or sets a Boolean value indicating whether to toggle the display of drill indicators in the PivotTable.  
 Property Gets or sets a Boolean value indicating whether the field list must be showed or not. Default value of ShowFieldList is true.  
 Property Gets or sets a Boolean value indicating whether tool-tips should been shown or not.The default value is True.  
Top
Public Methods
 NameDescription
 Method  
Top
See Also