Gets the name of "Total" label in the PivotTable.
You need to override this method when the PivotTable contains two or more PivotFields in the data area.
Gets the type name of table rows that consists of all rows in referenced table.
Default is "All", so in formula "#All" represents all rows in referenced table.
Gets the type name of table rows that consists of the current row in referenced table.
Default is "This Row", so in formula "#This Row" represents the current row in referenced table.
Gets the type name of table rows that consists of data region of referenced table.
Default is "Data", so in formula "#Data" represents the data region of the table.
Gets the type name of table rows that consists of the total row of referenced table.
Default is "Totals", so in formula "#Totals" represents the total row of referenced table.
Gets the separator for list, parameters of function, ...etc.
getRowSeparatorOfFormulaArray
public char getRowSeparatorOfFormulaArray()
Gets the separator for rows in array data in formula.
getColumnSeparatorOfFormulaArray
public char getColumnSeparatorOfFormulaArray()
Gets the separator for the items in array's row data in formula.
Method Detail
getPivotTotalName
public java.lang.String getPivotTotalName()
Gets the name 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 name of "Total" label
getPivotGrandTotalName
public java.lang.String getPivotGrandTotalName()
Gets the name of "Grand Total" label in the PivotTable.
Returns:
The name of "Grand Total" label
getMultipleItemsName
public java.lang.String getMultipleItemsName()
Gets the name of "(Multiple Items)" label in the PivotTable.
Returns:
The name of "(Multiple Items)" label
getAllName
public java.lang.String getAllName()
Gets the name of "(All)" label in the PivotTable.
Returns:
The name of "(All)" label
getColumnLablesName
public java.lang.String getColumnLablesName()
Gets the name of "Column Labels" label in the PivotTable.
NOTE: This member is now obsolete. Instead,
please use GlobalizationSettings.GetColumnLabelsOfPivotTable() method.
This property will be removed 12 months later since September 2020.
Aspose apologizes for any inconvenience you may have experienced.
Returns:
The name of column labels
getRowLablesName
public java.lang.String getRowLablesName()
Gets the name of "Row Labels" label in the PivotTable.
NOTE: This member is now obsolete. Instead,
please use GlobalizationSettings.GetRowLabelsOfPivotTable() method.
This property will be removed 12 months later since September 2020.
Aspose apologizes for any inconvenience you may have experienced.
Returns:
The name of row labels
getProtectionNameOfPivotTable
public java.lang.String getProtectionNameOfPivotTable()
Gets the protection name in the PivotTable.
Returns:
The protection name of PivotTable
getColumnLabelsOfPivotTable
public java.lang.String getColumnLabelsOfPivotTable()
Gets the name of "Column Labels" label in the PivotTable.
Returns:
The name of column labels
getRowLabelsNameOfPivotTable
public java.lang.String getRowLabelsNameOfPivotTable()
Gets the name of "Row Labels" label in the PivotTable.
Returns:
The name of row labels
getEmptyDataName
public java.lang.String getEmptyDataName()
Gets the name of "(blank)" label in the PivotTable.
Returns:
The name of empty data
getSubTotalName
public java.lang.String getSubTotalName(int subTotalType)
public java.lang.String getTableRowTypeOfHeaders()
Gets the type name of table rows that consists of the table header.
Default is "Headers", so in formula "#Headers" represents the table header.
Returns:
the type name of table rows
getTableRowTypeOfData
public java.lang.String getTableRowTypeOfData()
Gets the type name of table rows that consists of data region of referenced table.
Default is "Data", so in formula "#Data" represents the data region of the table.
Returns:
the type name of table rows
getTableRowTypeOfAll
public java.lang.String getTableRowTypeOfAll()
Gets the type name of table rows that consists of all rows in referenced table.
Default is "All", so in formula "#All" represents all rows in referenced table.
Returns:
the type name of table rows
getTableRowTypeOfTotals
public java.lang.String getTableRowTypeOfTotals()
Gets the type name of table rows that consists of the total row of referenced table.
Default is "Totals", so in formula "#Totals" represents the total row of referenced table.
Returns:
the type name of table rows
getTableRowTypeOfCurrent
public java.lang.String getTableRowTypeOfCurrent()
Gets the type name of table rows that consists of the current row in referenced table.
Default is "This Row", so in formula "#This Row" represents the current row in referenced table.
Returns:
the type name of table rows
getErrorValueString
public java.lang.String getErrorValueString(java.lang.String err)
Gets the display string value for cell's error value
Parameters:
err - error values such as #VALUE!,#NAME?
Returns:
Default returns the error value itself
getBooleanValueString
public java.lang.String getBooleanValueString(boolean bv)
Gets the display string value for cell's boolean value
Parameters:
bv - boolean value
Returns:
Default returns "TRUE" for true value and "FALSE" for false value.
getLocalFunctionName
public java.lang.String getLocalFunctionName(java.lang.String standardName)
Gets the locale dependent function name according to given standard function name.
Parameters:
standardName - Standard(en-US locale) function name.
Returns:
Locale dependent function name. The locale was specified by the Workbook for which this settings is used.
getStandardFunctionName
public java.lang.String getStandardFunctionName(java.lang.String localName)
Gets the standard function name according to given locale dependent function name.
Parameters:
localName - Locale dependent function name. The locale was specified by the Workbook for which this settings is used.
Returns:
Standard(en-US locale) function name.
getLocalBuiltInName
public java.lang.String getLocalBuiltInName(java.lang.String standardName)
Gets the locale dependent text for built-in Name according to given standard text.
Parameters:
standardName - Standard(en-US locale) text of built-in Name.
Returns:
Locale dependent text. The locale was specified by the Workbook for which this settings is used.
getStandardBuiltInName
public java.lang.String getStandardBuiltInName(java.lang.String localName)
Gets the standard text of built-in Name according to given locale dependent text.
Parameters:
localName - Locale dependent text of built-in Name. The locale was specified by the Workbook for which this settings is used.
Returns:
Standard(en-US locale) text.
getStandardHeaderFooterFontStyleName
public java.lang.String getStandardHeaderFooterFontStyleName(java.lang.String localfontStyleName)
Gets standard English font style name(Regular, Bold, Italic) for Header/Footer according to given locale font style name.
Parameters:
localfontStyleName - Locale font style name for Header/Footer.
Returns:
Standard English font style name(Regular, Bold, Italic)
getCommentTitleName
public java.lang.String getCommentTitleName(int type)
Gets the locale dependent comment title name according to comment title type.