Class SettableGlobalizationSettings
Namespace: Aspose.Cells
Assembly: Aspose.Cells.dll (25.2.0)
Implementation of GlobalizationSettings that supports user to set/change pre-defined texts.
public class SettableGlobalizationSettings : GlobalizationSettingsInheritance
object ← GlobalizationSettings ← SettableGlobalizationSettings
Inherited Members
GlobalizationSettings.GetMultipleItemsName(), GlobalizationSettings.GetAllName(), GlobalizationSettings.GetColumnLabelsOfPivotTable(), GlobalizationSettings.GetRowLabelsNameOfPivotTable(), GlobalizationSettings.GetEmptyDataName(), GlobalizationSettings.GetDataFieldHeaderNameOfPivotTable(), GlobalizationSettings.GetSubTotalName(PivotFieldSubtotalType), GlobalizationSettings.GetTotalName(ConsolidationFunction), GlobalizationSettings.GetGrandTotalName(ConsolidationFunction), GlobalizationSettings.GetDefaultSheetName(), GlobalizationSettings.GetTableRowTypeOfHeaders(), GlobalizationSettings.GetTableRowTypeOfData(), GlobalizationSettings.GetTableRowTypeOfAll(), GlobalizationSettings.GetTableRowTypeOfTotals(), GlobalizationSettings.GetTableRowTypeOfCurrent(), GlobalizationSettings.GetErrorValueString(string), GlobalizationSettings.GetBooleanValueString(bool), GlobalizationSettings.GetLocalFunctionName(string), GlobalizationSettings.GetStandardFunctionName(string), GlobalizationSettings.GetLocalBuiltInName(string), GlobalizationSettings.GetStandardBuiltInName(string), GlobalizationSettings.GetStandardHeaderFooterFontStyleName(string), GlobalizationSettings.GetCommentTitleName(CommentTitleType), GlobalizationSettings.Compare(string, string, bool), GlobalizationSettings.GetCollationKey(string, bool), GlobalizationSettings.ChartSettings, GlobalizationSettings.PivotSettings, GlobalizationSettings.ListSeparator, GlobalizationSettings.RowSeparatorOfFormulaArray, GlobalizationSettings.ColumnSeparatorOfFormulaArray, object.GetType(), object.MemberwiseClone(), object.ToString(), object.Equals(object?), object.Equals(object?, object?), object.ReferenceEquals(object?, object?), object.GetHashCode()
Constructors
SettableGlobalizationSettings()
public SettableGlobalizationSettings()Properties
ColumnSeparatorOfFormulaArray
Gets the separator for the items in array’s row data in formula.
public override char ColumnSeparatorOfFormulaArray { get; }Property Value
ListSeparator
Gets the separator for list, parameters of function, …etc.
public override char ListSeparator { get; }Property Value
RowSeparatorOfFormulaArray
Gets the separator for rows in array data in formula.
public override char RowSeparatorOfFormulaArray { get; }Property Value
Methods
GetBooleanValueString(bool)
Gets the display string value for cell’s boolean value
public override string GetBooleanValueString(bool bv)Parameters
bv bool
boolean value
Returns
By default returns “TRUE” for true value and “FALSE” for false value.
GetCommentTitleName(CommentTitleType)
Gets the locale dependent comment title name according to comment title type.
public override string GetCommentTitleName(CommentTitleType type)Parameters
type CommentTitleType
type of comment title
Returns
locale dependent comment title name
GetErrorValueString(string)
Gets the display string value for cell’s error value
public override string GetErrorValueString(string err)Parameters
err string
error values such as #VALUE!,#NAME?
Returns
By default returns the error value itself
GetGrandTotalName(ConsolidationFunction)
Gets the grand total name of the function.
public override string GetGrandTotalName(ConsolidationFunction functionType)Parameters
functionType ConsolidationFunction
The function type.
Returns
The grand total name of the function.
GetLocalBuiltInName(string)
Gets the locale dependent text for built-in Name according to given standard text.
public override string GetLocalBuiltInName(string standardName)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.
GetLocalFunctionName(string)
Gets the locale dependent function name according to given standard function name.
public override string GetLocalFunctionName(string standardName)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.
GetStandardBuiltInName(string)
Gets the standard text of built-in Name according to given locale dependent text.
public override string GetStandardBuiltInName(string localName)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.
GetStandardFunctionName(string)
Gets the standard function name according to given locale dependent function name.
public override string GetStandardFunctionName(string localName)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.
GetStandardHeaderFooterFontStyleName(string)
Gets standard English font style name(Regular, Bold, Italic) for Header/Footer according to given locale font style name.
public override string GetStandardHeaderFooterFontStyleName(string localfontStyleName)Parameters
localfontStyleName string
Locale font style name for Header/Footer.
Returns
Standard English font style name(Regular, Bold, Italic)
GetTableRowTypeOfAll()
Gets the type name of table rows that consists of all rows in referenced table.
public override string GetTableRowTypeOfAll()Returns
the type name of table rows
GetTableRowTypeOfCurrent()
Gets the type name of table rows that consists of the current row in referenced table.
public override string GetTableRowTypeOfCurrent()Returns
the type name of table rows
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.
public override string GetTableRowTypeOfData()Returns
the type name of table rows
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.
public override string GetTableRowTypeOfHeaders()Returns
the type name of table rows
GetTableRowTypeOfTotals()
Gets the type name of table rows that consists of the total row of referenced table.
public override string GetTableRowTypeOfTotals()Returns
the type name of table rows
GetTotalName(ConsolidationFunction)
Gets the total name of specific function.
public override string GetTotalName(ConsolidationFunction functionType)Parameters
functionType ConsolidationFunction
The function type.
Returns
The total name of the function.
SetBooleanValueString(bool, string)
Sets the display string value for cell’s boolean value
public void SetBooleanValueString(bool bv, string name)Parameters
bv bool
boolean value
name string
string value of the boolean value
SetColumnSeparatorOfFormulaArray(char)
Sets the separator for the items in array’s row data in formula.
public void SetColumnSeparatorOfFormulaArray(char c)Parameters
c char
the specified separator
SetCommentTitleName(CommentTitleType, string)
Gets the locale dependent comment title name according to comment title type.
public void SetCommentTitleName(CommentTitleType type, string name)Parameters
type CommentTitleType
type of comment title
name string
locale dependent comment title name
SetGrandTotalName(ConsolidationFunction, string)
Sets the grand total name of specific function.
public void SetGrandTotalName(ConsolidationFunction functionType, string name)Parameters
functionType ConsolidationFunction
The function type.
name string
The grand total name of the function.
SetListSeparator(char)
Sets the separator for list, parameters of function, …etc.
public void SetListSeparator(char c)Parameters
c char
the specified separator
SetLocalBuiltInName(string, string, bool)
Sets the locale dependent text for the built-in name with given standard name text.
public void SetLocalBuiltInName(string standardName, string localName, bool bidirectional)Parameters
standardName string
Standard(en-US locale) name text of built-in name.
localName string
Locale dependent name text
bidirectional bool
Whether map the local name text to standard name text automatically. If true, the local name text will be mapped to standard name text automatically so user does not need to call Aspose.Cells.SettableGlobalizationSettings.SetStandardBuiltInName(System.String,System.String,System.Boolean) again for the same standard and local names pair
SetLocalFunctionName(string, string, bool)
Sets the locale dependent function name corresponding to given standard function name.
public void SetLocalFunctionName(string standardName, string localName, bool bidirectional)Parameters
standardName string
Standard(en-US locale) function name.
localName string
Locale dependent function name
bidirectional bool
Whether map the local function name to standard function name automatically. If true, the local name will be mapped to standard name automatically so user does not need to call Aspose.Cells.SettableGlobalizationSettings.SetStandardFunctionName(System.String,System.String,System.Boolean) again for the same standard and local names pair
SetRowSeparatorOfFormulaArray(char)
Sets the separator for rows in array data in formula.
public void SetRowSeparatorOfFormulaArray(char c)Parameters
c char
the specified separator
SetStandardBuiltInName(string, string, bool)
Sets the locale dependent function name according to given standard function name.
public void SetStandardBuiltInName(string localName, string standardName, bool bidirectional)Parameters
localName string
Locale dependent function name
standardName string
Standard(en-US locale) function name.
bidirectional bool
Whether map the standard name text to local name text automatically. If true, the standar name text will be mapped to local name text automatically so user does not need to call Aspose.Cells.SettableGlobalizationSettings.SetLocalBuiltInName(System.String,System.String,System.Boolean) again for the same standard and local names pair
SetStandardFunctionName(string, string, bool)
Sets the locale dependent function name according to given standard function name.
public void SetStandardFunctionName(string localName, string standardName, bool bidirectional)Parameters
localName string
Locale dependent function name
standardName string
Standard(en-US locale) function name.
bidirectional bool
Whether map the standard function name to local function name automatically. If true, the standar name will be mapped to local name automatically so user does not need to call Aspose.Cells.SettableGlobalizationSettings.SetLocalFunctionName(System.String,System.String,System.Boolean) again for the same standard and local names pair
SetStandardHeaderFooterFontStyleName(string, string)
Sets the locale dependent function name according to given standard function name.
public void SetStandardHeaderFooterFontStyleName(string localfontStyleName, string standardName)Parameters
localfontStyleName string
Locale font style name for Header/Footer.
standardName string
Standard(en-US locale) function name.
SetTableRowTypeOfAll(string)
Sets the type name of table rows that consists of all rows in referenced table.
public void SetTableRowTypeOfAll(string name)Parameters
name string
the type name of table rows
SetTableRowTypeOfCurrent(string)
Sets the type name of table rows that consists of the current row in referenced table.
public void SetTableRowTypeOfCurrent(string name)Parameters
name string
the type name of table rows
SetTableRowTypeOfData(string)
Sets the type name of table rows that consists of data region of referenced table.
public void SetTableRowTypeOfData(string name)Parameters
name string
the type name of table rows
SetTableRowTypeOfHeaders(string)
Sets the type name of table rows that consists of the table header.
public void SetTableRowTypeOfHeaders(string name)Parameters
name string
the type name of table rows
SetTableRowTypeOfTotals(string)
Sets the type name of table rows that consists of the total row of referenced table.
public void SetTableRowTypeOfTotals(string name)Parameters
name string
the type name of table rows
SetTotalName(ConsolidationFunction, string)
Sets the total name of specific function.
public void SetTotalName(ConsolidationFunction functionType, string name)Parameters
functionType ConsolidationFunction
The function type.
name string
The total name of the function.