PivotGlobalizationSettings

PivotGlobalizationSettings class

Represents the globalization settings for pivot tables.

abstract class PivotGlobalizationSettings;

Constructors

NameDescription
constructor()Default Constructor.

Methods

MethodDescription
getTextOfTotal()Gets the text of “Total” label in the PivotTable. You need to override this method when the PivotTable contains two or more PivotFields in the data area.
getTextOfGrandTotal()Gets the text of “Grand Total” label in the PivotTable.
getTextOfMultipleItems()Gets the text of “(Multiple Items)” label in the PivotTable.
getTextOfAll()Gets the text of “(All)” label in the PivotTable.
getTextOfProtectedName(string)Gets the text for specified protected name.
getTextOfColumnLabels()Gets the text of “Column Labels” label in the PivotTable.
getTextOfRowLabels()Gets the text of “Row Labels” label in the PivotTable.
getTextOfEmptyData()Gets the text of “(blank)” label in the PivotTable.
getTextOfDataFieldHeader()Gets the the text of the value area field header in the PivotTable.
getShortTextOf12Months()Gets all short formatted string of 12 months.
getTextOf4Quaters()Gets the local text of 4 Quaters.
getTextOfYears()Gets the local text of “Years”.
getTextOfQuarters()Get the local text of “Quarters”.
getTextOfMonths()Gets the local text of “Months”.
getTextOfDays()Gets the local text of “Days”.
getTextOfHours()Gets the local text of “Hours”.
getTextOfMinutes()Gets the local text of “Minutes”.
getTextOfSeconds()Gets the local text of “Seconds”
getTextOfRange()Gets the local text of “Range”
getTextOfSubTotal(PivotFieldSubtotalType)Gets the text of PivotFieldSubtotalType type in the PivotTable.

constructor()

Default Constructor.

constructor();

getTextOfTotal()

Gets the text of “Total” label in the PivotTable. You need to override this method when the PivotTable contains two or more PivotFields in the data area.

getTextOfTotal() : string;

Returns

The text of “Total” label

getTextOfGrandTotal()

Gets the text of “Grand Total” label in the PivotTable.

getTextOfGrandTotal() : string;

Returns

The text of “Grand Total” label

getTextOfMultipleItems()

Gets the text of “(Multiple Items)” label in the PivotTable.

getTextOfMultipleItems() : string;

Returns

The text of “(Multiple Items)” label

getTextOfAll()

Gets the text of “(All)” label in the PivotTable.

getTextOfAll() : string;

Returns

The text of “(All)” label

getTextOfProtectedName(string)

Gets the text for specified protected name.

getTextOfProtectedName(protectedName: string) : string;

Parameters:

ParameterTypeDescription
protectedNamestringThe protected name in PivotTable.

Returns

The local prorected names of PivotTable.

Remarks

In Ms Excel, some names are not allowed to be used as the name of PivotFields in PivotTable. They are different in different region, user may specify them explicitly according to the used region.

getTextOfColumnLabels()

Gets the text of “Column Labels” label in the PivotTable.

getTextOfColumnLabels() : string;

Returns

The text of column labels

getTextOfRowLabels()

Gets the text of “Row Labels” label in the PivotTable.

getTextOfRowLabels() : string;

Returns

The text of row labels

getTextOfEmptyData()

Gets the text of “(blank)” label in the PivotTable.

getTextOfEmptyData() : string;

Returns

The text of empty data

getTextOfDataFieldHeader()

Gets the the text of the value area field header in the PivotTable.

getTextOfDataFieldHeader() : string;

Returns

The text of data field header name

getShortTextOf12Months()

Gets all short formatted string of 12 months.

getShortTextOf12Months() : string[];

Returns

string[]

getTextOf4Quaters()

Gets the local text of 4 Quaters.

getTextOf4Quaters() : string[];

Returns

string[]

getTextOfYears()

Gets the local text of “Years”.

getTextOfYears() : string;

getTextOfQuarters()

Get the local text of “Quarters”.

getTextOfQuarters() : string;

getTextOfMonths()

Gets the local text of “Months”.

getTextOfMonths() : string;

getTextOfDays()

Gets the local text of “Days”.

getTextOfDays() : string;

getTextOfHours()

Gets the local text of “Hours”.

getTextOfHours() : string;

getTextOfMinutes()

Gets the local text of “Minutes”.

getTextOfMinutes() : string;

getTextOfSeconds()

Gets the local text of “Seconds”

getTextOfSeconds() : string;

getTextOfRange()

Gets the local text of “Range”

getTextOfRange() : string;

getTextOfSubTotal(PivotFieldSubtotalType)

Gets the text of PivotFieldSubtotalType type in the PivotTable.

getTextOfSubTotal(subTotalType: PivotFieldSubtotalType) : string;

Parameters:

ParameterTypeDescription
subTotalTypePivotFieldSubtotalTypeThe PivotFieldSubtotalType

Returns

The text of given type