aspose.cells

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)

  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.

• 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

• 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:

• getTextOfSubTotal

  function getTextOfSubTotal(subTotalType)

  Gets the text of PivotFieldSubtotalType type in the PivotTable.

  Parameters:

  subTotalType: Number - A PivotFieldSubtotalType value. The PivotFieldSubtotalType

  Returns:

  The text of given type