Class SettableGlobalizationSettings

SettableGlobalizationSettings class

Implementation of GlobalizationSettings that supports user to set/change pre-defined texts.

public class SettableGlobalizationSettings : GlobalizationSettings

Constructors

NameDescription
SettableGlobalizationSettings()The default constructor.

Properties

NameDescription
ChartSettings { get; set; }Gets or sets the globalization settings for Chart.(Inherited from GlobalizationSettings.)
override ColumnSeparatorOfFormulaArray { get; }Gets the separator for the items in array’s row data in formula.
override ListSeparator { get; }Gets the separator for list, parameters of function, …etc.
PivotSettings { get; set; }Gets or sets the globalization settings for pivot table.(Inherited from GlobalizationSettings.)
override 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.(Inherited from GlobalizationSettings.)
virtual GetAllName()(Obsolete.) Gets the name of “(All)” label in the PivotTable.(Inherited from GlobalizationSettings.)
override 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.(Inherited from GlobalizationSettings.)
virtual GetColumnLabelsOfPivotTable()(Obsolete.) Gets the name of “Column Labels” label in the PivotTable.(Inherited from GlobalizationSettings.)
override 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.(Inherited from GlobalizationSettings.)
virtual GetDefaultSheetName()Gets the default sheet name for adding worksheet automatically. Default is “Sheet”.(Inherited from GlobalizationSettings.)
virtual GetEmptyDataName()(Obsolete.) Gets the name of “(blank)” label in the PivotTable.(Inherited from GlobalizationSettings.)
override GetErrorValueString(string)Gets the display string value for cell’s error value
override GetGrandTotalName(ConsolidationFunction)Gets the grand total name of the function.
override GetLocalBuiltInName(string)Gets the locale dependent text for built-in Name according to given standard text.
override 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.(Inherited from GlobalizationSettings.)
virtual GetPivotGrandTotalName()(Obsolete.) Gets the name of “Grand Total” label in the PivotTable.(Inherited from GlobalizationSettings.)
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.(Inherited from GlobalizationSettings.)
virtual GetProtectionNameOfPivotTable()(Obsolete.) Gets the protection name in the PivotTable.(Inherited from GlobalizationSettings.)
virtual GetRowLabelsNameOfPivotTable()(Obsolete.) Gets the name of “Row Labels” label in the PivotTable.(Inherited from GlobalizationSettings.)
override GetStandardBuiltInName(string)Gets the standard text of built-in Name according to given locale dependent text.
override GetStandardFunctionName(string)Gets the standard function name according to given locale dependent function name.
override 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.(Inherited from GlobalizationSettings.)
override GetTableRowTypeOfAll()Gets the type name of table rows that consists of all rows in referenced table.
override GetTableRowTypeOfCurrent()Gets the type name of table rows that consists of the current row in referenced table.
override 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.
override 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.
override GetTableRowTypeOfTotals()Gets the type name of table rows that consists of the total row of referenced table.
override GetTotalName(ConsolidationFunction)Gets the total name of specific function.
SetBooleanValueString(bool, string)Sets the display string value for cell’s boolean value
SetColumnSeparatorOfFormulaArray(char)Sets the separator for the items in array’s row data in formula.
SetCommentTitleName(CommentTitleType, string)Gets the locale dependent comment title name according to comment title type.
SetGrandTotalName(ConsolidationFunction, string)Sets the grand total name of specific function.
SetListSeparator(char)Sets the separator for list, parameters of function, …etc.
SetLocalBuiltInName(string, string, bool)Sets the locale dependent text for the built-in name with given standard name text.
SetLocalFunctionName(string, string, bool)Sets the locale dependent function name corresponding to given standard function name.
SetRowSeparatorOfFormulaArray(char)Sets the separator for rows in array data in formula.
SetStandardBuiltInName(string, string, bool)Sets the locale dependent function name according to given standard function name.
SetStandardFunctionName(string, string, bool)Sets the locale dependent function name according to given standard function name.
SetStandardHeaderFooterFontStyleName(string, string)Sets the locale dependent function name according to given standard function name.
SetTableRowTypeOfAll(string)Sets the type name of table rows that consists of all rows in referenced table.
SetTableRowTypeOfCurrent(string)Sets the type name of table rows that consists of the current row in referenced table.
SetTableRowTypeOfData(string)Sets the type name of table rows that consists of data region of referenced table.
SetTableRowTypeOfHeaders(string)Sets the type name of table rows that consists of the table header.
SetTableRowTypeOfTotals(string)Sets the type name of table rows that consists of the total row of referenced table.
SetTotalName(ConsolidationFunction, string)Sets the total name of specific function.

See Also