Constructor Summary |
---|
GlobalizationSettings()
|
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 | 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 | 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. |
Constructor Detail |
---|
function GlobalizationSettings()
Property Getters/Setters Detail |
---|
getListSeparator : char | |
function getListSeparator() |
getRowSeparatorOfFormulaArray : char | |
function getRowSeparatorOfFormulaArray() |
getColumnSeparatorOfFormulaArray : char | |
function getColumnSeparatorOfFormulaArray() |
Method Detail |
---|
getPivotTotalName | |
function getPivotTotalName() |
getPivotGrandTotalName | |
function getPivotGrandTotalName() |
getMultipleItemsName | |
function getMultipleItemsName() |
getAllName | |
function getAllName() |
getColumnLablesName | |
function getColumnLablesName() |
getRowLablesName | |
function getRowLablesName() |
getEmptyDataName | |
function getEmptyDataName() |
getSubTotalName | |
function getSubTotalName(subTotalType) |
subTotalType: Number
- A getTotalName | |
function getTotalName(functionType) |
functionType: Number
- A getGrandTotalName | |
function getGrandTotalName(functionType) |
functionType: Number
- A getOtherName | |
function getOtherName() |
getTableRowTypeOfHeaders | |
function getTableRowTypeOfHeaders() |
getTableRowTypeOfData | |
function getTableRowTypeOfData() |
getTableRowTypeOfAll | |
function getTableRowTypeOfAll() |
getTableRowTypeOfTotals | |
function getTableRowTypeOfTotals() |
getTableRowTypeOfCurrent | |
function getTableRowTypeOfCurrent() |
getErrorValueString | |
function getErrorValueString(err) |
err: String
- error values such as #VALUE!,#NAME?getBooleanValueString | |
function getBooleanValueString(bv) |
bv: boolean
- boolean valuegetLocalFunctionName | |
function getLocalFunctionName(standardName) |
standardName: String
- Standard(en-US locale) function name.getStandardFunctionName | |
function getStandardFunctionName(localName) |
localName: String
- Locale dependent function name. The locale was specified by the Workbook for which this settings is used.getLocalBuiltInName | |
function getLocalBuiltInName(standardName) |
standardName: String
- Standard(en-US locale) text of built-in Name.getStandardBuiltInName | |
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.getStandardHeaderFooterFontStyleName | |
function getStandardHeaderFooterFontStyleName(localfontStyleName) |
localfontStyleName: String
- Locale font style name for Header/Footer.