## SettablePivotGlobalizationSettings class

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

```csharp
public class SettablePivotGlobalizationSettings : PivotGlobalizationSettings
```

## Constructors

| Name | Description |
| --- | --- |
| [SettablePivotGlobalizationSettings](settablepivotglobalizationsettings/)() | The default constructor. |

## Methods

| Name | Description |
| --- | --- |
| virtual [GetFormatOfDayGroup](../../aspose.cells.settings/pivotglobalizationsettings/getformatofdaygroup/)() | Gets the number format of pivot day group. Only used when grouping the pivot field by days. The default vaule is "d-MMM";(Inherited from [`PivotGlobalizationSettings`](../../aspose.cells.settings/pivotglobalizationsettings/).) |
| virtual [GetNameOfDataField](../../aspose.cells.settings/pivotglobalizationsettings/getnameofdatafield/)(ConsolidationFunction, string) | Gets the display name of data pivot field. The default format is "Sum Of Field".(Inherited from [`PivotGlobalizationSettings`](../../aspose.cells.settings/pivotglobalizationsettings/).) |
| virtual [GetShortTextOf12Months](../../aspose.cells.settings/pivotglobalizationsettings/getshorttextof12months/)() | Gets all short formatted string of 12 months.(Inherited from [`PivotGlobalizationSettings`](../../aspose.cells.settings/pivotglobalizationsettings/).) |
| virtual [GetTextOf24Hours](../../aspose.cells.settings/pivotglobalizationsettings/gettextof24hours/)() | Gets all local formatted string of 24 hours. The default value is 12 AM, 1 AM, 2 AM, 3 AM, 4 AM, 5 AM, 6 AM, 7 AM, 8 AM, 9 AM, 10 AM, 11 AM, 12 PM, 1 PM, 2 PM, 3 PM, 4 PM, 5 PM, 6 PM, 7 PM, 8 PM, 9 PM, 10 PM, 11 PM.(Inherited from [`PivotGlobalizationSettings`](../../aspose.cells.settings/pivotglobalizationsettings/).) |
| virtual [GetTextOf4Quarters](../../aspose.cells.settings/pivotglobalizationsettings/gettextof4quarters/)() | Gets the local text of 4 Quarters.(Inherited from [`PivotGlobalizationSettings`](../../aspose.cells.settings/pivotglobalizationsettings/).) |
| virtual [GetTextOf4Quaters](../../aspose.cells.settings/pivotglobalizationsettings/gettextof4quaters/)() | (**Obsolete.**) Gets the local text of 4 Quarters.(Inherited from [`PivotGlobalizationSettings`](../../aspose.cells.settings/pivotglobalizationsettings/).) |
| override [GetTextOfAll](../../aspose.cells/settablepivotglobalizationsettings/gettextofall/)() | Gets the text of "(All)" label in the PivotTable. |
| virtual [GetTextOfAllPeriods](../../aspose.cells.settings/pivotglobalizationsettings/gettextofallperiods/)() | Gets the localized text of "All Periods".(Inherited from [`PivotGlobalizationSettings`](../../aspose.cells.settings/pivotglobalizationsettings/).) |
| override [GetTextOfColumnLabels](../../aspose.cells/settablepivotglobalizationsettings/gettextofcolumnlabels/)() | Gets the text of "Column Labels" label in the PivotTable. |
| override [GetTextOfDataFieldHeader](../../aspose.cells/settablepivotglobalizationsettings/gettextofdatafieldheader/)() | Gets the the text of the value area field header in the PivotTable. |
| virtual [GetTextOfDays](../../aspose.cells.settings/pivotglobalizationsettings/gettextofdays/)() | Gets the local text of "Days".(Inherited from [`PivotGlobalizationSettings`](../../aspose.cells.settings/pivotglobalizationsettings/).) |
| override [GetTextOfEmptyData](../../aspose.cells/settablepivotglobalizationsettings/gettextofemptydata/)() | Gets the text of "(blank)" label in the PivotTable. |
| override [GetTextOfGrandTotal](../../aspose.cells/settablepivotglobalizationsettings/gettextofgrandtotal/)() | Gets the text of "Grand Total" label in the PivotTable. |
| virtual [GetTextOfHours](../../aspose.cells.settings/pivotglobalizationsettings/gettextofhours/)() | Gets the local text of "Hours".(Inherited from [`PivotGlobalizationSettings`](../../aspose.cells.settings/pivotglobalizationsettings/).) |
| virtual [GetTextOfMinutes](../../aspose.cells.settings/pivotglobalizationsettings/gettextofminutes/)() | Gets the local text of "Minutes".(Inherited from [`PivotGlobalizationSettings`](../../aspose.cells.settings/pivotglobalizationsettings/).) |
| virtual [GetTextOfMonths](../../aspose.cells.settings/pivotglobalizationsettings/gettextofmonths/)() | Gets the local text of "Months".(Inherited from [`PivotGlobalizationSettings`](../../aspose.cells.settings/pivotglobalizationsettings/).) |
| override [GetTextOfMultipleItems](../../aspose.cells/settablepivotglobalizationsettings/gettextofmultipleitems/)() | Gets the text of "(Multiple Items)" label in the PivotTable. |
| virtual [GetTextOfOr](../../aspose.cells.settings/pivotglobalizationsettings/gettextofor/)() | Gets all local formatted string of "or".(Inherited from [`PivotGlobalizationSettings`](../../aspose.cells.settings/pivotglobalizationsettings/).) |
| override [GetTextOfProtectedName](../../aspose.cells/settablepivotglobalizationsettings/gettextofprotectedname/)(string) | Gets the text for specified protected name. |
| virtual [GetTextOfProtection](../../aspose.cells.settings/pivotglobalizationsettings/gettextofprotection/)() | (**Obsolete.**) Gets the protection name in the PivotTable.(Inherited from [`PivotGlobalizationSettings`](../../aspose.cells.settings/pivotglobalizationsettings/).) |
| virtual [GetTextOfQuarters](../../aspose.cells.settings/pivotglobalizationsettings/gettextofquarters/)() | Get the local text of "Quarters".(Inherited from [`PivotGlobalizationSettings`](../../aspose.cells.settings/pivotglobalizationsettings/).) |
| virtual [GetTextOfRange](../../aspose.cells.settings/pivotglobalizationsettings/gettextofrange/)() | Gets the local text of "Range"(Inherited from [`PivotGlobalizationSettings`](../../aspose.cells.settings/pivotglobalizationsettings/).) |
| override [GetTextOfRowLabels](../../aspose.cells/settablepivotglobalizationsettings/gettextofrowlabels/)() | Gets the text of "Row Labels" label in the PivotTable. |
| virtual [GetTextOfSeconds](../../aspose.cells.settings/pivotglobalizationsettings/gettextofseconds/)() | Gets the local text of "Seconds"(Inherited from [`PivotGlobalizationSettings`](../../aspose.cells.settings/pivotglobalizationsettings/).) |
| override [GetTextOfSubTotal](../../aspose.cells/settablepivotglobalizationsettings/gettextofsubtotal/)(PivotFieldSubtotalType) | Gets the text of [`PivotFieldSubtotalType`](../../aspose.cells.pivot/pivotfieldsubtotaltype/) type in the PivotTable. |
| override [GetTextOfTotal](../../aspose.cells/settablepivotglobalizationsettings/gettextoftotal/)() | Gets the text of "Total" label in the PivotTable. You need to override this method when the PivotTable contains two or more PivotFields in the data area. |
| virtual [GetTextOfYears](../../aspose.cells.settings/pivotglobalizationsettings/gettextofyears/)() | Gets the local text of "Years".(Inherited from [`PivotGlobalizationSettings`](../../aspose.cells.settings/pivotglobalizationsettings/).) |
| [SetTextOfAll](../../aspose.cells/settablepivotglobalizationsettings/settextofall/)(string) | Sets the text of "(All)" label in the PivotTable. |
| [SetTextOfColumnLabels](../../aspose.cells/settablepivotglobalizationsettings/settextofcolumnlabels/)(string) | Gets the text of "Column Labels" label in the PivotTable. |
| [SetTextOfDataFieldHeader](../../aspose.cells/settablepivotglobalizationsettings/settextofdatafieldheader/)(string) | Sets the the text of the value area field header in the PivotTable. |
| [SetTextOfEmptyData](../../aspose.cells/settablepivotglobalizationsettings/settextofemptydata/)(string) | Sets the text of "(blank)" label in the PivotTable. |
| [SetTextOfGrandTotal](../../aspose.cells/settablepivotglobalizationsettings/settextofgrandtotal/)(string) | Sets the text of "Grand Total" label in the PivotTable. |
| [SetTextOfMultipleItems](../../aspose.cells/settablepivotglobalizationsettings/settextofmultipleitems/)(string) | Sets the text of "(Multiple Items)" label in the PivotTable. |
| [SetTextOfProtectedName](../../aspose.cells/settablepivotglobalizationsettings/settextofprotectedname/)(string, string) | Sets the text for specific protected name. |
| [SetTextOfRowLabels](../../aspose.cells/settablepivotglobalizationsettings/settextofrowlabels/)(string) | Sets the text of "Row Labels" label in the PivotTable. |
| [SetTextOfSubTotal](../../aspose.cells/settablepivotglobalizationsettings/settextofsubtotal/)(PivotFieldSubtotalType, string) | Sets the text of [`PivotFieldSubtotalType`](../../aspose.cells.pivot/pivotfieldsubtotaltype/) type in the PivotTable. |
| [SetTextOfTotal](../../aspose.cells/settablepivotglobalizationsettings/settextoftotal/)(string) | Sets the text of "Total" label in the PivotTable. |

