Class SettableGlobalizationSettings

SettableGlobalizationSettings class

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

public class SettableGlobalizationSettings : GlobalizationSettings

Constructors

Name	Description
SettableGlobalizationSettings()	The default constructor.

Properties

Name	Description
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

Name	Description
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.

Examples

namespace AsposeCellsExamples
{
    using Aspose.Cells;
    using Aspose.Cells.Rendering;

    public class CellsClassSettableGlobalizationSettingsDemo
    {
        public static void Run()
        {
            // Create a new workbook
            Workbook workbook = new Workbook();
            Worksheet worksheet = workbook.Worksheets[0];

            // Create an instance of SettableGlobalizationSettings
            SettableGlobalizationSettings settings = new SettableGlobalizationSettings();

            // Set custom list separator
            settings.SetListSeparator(';');

            // Set custom boolean value strings
            settings.SetBooleanValueString(true, "TRUE_CUSTOM");
            settings.SetBooleanValueString(false, "FALSE_CUSTOM");

            // Set custom function names
            settings.SetLocalFunctionName("SUM", "SUMME", true);
            settings.SetLocalFunctionName("AVERAGE", "MITTELWERT", true);

            // Set custom table row type names
            settings.SetTableRowTypeOfHeaders("HEADERS_CUSTOM");
            settings.SetTableRowTypeOfData("DATA_CUSTOM");
            settings.SetTableRowTypeOfTotals("TOTALS_CUSTOM");

            // Set custom comment title names
            settings.SetCommentTitleName(CommentTitleType.Comment, "COMMENT_CUSTOM");
            // Removed the Author line since CommentTitleType doesn't have that enum value
            // If you need to set author-related settings, you would need to use ThreadedCommentAuthor instead

            // Apply the globalization settings to the workbook
            workbook.Settings.GlobalizationSettings = settings;

            // Demonstrate usage in formulas
            worksheet.Cells["A1"].Formula = "=TRUE()";
            worksheet.Cells["A2"].Formula = "=FALSE()";
            worksheet.Cells["A3"].Formula = "=SUM(1,2,3)";
            worksheet.Cells["A4"].Formula = "=AVERAGE(1,2,3)";

            // Save the workbook
            workbook.Save("SettableGlobalizationSettingsDemo.xlsx");
        }
    }
}

See Also

• class GlobalizationSettings
• namespace Aspose.Cells
• assembly Aspose.Cells