SettablePivotGlobalizationSettings

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.

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.

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.

setTextOfColumnLabels(text)

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

setTextOfDataFieldHeader(text)

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

setTextOfEmptyData(text)

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

setTextOfGrandTotal(text)

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

setTextOfMultipleItems(text)

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

setTextOfProtectedName(protectedName, text)

Sets the text for specific protected name.

setTextOfRowLabels(text)

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

setTextOfSubTotal(subTotalType, text)

Sets the text of PivotFieldSubtotalType type in the PivotTable.

setTextOfTotal(text)

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