aspose.cells
Class GlobalizationSettings

GlobalizationSettings

function GlobalizationSettings()

function getListSeparator()

Gets the separator for list, parameters of function, ...etc.

function getRowSeparatorOfFormulaArray()

Gets the separator for rows in array data in formula.

function getColumnSeparatorOfFormulaArray()

Gets the separator for the items in array's row data in formula.

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.

Returns:

The name of "Total" label

function getPivotGrandTotalName()

Gets the name of "Grand Total" label in the PivotTable.

Returns:

The name of "Grand Total" label

function getMultipleItemsName()

Gets the name of "(Multiple Items)" label in the PivotTable.

Returns:

The name of "(Multiple Items)" label

function getAllName()

Gets the name of "(All)" label in the PivotTable.

Returns:

The name of "(All)" label

function getColumnLablesName()

Gets the name of "Column Labels" label in the PivotTable.

Returns:

The name of column labels

function getRowLablesName()

Gets the name of "Row Labels" label in the PivotTable.

Returns:

The name of row labels

function getEmptyDataName()

Gets the name of "(blank)" label in the PivotTable.

Returns:

The name of empty data

function getSubTotalName(subTotalType)

Gets the name of PivotFieldSubtotalType type in the PivotTable.

Parameters:

subTotalType: Number - A PivotFieldSubtotalType value. The PivotFieldSubtotalType type

Returns:

The name of PivotFieldSubtotalType type

function getTotalName(functionType)

Gets the total name of the function.

Parameters:

functionType: Number - A ConsolidationFunction value. The function type.

Returns:

The total name of the function.

function getGrandTotalName(functionType)

Gets the grand total name of the function.

Parameters:

functionType: Number - A ConsolidationFunction value. The function type.

Returns:

The grand total name of the function.

function getOtherName()

Gets the name of "Other" labels for Pie charts.

Returns:

function getTableRowTypeOfHeaders()

Gets the type name of table rows that consists of the table header. Default is "Headers": "#Headers" denotes the table header.

Returns:

the type name of table rows

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.

Returns:

the type name of table rows

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.

Returns:

the type name of table rows

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.

Returns:

the type name of table rows

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.

Returns:

the type name of table rows

function getErrorValueString(err)

Gets the display string value for cell's error value

Parameters:

err: String - error values such as #VALUE!,#NAME?

Returns:

Default returns the error value itself

function getBooleanValueString(bv)

Gets the display string value for cell's boolean value

Parameters:

bv: boolean - boolean value

Returns:

Default returns "TRUE" for true value and "FALSE" for false value.

function getLocalFunctionName(standardName)

Gets the locale dependent function name according to given standard function name.

Parameters:

standardName: String - Standard(en-US locale) function name.

Returns:

Locale dependent function name. The locale was specified by the Workbook for which this settings is used.

function getStandardFunctionName(localName)

Gets the standard function name according to given locale dependent function name.

Parameters:

localName: String - Locale dependent function name. The locale was specified by the Workbook for which this settings is used.

Returns:

Standard(en-US locale) function name.

function getLocalBuiltInName(standardName)

Gets the locale dependent text for built-in Name according to given standard text.

Parameters:

standardName: String - 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.

function getStandardBuiltInName(localName)

Gets the standard text of built-in Name according to given locale dependent text.

Parameters:

localName: String - 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.

function getStandardHeaderFooterFontStyleName(localfontStyleName)

Gets standard English font style name(Regular, Bold, Italic) for Header/Footer according to given locale font style name.

Parameters:

localfontStyleName: String - Locale font style name for Header/Footer.

Returns:

Standard English font style name(Regular, Bold, Italic)