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