PivotGlobalizationSettings
PivotGlobalizationSettings class
Represents the globalization settings for pivot tables.
class PivotGlobalizationSettings;
Constructors
Name | Description |
---|---|
constructor() | Default Constructor. |
Methods
Method | Description |
---|---|
abstract 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. |
abstract getTextOfGrandTotal() | Gets the text of “Grand Total” label in the PivotTable. |
abstract getTextOfMultipleItems() | Gets the text of “(Multiple Items)” label in the PivotTable. |
abstract getTextOfAll() | Gets the text of “(All)” label in the PivotTable. |
abstract getTextOfProtectedName(string) | Gets the text for specified protected name. |
abstract getTextOfColumnLabels() | Gets the text of “Column Labels” label in the PivotTable. |
abstract getTextOfRowLabels() | Gets the text of “Row Labels” label in the PivotTable. |
abstract getTextOfEmptyData() | Gets the text of “(blank)” label in the PivotTable. |
abstract getTextOfDataFieldHeader() | Gets the the text of the value area field header in the PivotTable. |
abstract getShortTextOf12Months() | Gets all short formatted string of 12 months. |
abstract getTextOf4Quaters() | Gets the local text of 4 Quaters. |
abstract getTextOfYears() | Gets the local text of “Years”. |
abstract getTextOfQuarters() | Get the local text of “Quarters”. |
abstract getTextOfMonths() | Gets the local text of “Months”. |
abstract getTextOfDays() | Gets the local text of “Days”. |
abstract getTextOfHours() | Gets the local text of “Hours”. |
abstract getTextOfMinutes() | Gets the local text of “Minutes”. |
abstract getTextOfSeconds() | Gets the local text of “Seconds” |
abstract getTextOfRange() | Gets the local text of “Range” |
abstract 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.
abstract getTextOfTotal() : string;
Returns
The text of “Total” label
getTextOfGrandTotal()
Gets the text of “Grand Total” label in the PivotTable.
abstract getTextOfGrandTotal() : string;
Returns
The text of “Grand Total” label
getTextOfMultipleItems()
Gets the text of “(Multiple Items)” label in the PivotTable.
abstract getTextOfMultipleItems() : string;
Returns
The text of “(Multiple Items)” label
getTextOfAll()
Gets the text of “(All)” label in the PivotTable.
abstract getTextOfAll() : string;
Returns
The text of “(All)” label
getTextOfProtectedName(string)
Gets the text for specified protected name.
abstract getTextOfProtectedName(protectedName: string) : string;
Parameters:
Parameter | Type | Description |
---|---|---|
protectedName | string | The 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.
abstract getTextOfColumnLabels() : string;
Returns
The text of column labels
getTextOfRowLabels()
Gets the text of “Row Labels” label in the PivotTable.
abstract getTextOfRowLabels() : string;
Returns
The text of row labels
getTextOfEmptyData()
Gets the text of “(blank)” label in the PivotTable.
abstract getTextOfEmptyData() : string;
Returns
The text of empty data
getTextOfDataFieldHeader()
Gets the the text of the value area field header in the PivotTable.
abstract getTextOfDataFieldHeader() : string;
Returns
The text of data field header name
getShortTextOf12Months()
Gets all short formatted string of 12 months.
abstract getShortTextOf12Months() : string[];
Returns
string[]
getTextOf4Quaters()
Gets the local text of 4 Quaters.
abstract getTextOf4Quaters() : string[];
Returns
string[]
getTextOfYears()
Gets the local text of “Years”.
abstract getTextOfYears() : string;
getTextOfQuarters()
Get the local text of “Quarters”.
abstract getTextOfQuarters() : string;
getTextOfMonths()
Gets the local text of “Months”.
abstract getTextOfMonths() : string;
getTextOfDays()
Gets the local text of “Days”.
abstract getTextOfDays() : string;
getTextOfHours()
Gets the local text of “Hours”.
abstract getTextOfHours() : string;
getTextOfMinutes()
Gets the local text of “Minutes”.
abstract getTextOfMinutes() : string;
getTextOfSeconds()
Gets the local text of “Seconds”
abstract getTextOfSeconds() : string;
getTextOfRange()
Gets the local text of “Range”
abstract getTextOfRange() : string;
getTextOfSubTotal(PivotFieldSubtotalType)
Gets the text of PivotFieldSubtotalType type in the PivotTable.
abstract getTextOfSubTotal(subTotalType: PivotFieldSubtotalType) : string;
Parameters:
Parameter | Type | Description |
---|---|---|
subTotalType | PivotFieldSubtotalType | The PivotFieldSubtotalType |
Returns
The text of given type