new SettablePivotGlobalizationSettings()

Methods

getShortTextOf12Months() → Array of String

Gets all short formatted string of 12 months.

Returns

Array of String 

getTextOf4Quaters() → Array of String

Gets the local text of 4 Quaters.

Returns

Array of String 

getTextOfAll() → String

Gets the text of "(All)" label in the PivotTable.

Returns

String The text of "(All)" label

getTextOfColumnLabels() → String

Gets the text of "Column Labels" label in the PivotTable.

Returns

String The text of column labels

getTextOfDataFieldHeader() → String

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

Returns

String The text of data field header name

getTextOfDays() → String

Gets the local text of "Days".

Returns

String 

getTextOfEmptyData() → String

Gets the text of "(blank)" label in the PivotTable.

Returns

String The text of empty data

getTextOfGrandTotal() → String

Gets the text of "Grand Total" label in the PivotTable.

Returns

String The text of "Grand Total" label

getTextOfHours() → String

Gets the local text of "Hours".

Returns

String 

getTextOfMinutes() → String

Gets the local text of "Minutes".

Returns

String 

getTextOfMonths() → String

Gets the local text of "Months".

Returns

String 

getTextOfMultipleItems() → String

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

Returns

String The text of "(Multiple Items)" label

getTextOfProtectedName(protectedName) → String

Gets the text for specified protected name. 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.

Parameter

Name Type Optional Description

protectedName

String

 

The protected name in PivotTable.

Returns

String The local prorected names of PivotTable.

getTextOfProtection()

Gets the protection name in the PivotTable. NOTE: This member is now obsolete. Instead, please use PivotGlobalizationSettings.GetTextOfProtectedName(string) method. This property will be removed 12 months later since March 2023. Aspose apologizes for any inconvenience you may have experienced.@return {String} The protection name of PivotTable

getTextOfQuarters() → String

Get the local text of "Quarters".

Returns

String 

getTextOfRange() → String

Gets the local text of "Range"

Returns

String 

getTextOfRowLabels() → String

Gets the text of "Row Labels" label in the PivotTable.

Returns

String The text of row labels

getTextOfSeconds() → String

Gets the local text of "Seconds"

Returns

String 

getTextOfSubTotal(subTotalType) → String

Gets the text of PivotFieldSubtotalType type in the PivotTable.

Parameter

Name Type Optional Description

subTotalType

Number

 

PivotFieldSubtotalType

Returns

String The text of given type

getTextOfTotal() → String

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.

Returns

String The text of "Total" label

getTextOfYears() → String

Gets the local text of "Years".

Returns

String 

setTextOfAll(text)

Sets the text of "(All)" label in the PivotTable.

Parameter

Name Type Optional Description

text

String

 

custom text

setTextOfColumnLabels(text)

Gets the text of "Column Labels" label in the PivotTable.

Parameter

Name Type Optional Description

text

String

 

The text of column labels

setTextOfDataFieldHeader(text)

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

Parameter

Name Type Optional Description

text

String

 

The text of data field header name

setTextOfEmptyData(text)

Sets the text of "(blank)" label in the PivotTable.

Parameter

Name Type Optional Description

text

String

 

The text of empty data

setTextOfGrandTotal(text)

Sets the text of "Grand Total" label in the PivotTable.

Parameter

Name Type Optional Description

text

String

 

custom text

setTextOfMultipleItems(text)

Sets the text of "(Multiple Items)" label in the PivotTable.

Parameter

Name Type Optional Description

text

String

 

custom text

setTextOfProtectedName(protectedName, text)

Sets the text for specific protected name.

Parameters

Name Type Optional Description

protectedName

String

 

The protected name in PivotTable.

text

String

 

The local prorected names of PivotTable.

setTextOfRowLabels(text)

Sets the text of "Row Labels" label in the PivotTable.

Parameter

Name Type Optional Description

text

String

 

The text of row labels

setTextOfSubTotal(subTotalType, text)

Sets the text of PivotFieldSubtotalType type in the PivotTable.

Parameters

Name Type Optional Description

subTotalType

Number

 

PivotFieldSubtotalType

text

String

 

The text of given type

setTextOfTotal(text)

Sets the text of "Total" label in the PivotTable.

Parameter

Name Type Optional Description

text

String

 

custom text