IPivotTableOptions module

class IPivotTableOptions.IPivotTableOptions

Bases: SpireObject

property ColumnHeaderCaption: str

property DataPosition: Int16

property DisplayErrorString: bool

property DisplayFieldCaptions: bool

property DisplayNullString: bool

property EnableFieldProperties: bool

property ErrorString: str

property Indent: UInt32

property IsAutoFormat: bool

<summary>

Indicates whether the PivotTable has an autoformat applied.: Checkbox “autofit column width on update”which in pivot table Options :Layout Format for Excel 2007

</summary>

property IsDataEditable: bool

property IsSaveData: bool

property MergeLabels: bool

property NullString: str

property PageFieldWrapCount: int

property PageFieldsOrder: PivotPageAreaFieldsOrderType

property PreserveFormatting: bool

property PrintTitles: bool

property ReportLayout: PivotTableLayoutType

property RowHeaderCaption: str

property RowLayout: PivotTableLayoutType

property ShowAsteriskTotals: bool

property ShowCustomSortList: bool

property ShowDrillIndicators: bool

property ShowFieldList: bool

property ShowGridDropZone: bool

property ShowTooltips: bool