PivotGlobalizationSettings
PivotGlobalizationSettings class
Represents the globalization settings for pivot tables.
new PivotGlobalizationSettings()
Methods
| Name | Description |
|---|---|
| getNameOfDataField() | |
| getShortTextOf12Months() | Gets all short formatted string of 12 months. |
| getTextOf4Quaters() | Gets the local text of 4 Quaters. |
| getTextOfAll() | Gets the text of “(All)” label in the PivotTable. |
| getTextOfAllPeriods() | |
| getTextOfColumnLabels() | Gets the text of “Column Labels” label in the PivotTable. |
| getTextOfDataFieldHeader() | Gets the the text of the value area field header in the PivotTable. |
| getTextOfDays() | Gets the local text of “Days”. |
| getTextOfEmptyData() | Gets the text of “(blank)” label in the PivotTable. |
| getTextOfGrandTotal() | Gets the text of “Grand Total” label in the PivotTable. |
| getTextOfHours() | Gets the local text of “Hours”. |
| getTextOfMinutes() | Gets the local text of “Minutes”. |
| getTextOfMonths() | Gets the local text of “Months”. |
| getTextOfMultipleItems() | Gets the text of “(Multiple Items)” label in the PivotTable. |
| getTextOfProtectedName(protectedName) | Gets the text for specified protected name. In Ms Excel, some names are not allowed to be used as the name of PivotField |
| getTextOfProtection() | Gets the protection name in the PivotTable. NOTE: This member is now obsolete. Instead, please use PivotGlobalizationSet |
| getTextOfQuarters() | Get the local text of “Quarters”. |
| getTextOfRange() | Gets the local text of “Range” |
| getTextOfRowLabels() | Gets the text of “Row Labels” label in the PivotTable. |
| getTextOfSeconds() | Gets the local text of “Seconds” |
| getTextOfSubTotal(subTotalType) | Gets the text of PivotFieldSubtotalType type in the PivotTable. |
| getTextOfTotal() | Gets the text of “Total” label in the PivotTable. You need to override this method when the PivotTable contains two or m |
| getTextOfYears() | Gets the local text of “Years”. |
getNameOfDataField()
getShortTextOf12Months()
Gets all short formatted string of 12 months.
Returns: Array of String — Array of String
getTextOf4Quaters()
Gets the local text of 4 Quaters.
Returns: Array of String — Array of String
getTextOfAll()
Gets the text of “(All)” label in the PivotTable.
Returns: String — String The text of “(All)” label
getTextOfAllPeriods()
getTextOfColumnLabels()
Gets the text of “Column Labels” label in the PivotTable.
Returns: String — String The text of column labels
getTextOfDataFieldHeader()
Gets the the text of the value area field header in the PivotTable.
Returns: String — String The text of data field header name
getTextOfDays()
Gets the local text of “Days”.
Returns: String — String
getTextOfEmptyData()
Gets the text of “(blank)” label in the PivotTable.
Returns: String — String The text of empty data
getTextOfGrandTotal()
Gets the text of “Grand Total” label in the PivotTable.
Returns: String — String The text of “Grand Total” label
getTextOfHours()
Gets the local text of “Hours”.
Returns: String — String
getTextOfMinutes()
Gets the local text of “Minutes”.
Returns: String — String
getTextOfMonths()
Gets the local text of “Months”.
Returns: String — String
getTextOfMultipleItems()
Gets the text of “(Multiple Items)” label in the PivotTable.
Returns: String — String The text of “(Multiple Items)” label
getTextOfProtectedName(protectedName)
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 | Type | Description |
|---|---|---|
| protectedName | String | The protected name in PivotTable. |
Returns: String — 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()
Get the local text of “Quarters”.
Returns: String — String
getTextOfRange()
Gets the local text of “Range”
Returns: String — String
getTextOfRowLabels()
Gets the text of “Row Labels” label in the PivotTable.
Returns: String — String The text of row labels
getTextOfSeconds()
Gets the local text of “Seconds”
Returns: String — String
getTextOfSubTotal(subTotalType)
Gets the text of PivotFieldSubtotalType type in the PivotTable.
| Parameter | Type | Description |
|---|---|---|
| subTotalType | Number | PivotFieldSubtotalType |
Returns: String — String The text of given type
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.
Returns: String — String The text of “Total” label
getTextOfYears()
Gets the local text of “Years”.
Returns: String — String