### Examples

```csharp
namespace AsposeCellsExamples
{
    using Aspose.Cells;
    using System;

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

            try
            {
                // Create an instance of the SettablePivotGlobalizationSettings class
                SettablePivotGlobalizationSettings settings = new SettablePivotGlobalizationSettings();

                // Set custom texts for various PivotTable elements
                settings.SetTextOfTotal("Total Amount");
                settings.SetTextOfGrandTotal("Grand Total Amount");
                settings.SetTextOfMultipleItems("Multiple Items Selected");
                settings.SetTextOfAll("All Items");
                settings.SetTextOfColumnLabels("Column Headers");
                settings.SetTextOfRowLabels("Row Headers");
                settings.SetTextOfEmptyData("No Data");
                settings.SetTextOfDataFieldHeader("Data Values");

                // Demonstrate getting the set values
                Console.WriteLine($"Total text: {settings.GetTextOfTotal()}");
                Console.WriteLine($"Grand Total text: {settings.GetTextOfGrandTotal()}");
                Console.WriteLine($"Multiple Items text: {settings.GetTextOfMultipleItems()}");
                Console.WriteLine($"All text: {settings.GetTextOfAll()}");
                Console.WriteLine($"Column Labels text: {settings.GetTextOfColumnLabels()}");
                Console.WriteLine($"Row Labels text: {settings.GetTextOfRowLabels()}");
                Console.WriteLine($"Empty Data text: {settings.GetTextOfEmptyData()}");
                Console.WriteLine($"Data Field Header text: {settings.GetTextOfDataFieldHeader()}");

                // Save the workbook to demonstrate successful execution
                workbook.Save("SettablePivotGlobalizationSettingsDemo.xlsx");
                Console.WriteLine("SettablePivotGlobalizationSettings instance created and configured successfully");
            }
            catch (Exception ex)
            {
                Console.WriteLine($"Error working with SettablePivotGlobalizationSettings: {ex.Message}");
            }
        }
    }
}
```

### See Also

* class [PivotGlobalizationSettings](../../aspose.cells.settings/pivotglobalizationsettings/)
* namespace [Aspose.Cells](../../aspose.cells/)
* assembly [Aspose.Cells](../../)