SettableGlobalizationSettings class

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

Inheritance: SettableGlobalizationSettings → GlobalizationSettings

The SettableGlobalizationSettings type exposes the following members:

Constructors

Constructor	Description
`__init__(self)`	Constructs a new instance of SettableGlobalizationSettings

Properties

Property	Description
chart_settings	Gets or sets the globalization settings for Chart.
pivot_settings	Gets or sets the globalization settings for pivot table.
list_separator	Gets the separator for list, parameters of function, …etc.
row_separator_of_formula_array	Gets the separator for rows in array data in formula.
column_separator_of_formula_array	Gets the separator for the items in array’s row data in formula.

Methods

Method	Description
`get_pivot_total_name(self)`	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.
`get_pivot_grand_total_name(self)`	Gets the name of “Grand Total” label in the PivotTable.
`get_multiple_items_name(self)`	Gets the name of “(Multiple Items)” label in the PivotTable.
`get_all_name(self)`	Gets the name of “(All)” label in the PivotTable.
`get_protection_name_of_pivot_table(self)`	Gets the protection name in the PivotTable.
`get_column_labels_of_pivot_table(self)`	Gets the name of “Column Labels” label in the PivotTable.
`get_row_labels_name_of_pivot_table(self)`	Gets the name of “Row Labels” label in the PivotTable.
`get_empty_data_name(self)`	Gets the name of “(blank)” label in the PivotTable.
`get_data_field_header_name_of_pivot_table(self)`	Gets the the name of the value area field header in the PivotTable.
`get_sub_total_name(self, sub_total_type)`	Gets the name of `PivotFieldSubtotalType` type in the PivotTable.
`get_total_name(self, function_type)`	Gets the total name of specific function.
`get_grand_total_name(self, function_type)`	Gets the grand total name of the function.
`get_default_sheet_name(self)`	Gets the default sheet name for adding worksheet automatically. Default is “Sheet”.
`get_table_row_type_of_headers(self)`	Gets the type name of table rows that consists of the table header. Default is “Headers”, so in formula “#Headers” represents the table header.
`get_table_row_type_of_data(self)`	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.
`get_table_row_type_of_all(self)`	Gets the type name of table rows that consists of all rows in referenced table.
`get_table_row_type_of_totals(self)`	Gets the type name of table rows that consists of the total row of referenced table.
`get_table_row_type_of_current(self)`	Gets the type name of table rows that consists of the current row in referenced table.
`get_error_value_string(self, err)`	Gets the display string value for cell’s error value
`get_boolean_value_string(self, bv)`	Gets the display string value for cell’s boolean value
`get_local_function_name(self, standard_name)`	Gets the locale dependent function name according to given standard function name.
`get_standard_function_name(self, local_name)`	Gets the standard function name according to given locale dependent function name.
`get_local_built_in_name(self, standard_name)`	Gets the locale dependent text for built-in Name according to given standard text.
`get_standard_built_in_name(self, local_name)`	Gets the standard text of built-in Name according to given locale dependent text.
`get_standard_header_footer_font_style_name(self, localfont_style_name)`	Gets standard English font style name(Regular, Bold, Italic) for Header/Footer according to given locale font style name.
`get_comment_title_name(self, type)`	Gets the locale dependent comment title name according to comment title type.
`compare(self, v1, v2, ignore_case)`	Compares two string values according to certain collation rules.
`set_total_name(self, function_type, name)`	Sets the total name of specific function.
`set_grand_total_name(self, function_type, name)`	Sets the grand total name of specific function.
`set_table_row_type_of_headers(self, name)`	Sets the type name of table rows that consists of the table header.
`set_table_row_type_of_data(self, name)`	Sets the type name of table rows that consists of data region of referenced table.
`set_table_row_type_of_all(self, name)`	Sets the type name of table rows that consists of all rows in referenced table.
`set_table_row_type_of_totals(self, name)`	Sets the type name of table rows that consists of the total row of referenced table.
`set_table_row_type_of_current(self, name)`	Sets the type name of table rows that consists of the current row in referenced table.
`set_boolean_value_string(self, bv, name)`	Sets the display string value for cell’s boolean value
`set_local_function_name(self, standard_name, local_name, bidirectional)`	Sets the locale dependent function name corresponding to given standard function name.
`set_standard_function_name(self, local_name, standard_name, bidirectional)`	Sets the locale dependent function name according to given standard function name.
`set_local_built_in_name(self, standard_name, local_name, bidirectional)`	Sets the locale dependent text for the built-in name with given standard name text.
`set_standard_built_in_name(self, local_name, standard_name, bidirectional)`	Sets the locale dependent function name according to given standard function name.
`set_list_separator(self, c)`	Sets the separator for list, parameters of function, …etc.
`set_row_separator_of_formula_array(self, c)`	Sets the separator for rows in array data in formula.
`set_column_separator_of_formula_array(self, c)`	Sets the separator for the items in array’s row data in formula.
`set_standard_header_footer_font_style_name(self, localfont_style_name, standard_name)`	Sets the locale dependent function name according to given standard function name.
`set_comment_title_name(self, type, name)`	Gets the locale dependent comment title name according to comment title type.

SettableGlobalizationSettings class

SettableGlobalizationSettings class

Constructors

Properties

Methods

See Also