Table of Contents

Interface IPivotTableOptions

Namespace
Spire.Xls.Core
Assembly
Spire.XLS.dll
public interface IPivotTableOptions

Properties

ColumnHeaderCaption 

string ColumnHeaderCaption { get; set; }

Property Value

string

DataPosition 

short DataPosition { get; set; }

Property Value

short

DisplayErrorString 

bool DisplayErrorString { get; set; }

Property Value

bool

DisplayFieldCaptions 

bool DisplayFieldCaptions { get; set; }

Property Value

bool

DisplayNullString 

bool DisplayNullString { get; set; }

Property Value

bool

EnableFieldProperties 

bool EnableFieldProperties { get; set; }

Property Value

bool

ErrorString 

string ErrorString { get; set; }

Property Value

string

Indent 

uint Indent { get; set; }

Property Value

uint

IsAutoFormat

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

bool IsAutoFormat { get; set; }

Property Value

bool

IsDataEditable 

bool IsDataEditable { get; set; }

Property Value

bool

IsSaveData 

bool IsSaveData { get; set; }

Property Value

bool

MergeLabels 

bool MergeLabels { get; set; }

Property Value

bool

NullString 

string NullString { get; set; }

Property Value

string

PageFieldWrapCount 

int PageFieldWrapCount { get; set; }

Property Value

int

PageFieldsOrder 

PivotPageAreaFieldsOrderType PageFieldsOrder { get; set; }

Property Value

PivotPageAreaFieldsOrderType

PreserveFormatting 

bool PreserveFormatting { get; set; }

Property Value

bool

PrintTitles 

bool PrintTitles { get; set; }

Property Value

bool

ReportLayout 

PivotTableLayoutType ReportLayout { get; set; }

Property Value

PivotTableLayoutType

RowHeaderCaption 

string RowHeaderCaption { get; set; }

Property Value

string

RowLayout 

PivotTableLayoutType RowLayout { get; set; }

Property Value

PivotTableLayoutType

ShowAsteriskTotals 

bool ShowAsteriskTotals { get; set; }

Property Value

bool

ShowCustomSortList 

bool ShowCustomSortList { get; set; }

Property Value

bool

ShowDrillIndicators 

bool ShowDrillIndicators { get; set; }

Property Value

bool

ShowFieldList 

bool ShowFieldList { get; set; }

Property Value

bool

ShowGridDropZone 

bool ShowGridDropZone { get; set; }

Property Value

bool

ShowTooltips 

bool ShowTooltips { get; set; }

Property Value

bool