aspose.cells

Class SettablePivotGlobalizationSettings

Implementation of PivotGlobalizationSettings that supports user to set/change pre-defined texts.

Constructor Summary
 
Method Summary
functiongetShortTextOf12Months()
Gets all short formatted string of 12 months.
functiongetTextOf4Quaters()
Gets the local text of 4 Quaters.
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.
functiongetTextOfDays()
Gets the local text of "Days".
functiongetTextOfEmptyData()
Gets the text of "(blank)" label in the PivotTable.
functiongetTextOfGrandTotal()
Gets the text of "Grand Total" label in the PivotTable.
functiongetTextOfHours()
Gets the local text of "Hours".
functiongetTextOfMinutes()
Gets the local text of "Minutes".
functiongetTextOfMonths()
Gets the local text of "Months".
functiongetTextOfMultipleItems()
Gets the text of "(Multiple Items)" label in the PivotTable.
functiongetTextOfProtectedName(protectedName)
Gets the text for specified protected name.
functiongetTextOfProtection()
Gets the protection name in the PivotTable.
functiongetTextOfQuarters()
Get the local text of "Quarters".
functiongetTextOfRange()
Gets the local text of "Range"
functiongetTextOfRowLabels()
Gets the text of "Row Labels" label in the PivotTable.
functiongetTextOfSeconds()
Gets the local text of "Seconds"
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.
functiongetTextOfYears()
Gets the local text of "Years".
functionsetTextOfAll(text)
Sets the text of "(All)" label in the PivotTable.
functionsetTextOfColumnLabels(text)
Gets the text of "Column Labels" label in the PivotTable.
functionsetTextOfDataFieldHeader(text)
Sets the the text of the value area field header in the PivotTable.
functionsetTextOfEmptyData(text)
Sets the text of "(blank)" label in the PivotTable.
functionsetTextOfGrandTotal(text)
Sets the text of "Grand Total" label in the PivotTable.
functionsetTextOfMultipleItems(text)
Sets the text of "(Multiple Items)" label in the PivotTable.
functionsetTextOfProtectedName(protectedName, text)
Sets the text for specific protected name.
functionsetTextOfRowLabels(text)
Sets the text of "Row Labels" label in the PivotTable.
functionsetTextOfSubTotal(subTotalType, text)
Sets the text of PivotFieldSubtotalType type in the PivotTable.
functionsetTextOfTotal(text)
Sets the text of "Total" label in the PivotTable.
 

    • Constructor Detail

      • SettablePivotGlobalizationSettings

        function SettablePivotGlobalizationSettings()
    • 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
      • setTextOfTotal

        function setTextOfTotal(text)
        Sets the text of "Total" label in the PivotTable.
        Parameters:
        text: String - custom text
      • getTextOfGrandTotal

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

        function setTextOfGrandTotal(text)
        Sets the text of "Grand Total" label in the PivotTable.
        Parameters:
        text: String - custom text
      • getTextOfMultipleItems

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

        function setTextOfMultipleItems(text)
        Sets the text of "(Multiple Items)" label in the PivotTable.
        Parameters:
        text: String - custom text
      • getTextOfAll

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

        function setTextOfAll(text)
        Sets the text of "(All)" label in the PivotTable.
        Parameters:
        text: String - custom text
      • getTextOfProtectedName

        function 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.
        Parameters:
        protectedName: String - The protected name in PivotTable.
        Returns:
        The local prorected names of PivotTable.
      • setTextOfProtectedName

        function setTextOfProtectedName(protectedName, text)
        Sets the text for specific protected name.
        Parameters:
        protectedName: String - The protected name in PivotTable.
        text: String - 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
      • setTextOfColumnLabels

        function setTextOfColumnLabels(text)
        Gets the text of "Column Labels" label in the PivotTable.
        Parameters:
        text: String - The text of column labels
      • getTextOfRowLabels

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

        function setTextOfRowLabels(text)
        Sets the text of "Row Labels" label in the PivotTable.
        Parameters:
        text: String - The text of row labels
      • getTextOfEmptyData

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

        function setTextOfEmptyData(text)
        Sets the text of "(blank)" label in the PivotTable.
        Parameters:
        text: String - 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
      • setTextOfDataFieldHeader

        function setTextOfDataFieldHeader(text)
        Sets the the text of the value area field header in the PivotTable.
        Parameters:
        text: String - The text of data field header name
      • 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
      • getShortTextOf12Months

        function getShortTextOf12Months()
        Gets all short formatted string of 12 months.
        Returns:
      • getTextOf4Quaters

        function getTextOf4Quaters()
        Gets the local text of 4 Quaters.
        Returns:
      • getTextOfYears

        function getTextOfYears()
        Gets the local text of "Years".
        Returns:
      • getTextOfQuarters

        function getTextOfQuarters()
        Get the local text of "Quarters".
        Returns:
      • getTextOfMonths

        function getTextOfMonths()
        Gets the local text of "Months".
        Returns:
      • getTextOfDays

        function getTextOfDays()
        Gets the local text of "Days".
        Returns:
      • getTextOfHours

        function getTextOfHours()
        Gets the local text of "Hours".
        Returns:
      • getTextOfMinutes

        function getTextOfMinutes()
        Gets the local text of "Minutes".
        Returns:
      • getTextOfSeconds

        function getTextOfSeconds()
        Gets the local text of "Seconds"
        Returns:
      • getTextOfRange

        function getTextOfRange()
        Gets the local text of "Range"
        Returns: