aspose.cells
Class GlobalizationSettings

Repsents the globalization settings.

Constructor Summary
GlobalizationSettings()
          
 
Property Getters/Setters Summary
functiongetColumnSeparatorOfFormulaArray()
           Gets the separator for the items in array's row data in formula.
functiongetListSeparator()
           Gets the separator for list, parameters of function, ...etc.
functiongetRowSeparatorOfFormulaArray()
           Gets the separator for rows in array data in formula.
 
Method Summary
functiongetAllName()
           Gets the name of "(All)" label in the PivotTable.
functiongetBooleanValueString(bv)
           Gets the display string value for cell's boolean value
functiongetColumnLablesName()
           Gets the name of "Column Labels" label in the PivotTable.
functiongetEmptyDataName()
           Gets the name of "(blank)" label in the PivotTable.
functiongetErrorValueString(err)
           Gets the display string value for cell's error value
functiongetGrandTotalName(functionType)
           Gets the grand total name of the function.
functiongetLocalBuiltInName(standardName)
           Gets the locale dependent text for built-in Name according to given standard text.
functiongetLocalFunctionName(standardName)
           Gets the locale dependent function name according to given standard function name.
functiongetMultipleItemsName()
           Gets the name of "(Multiple Items)" label in the PivotTable.
functiongetOtherName()
           Gets the name of "Other" labels for Pie charts.
functiongetPivotGrandTotalName()
           Gets the name of "Grand Total" label in the PivotTable.
functiongetPivotTotalName()
           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.
functiongetRowLablesName()
           Gets the name of "Row Labels" label in the PivotTable.
functiongetStandardBuiltInName(localName)
           Gets the standard text of built-in Name according to given locale dependent text.
functiongetStandardFunctionName(localName)
           Gets the standard function name according to given locale dependent function name.
functiongetStandardHeaderFooterFontStyleName(localfontStyleName)
           Gets standard English font style name(Regular, Bold, Italic) for Header/Footer according to given locale font style name.
functiongetSubTotalName(subTotalType)
           Gets the name of PivotFieldSubtotalType type in the PivotTable.
functiongetTableRowTypeOfAll()
           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.
functiongetTableRowTypeOfCurrent()
           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.
functiongetTableRowTypeOfData()
           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.
functiongetTableRowTypeOfHeaders()
           Gets the type name of table rows that consists of the table header. Default is "Headers": "#Headers" denotes the table header.
functiongetTableRowTypeOfTotals()
           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.
functiongetTotalName(functionType)
           Gets the total name of the function.
 

Constructor Detail

GlobalizationSettings

function GlobalizationSettings()

Property Getters/Setters Detail

getListSeparator : char 

function getListSeparator()
Gets the separator for list, parameters of function, ...etc.

getRowSeparatorOfFormulaArray : char 

function getRowSeparatorOfFormulaArray()
Gets the separator for rows in array data in formula.

getColumnSeparatorOfFormulaArray : char 

function getColumnSeparatorOfFormulaArray()
Gets the separator for the items in array's row data in formula.

Method Detail

getPivotTotalName

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

getPivotGrandTotalName

function getPivotGrandTotalName()
Gets the name of "Grand Total" label in the PivotTable.
Returns:
The name of "Grand Total" label

getMultipleItemsName

function getMultipleItemsName()
Gets the name of "(Multiple Items)" label in the PivotTable.
Returns:
The name of "(Multiple Items)" label

getAllName

function getAllName()
Gets the name of "(All)" label in the PivotTable.
Returns:
The name of "(All)" label

getColumnLablesName

function getColumnLablesName()
Gets the name of "Column Labels" label in the PivotTable.
Returns:
The name of column labels

getRowLablesName

function getRowLablesName()
Gets the name of "Row Labels" label in the PivotTable.
Returns:
The name of row labels

getEmptyDataName

function getEmptyDataName()
Gets the name of "(blank)" label in the PivotTable.
Returns:
The name of empty data

getSubTotalName

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

getTotalName

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.

getGrandTotalName

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.

getOtherName

function getOtherName()
Gets the name of "Other" labels for Pie charts.
Returns:

getTableRowTypeOfHeaders

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

getTableRowTypeOfData

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

getTableRowTypeOfAll

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

getTableRowTypeOfTotals

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

getTableRowTypeOfCurrent

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

getErrorValueString

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

getBooleanValueString

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.

getLocalFunctionName

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.

getStandardFunctionName

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.

getLocalBuiltInName

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.

getStandardBuiltInName

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.

getStandardHeaderFooterFontStyleName

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)

See Also:
          Aspose.Cells Documentation - the home page for the Aspose.Cellss Product Documentation.
          Aspose.Cells Support Forum - our preferred method of support.