Constructor Summary |
---|
Property Getters/Setters Summary | ||
---|---|---|
method | getChartSettings() | |
method | setChartSettings(value) | |
Gets or sets the globalization settings for Chart. | ||
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 | getPivotSettings() | |
method | setPivotSettings(value) | |
Gets or sets the globalization settings for pivot table. | ||
method | getRowSeparatorOfFormulaArray() | |
Gets the separator for rows in array data in formula.
|
Method Summary | ||
---|---|---|
method | compare(v1, v2, ignoreCase) | |
Compares two string values according to certain collation rules.
|
||
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 | getCollationKey(v, ignoreCase) | |
Transforms the string into a comparable object according to certain collation rules.
|
||
method | getColumnLabelsOfPivotTable() | |
Gets the name of "Column Labels" label in the PivotTable.
|
||
method | getCommentTitleName(type) | |
Gets the locale dependent comment title name according to comment title type.
|
||
method | getDataFieldHeaderNameOfPivotTable() | |
Gets the the name of the value area field header in the PivotTable.
|
||
method | getDefaultSheetName() | |
Gets the default sheet name for adding worksheet automatically.
Default is "Sheet".
|
||
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 | 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 | getProtectionNameOfPivotTable() | |
Gets the protection name in the PivotTable.
|
||
method | getRowLabelsNameOfPivotTable() | |
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", so in formula "#All" represents 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", so in formula "#This Row" represents 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", so in formula "#Data" represents the data region of the table.
|
||
method | 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.
|
||
method | 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.
|
||
method | getTotalName(functionType) | |
Gets the total name of the function.
|
ChartGlobalizationSettings getChartSettings() / setChartSettings(value)
PivotGlobalizationSettings getPivotSettings() / setPivotSettings(value)
char getListSeparator()
char getRowSeparatorOfFormulaArray()
char getColumnSeparatorOfFormulaArray()
String getPivotTotalName()
String getPivotGrandTotalName()
String getMultipleItemsName()
String getAllName()
String getProtectionNameOfPivotTable()
String getColumnLabelsOfPivotTable()
String getRowLabelsNameOfPivotTable()
String getEmptyDataName()
String getDataFieldHeaderNameOfPivotTable()
String getSubTotalName(subTotalType)
subTotalType: int
- A String getTotalName(functionType)
functionType: int
- A String getGrandTotalName(functionType)
functionType: int
- A String getDefaultSheetName()
String getTableRowTypeOfHeaders()
String getTableRowTypeOfData()
String getTableRowTypeOfAll()
String getTableRowTypeOfTotals()
String getTableRowTypeOfCurrent()
String getErrorValueString(err)
err: String
- error values such as #VALUE!,#NAME?String getBooleanValueString(bv)
bv: boolean
- boolean valueString getLocalFunctionName(standardName)
standardName: String
- Standard(en-US locale) function name.String getStandardFunctionName(localName)
localName: String
- Locale dependent function name. The locale was specified by the Workbook for which this settings is used.String getLocalBuiltInName(standardName)
standardName: String
- Standard(en-US locale) text of built-in Name.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.String getStandardHeaderFooterFontStyleName(localfontStyleName)
localfontStyleName: String
- Locale font style name for Header/Footer.String getCommentTitleName(type)
type: int
- A int compare(v1, v2, ignoreCase)
v1: String
- the first stringv2: String
- the second stringignoreCase: boolean
- whether ignore case when comparing valuesIComparable getCollationKey(v, ignoreCase)
v: String
- String value needs to be compared with others.ignoreCase: boolean
- whether ignore case when comparing values