asposecells.api

Constructor Detail

• SettablePivotGlobalizationSettings

  SettablePivotGlobalizationSettings()

Method Detail

• getTextOfTotal

  String 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

   setTextOfTotal(text)

  Sets the text of "Total" label in the PivotTable.

  Parameters:

  text: String - custom text

• getTextOfGrandTotal

  String getTextOfGrandTotal()

  Gets the text of "Grand Total" label in the PivotTable.

  Returns:

  The text of "Grand Total" label

• setTextOfGrandTotal

   setTextOfGrandTotal(text)

  Sets the text of "Grand Total" label in the PivotTable.

  Parameters:

  text: String - custom text

• getTextOfMultipleItems

  String getTextOfMultipleItems()

  Gets the text of "(Multiple Items)" label in the PivotTable.

  Returns:

  The text of "(Multiple Items)" label

• setTextOfMultipleItems

   setTextOfMultipleItems(text)

  Sets the text of "(Multiple Items)" label in the PivotTable.

  Parameters:

  text: String - custom text

• getTextOfAll

  String getTextOfAll()

  Gets the text of "(All)" label in the PivotTable.

  Returns:

  The text of "(All)" label

• setTextOfAll

   setTextOfAll(text)

  Sets the text of "(All)" label in the PivotTable.

  Parameters:

  text: String - custom text

• getTextOfProtectedName

  String 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

   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

  String getTextOfColumnLabels()

  Gets the text of "Column Labels" label in the PivotTable.

  Returns:

  The text of column labels

• setTextOfColumnLabels

   setTextOfColumnLabels(text)

  Gets the text of "Column Labels" label in the PivotTable.

  Parameters:

  text: String - The text of column labels

• getTextOfRowLabels

  String getTextOfRowLabels()

  Gets the text of "Row Labels" label in the PivotTable.

  Returns:

  The text of row labels

• setTextOfRowLabels

   setTextOfRowLabels(text)

  Sets the text of "Row Labels" label in the PivotTable.

  Parameters:

  text: String - The text of row labels

• getTextOfEmptyData

  String getTextOfEmptyData()

  Gets the text of "(blank)" label in the PivotTable.

  Returns:

  The text of empty data

• setTextOfEmptyData

   setTextOfEmptyData(text)

  Sets the text of "(blank)" label in the PivotTable.

  Parameters:

  text: String - The text of empty data

• getTextOfDataFieldHeader

  String getTextOfDataFieldHeader()

  Gets the the text of the value area field header in the PivotTable.

  Returns:

  The text of data field header name

• setTextOfDataFieldHeader

   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

• getTextOfSubTotal

  String getTextOfSubTotal(subTotalType)

  Gets the text of PivotFieldSubtotalType type in the PivotTable.

  Parameters:

  subTotalType: int - A PivotFieldSubtotalType value. The PivotFieldSubtotalType

  Returns:

  The text of given type

• setTextOfSubTotal

   setTextOfSubTotal(subTotalType, text)

  Sets the text of PivotFieldSubtotalType type in the PivotTable.

  Parameters:

  subTotalType: int - A PivotFieldSubtotalType value. The PivotFieldSubtotalType

  text: String - The text of given type

• getTextOfProtection

  String 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

  String[] getShortTextOf12Months()

  Gets all short formatted string of 12 months.

  Returns:

• getTextOf4Quaters

  String[] getTextOf4Quaters()

  Gets the local text of 4 Quaters.

  Returns:

• getTextOfYears

  String getTextOfYears()

  Gets the local text of "Years".

  Returns:

• getTextOfQuarters

  String getTextOfQuarters()

  Get the local text of "Quarters".

  Returns:

• getTextOfMonths

  String getTextOfMonths()

  Gets the local text of "Months".

  Returns:

• getTextOfDays

  String getTextOfDays()

  Gets the local text of "Days".

  Returns:

• getTextOfHours

  String getTextOfHours()

  Gets the local text of "Hours".

  Returns:

• getTextOfMinutes

  String getTextOfMinutes()

  Gets the local text of "Minutes".

  Returns:

• getTextOfSeconds

  String getTextOfSeconds()

  Gets the local text of "Seconds"

  Returns:

• getTextOfRange

  String getTextOfRange()

  Gets the local text of "Range"

  Returns: