GlobalizationSettings class
GlobalizationSettings class
Represents the globalization settings.
The GlobalizationSettings type exposes the following members:
Constructors
| Constructor | Description |
|---|---|
| init | Constructs a new instance of GlobalizationSettings |
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 | 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 | Gets the name of “Grand Total” label in the PivotTable. |
| get_multiple_items_name | Gets the name of “(Multiple Items)” label in the PivotTable. |
| get_all_name | Gets the name of “(All)” label in the PivotTable. |
| get_protection_name_of_pivot_table | Gets the protection name in the PivotTable. |
| get_column_labels_of_pivot_table | Gets the name of “Column Labels” label in the PivotTable. |
| get_row_labels_name_of_pivot_table | Gets the name of “Row Labels” label in the PivotTable. |
| get_empty_data_name | Gets the name of “(blank)” label in the PivotTable. |
| get_data_field_header_name_of_pivot_table | Gets the the name of the value area field header in the PivotTable. |
| get_sub_total_name | Gets the name of PivotFieldSubtotalType type in the PivotTable. |
| get_total_name | Gets the total name of the function. |
| get_grand_total_name | Gets the grand total name of the function. |
| get_default_sheet_name | Gets the default sheet name for adding worksheet automatically. Default is “Sheet”. |
| get_table_row_type_of_headers | 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 | 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 | 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. |
| get_table_row_type_of_totals | 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. |
| get_table_row_type_of_current | 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. |
| get_error_value_string | Gets the display string value for cell’s error value |
| get_boolean_value_string | Gets the display string value for cell’s boolean value |
| get_local_function_name | Gets the locale dependent function name according to given standard function name. |
| get_standard_function_name | Gets the standard function name according to given locale dependent function name. |
| get_local_built_in_name | Gets the locale dependent text for built-in Name according to given standard text. |
| get_standard_built_in_name | Gets the standard text of built-in Name according to given locale dependent text. |
| get_standard_header_footer_font_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 | Gets the locale dependent comment title name according to comment title type. |
| compare | Compares two string values according to certain collation rules. |
See Also
- module
aspose.cells - class
PivotFieldSubtotalType
