aspose.cells

aspose.cells

Class PivotGlobalizationSettings

Represents the globalization settings for pivot tables.

Constructor Summary
PivotGlobalizationSettings()
 
Method Summary
functiongetTextOfAll()
Gets the text of "(All)" label in the PivotTable.
functiongetTextOfColumnLabels()
Gets the text of "Column Labels" label in the PivotTable.
functiongetTextOfDataFieldHeader()
Gets the the text of the value area field header in the PivotTable.
functiongetTextOfEmptyData()
Gets the text of "(blank)" label in the PivotTable.
functiongetTextOfGrandTotal()
Gets the text of "Grand Total" label in the PivotTable.
functiongetTextOfMultipleItems()
Gets the text of "(Multiple Items)" label in the PivotTable.
functiongetTextOfProtectedName(protectedName)
In Excel,some names are not allowed to be the PivotFields' name of PivotTable. They are different in different region.
functiongetTextOfProtection()
Gets the protection name in the PivotTable.
functiongetTextOfRowLabels()
Gets the text of "Row Labels" label in the PivotTable.
functiongetTextOfSubTotal(subTotalType)
Gets the text of PivotFieldSubtotalType type in the PivotTable.
functiongetTextOfTotal()
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.
 

    • Constructor Detail

      • PivotGlobalizationSettings

        function PivotGlobalizationSettings()

    • Method Detail

      • getTextOfTotal

        function 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:
        The text of "Total" label

      • getTextOfGrandTotal

        function getTextOfGrandTotal()
        Gets the text of "Grand Total" label in the PivotTable.
        Returns:
        The text of "Grand Total" label

      • getTextOfMultipleItems

        function getTextOfMultipleItems()
        Gets the text of "(Multiple Items)" label in the PivotTable.
        Returns:
        The text of "(Multiple Items)" label

      • getTextOfAll

        function getTextOfAll()
        Gets the text of "(All)" label in the PivotTable.
        Returns:
        The text of "(All)" label

      • getTextOfProtection

        function 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.
        Returns:
        The protection name of PivotTable

      • getTextOfProtectedName

        function getTextOfProtectedName(protectedName)
        In Excel,some names are not allowed to be the PivotFields' name of PivotTable. They are different in different region.
        Parameters:
        protectedName: String - The protected name in PivotTable.
        Returns:
        The local prorected names of PivotTable.

      • getTextOfColumnLabels

        function getTextOfColumnLabels()
        Gets the text of "Column Labels" label in the PivotTable.
        Returns:
        The text of column labels

      • getTextOfRowLabels

        function getTextOfRowLabels()
        Gets the text of "Row Labels" label in the PivotTable.
        Returns:
        The text of row labels

      • getTextOfEmptyData

        function getTextOfEmptyData()
        Gets the text of "(blank)" label in the PivotTable.
        Returns:
        The text of empty data

      • getTextOfDataFieldHeader

        function getTextOfDataFieldHeader()
        Gets the the text of the value area field header in the PivotTable.
        Returns:
        The text of data field header name