Constructor Summary |
---|
Property Getters/Setters Summary | ||
---|---|---|
function | getColumnSeparatorOfFormulaArray() | |
Gets the separator for the items in array's row data in formula.
|
||
function | getListSeparator() | |
Gets the separator for list, parameters of function, ...etc.
|
||
function | getRowSeparatorOfFormulaArray() | |
Gets the separator for rows in array data in formula.
|
Method Summary | ||
---|---|---|
function | getAllName() | |
Gets the name of "(All)" label in the PivotTable.
|
||
function | getBooleanValueString(bv) | |
Gets the display string value for cell's boolean value
|
||
function | getColumnLabelsOfPivotTable() | |
Gets the name of "Column Labels" label in the PivotTable.
|
||
function | getColumnLablesName() | |
Gets the name of "Column Labels" label in the PivotTable.
|
||
function | getEmptyDataName() | |
Gets the name of "(blank)" label in the PivotTable.
|
||
function | getErrorValueString(err) | |
Gets the display string value for cell's error value
|
||
function | getGrandTotalName(functionType) | |
Gets the grand total name of the function.
|
||
function | getLocalBuiltInName(standardName) | |
Gets the locale dependent text for built-in Name according to given standard text.
|
||
function | getLocalFunctionName(standardName) | |
Gets the locale dependent function name according to given standard function name.
|
||
function | getMultipleItemsName() | |
Gets the name of "(Multiple Items)" label in the PivotTable.
|
||
function | getOtherName() | |
Gets the name of "Other" labels for Pie charts.
|
||
function | getPivotGrandTotalName() | |
Gets the name of "Grand Total" label in the PivotTable.
|
||
function | 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.
|
||
function | getRowLabelsNameOfPivotTable() | |
Gets the name of "Row Labels" label in the PivotTable.
|
||
function | getRowLablesName() | |
Gets the name of "Row Labels" label in the PivotTable.
|
||
function | getStandardBuiltInName(localName) | |
Gets the standard text of built-in Name according to given locale dependent text.
|
||
function | getStandardFunctionName(localName) | |
Gets the standard function name according to given locale dependent function name.
|
||
function | getStandardHeaderFooterFontStyleName(localfontStyleName) | |
Gets standard English font style name(Regular, Bold, Italic) for Header/Footer according to given locale font style name.
|
||
function | getSubTotalName(subTotalType) | |
Gets the name of |
||
function | getTableRowTypeOfAll() | |
Gets the type name of table rows that consists of all rows in referenced table.
Default is "All": "#All" denotes all rows in referenced table.
|
||
function | getTableRowTypeOfCurrent() | |
Gets the type name of table rows that consists of the current row in referenced table.
Default is "This Row": "#This Row" denotes the current row in referenced table.
|
||
function | getTableRowTypeOfData() | |
Gets the type name of table rows that consists of data region of referenced table.
Default is "Data": "#Data" denotes the data region of the table.
|
||
function | getTableRowTypeOfHeaders() | |
Gets the type name of table rows that consists of the table header.
Default is "Headers": "#Headers" denotes the table header.
|
||
function | getTableRowTypeOfTotals() | |
Gets the type name of table rows that consists of the total row of referenced table.
Default is "Totals": "#Totals" denotes the total row of referenced table.
|
||
function | getTotalName(functionType) | |
Gets the total name of the function.
|
function getListSeparator()
function getRowSeparatorOfFormulaArray()
function getColumnSeparatorOfFormulaArray()
function getPivotTotalName()
function getPivotGrandTotalName()
function getMultipleItemsName()
function getAllName()
function getColumnLablesName()
function getRowLablesName()
function getColumnLabelsOfPivotTable()
function getRowLabelsNameOfPivotTable()
function getEmptyDataName()
function getSubTotalName(subTotalType)
subTotalType: Number
- A function getTotalName(functionType)
functionType: Number
- A function getGrandTotalName(functionType)
functionType: Number
- A function getOtherName()
function getTableRowTypeOfHeaders()
function getTableRowTypeOfData()
function getTableRowTypeOfAll()
function getTableRowTypeOfTotals()
function getTableRowTypeOfCurrent()
function getErrorValueString(err)
err: String
- error values such as #VALUE!,#NAME?function getBooleanValueString(bv)
bv: boolean
- boolean valuefunction getLocalFunctionName(standardName)
standardName: String
- Standard(en-US locale) function name.function getStandardFunctionName(localName)
localName: String
- Locale dependent function name. The locale was specified by the Workbook for which this settings is used.function getLocalBuiltInName(standardName)
standardName: String
- Standard(en-US locale) text of built-in Name.function getStandardBuiltInName(localName)
localName: String
- Locale dependent text of built-in Name. The locale was specified by the Workbook for which this settings is used.function getStandardHeaderFooterFontStyleName(localfontStyleName)
localfontStyleName: String
- Locale font style name for Header/Footer.