Class GlobalizationSettings

GlobalizationSettings class

Represents the globalization settings.

public class GlobalizationSettings

Constructors

NameDescription
GlobalizationSettings()The default constructor.

Properties

NameDescription
ChartSettings { get; set; }Gets or sets the globalization settings for Chart.
virtual ColumnSeparatorOfFormulaArray { get; }Gets the separator for the items in array’s row data in formula.
virtual ListSeparator { get; }Gets the separator for list, parameters of function, …etc.
PivotSettings { get; set; }Gets or sets the globalization settings for pivot table.
virtual RowSeparatorOfFormulaArray { get; }Gets the separator for rows in array data in formula.

Methods

NameDescription
virtual Compare(string, string, bool)Compares two string values according to certain collation rules.
virtual GetAllName()(Obsolete.) Gets the name of “(All)” label in the PivotTable.
virtual GetBooleanValueString(bool)Gets the display string value for cell’s boolean value
virtual GetCollationKey(string, bool)Transforms the string into a comparable object according to certain collation rules.
virtual GetColumnLabelsOfPivotTable()(Obsolete.) Gets the name of “Column Labels” label in the PivotTable.
virtual GetCommentTitleName(CommentTitleType)Gets the locale dependent comment title name according to comment title type.
virtual GetDataFieldHeaderNameOfPivotTable()(Obsolete.) Gets the the name of the value area field header in the PivotTable.
virtual GetDefaultSheetName()Gets the default sheet name for adding worksheet automatically. Default is “Sheet”.
virtual GetEmptyDataName()(Obsolete.) Gets the name of “(blank)” label in the PivotTable.
virtual GetErrorValueString(string)Gets the display string value for cell’s error value
virtual GetGrandTotalName(ConsolidationFunction)Gets the grand total name of the function.
virtual GetLocalBuiltInName(string)Gets the locale dependent text for built-in Name according to given standard text.
virtual GetLocalFunctionName(string)Gets the locale dependent function name according to given standard function name.
virtual GetMultipleItemsName()(Obsolete.) Gets the name of “(Multiple Items)” label in the PivotTable.
virtual GetPivotGrandTotalName()(Obsolete.) Gets the name of “Grand Total” label in the PivotTable.
virtual GetPivotTotalName()(Obsolete.) 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.
virtual GetProtectionNameOfPivotTable()(Obsolete.) Gets the protection name in the PivotTable.
virtual GetRowLabelsNameOfPivotTable()(Obsolete.) Gets the name of “Row Labels” label in the PivotTable.
virtual GetStandardBuiltInName(string)Gets the standard text of built-in Name according to given locale dependent text.
virtual GetStandardFunctionName(string)Gets the standard function name according to given locale dependent function name.
virtual GetStandardHeaderFooterFontStyleName(string)Gets standard English font style name(Regular, Bold, Italic) for Header/Footer according to given locale font style name.
virtual GetSubTotalName(PivotFieldSubtotalType)(Obsolete.) Gets the name of PivotFieldSubtotalType type in the PivotTable.
virtual 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.
virtual 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.
virtual 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.
virtual 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.
virtual 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.
virtual GetTotalName(ConsolidationFunction)Gets the total name of the function.

See Also