Class SettablePivotGlobalizationSettings
Namespace: Aspose.Cells
Assembly: Aspose.Cells.dll (25.2.0)
Implementation of PivotGlobalizationSettings that supports user to set/change pre-defined texts.
public class SettablePivotGlobalizationSettings : PivotGlobalizationSettingsInheritance
object ← PivotGlobalizationSettings ← SettablePivotGlobalizationSettings
Inherited Members
PivotGlobalizationSettings.GetTextOfTotal(), PivotGlobalizationSettings.GetTextOfGrandTotal(), PivotGlobalizationSettings.GetTextOfMultipleItems(), PivotGlobalizationSettings.GetTextOfAll(), PivotGlobalizationSettings.GetTextOfProtectedName(string), PivotGlobalizationSettings.GetTextOfColumnLabels(), PivotGlobalizationSettings.GetTextOfRowLabels(), PivotGlobalizationSettings.GetTextOfEmptyData(), PivotGlobalizationSettings.GetTextOfDataFieldHeader(), PivotGlobalizationSettings.GetShortTextOf12Months(), PivotGlobalizationSettings.GetTextOf4Quaters(), PivotGlobalizationSettings.GetTextOfYears(), PivotGlobalizationSettings.GetTextOfQuarters(), PivotGlobalizationSettings.GetTextOfMonths(), PivotGlobalizationSettings.GetTextOfDays(), PivotGlobalizationSettings.GetTextOfHours(), PivotGlobalizationSettings.GetTextOfMinutes(), PivotGlobalizationSettings.GetTextOfSeconds(), PivotGlobalizationSettings.GetTextOfRange(), PivotGlobalizationSettings.GetTextOfSubTotal(PivotFieldSubtotalType), object.GetType(), object.MemberwiseClone(), object.ToString(), object.Equals(object?), object.Equals(object?, object?), object.ReferenceEquals(object?, object?), object.GetHashCode()
Constructors
SettablePivotGlobalizationSettings()
public SettablePivotGlobalizationSettings()Methods
GetTextOfAll()
Gets the text of “(All)” label in the PivotTable.
public override string GetTextOfAll()Returns
The text of “(All)” label
GetTextOfColumnLabels()
Gets the text of “Column Labels” label in the PivotTable.
public override string GetTextOfColumnLabels()Returns
The text of column labels
GetTextOfDataFieldHeader()
Gets the the text of the value area field header in the PivotTable.
public override string GetTextOfDataFieldHeader()Returns
The text of data field header name
GetTextOfEmptyData()
Gets the text of “(blank)” label in the PivotTable.
public override string GetTextOfEmptyData()Returns
The text of empty data
GetTextOfGrandTotal()
Gets the text of “Grand Total” label in the PivotTable.
public override string GetTextOfGrandTotal()Returns
The text of “Grand Total” label
GetTextOfMultipleItems()
Gets the text of “(Multiple Items)” label in the PivotTable.
public override string GetTextOfMultipleItems()Returns
The text of “(Multiple Items)” label
GetTextOfProtectedName(string)
Gets the text for specified protected name.
public override string GetTextOfProtectedName(string protectedName)Parameters
protectedName string
The protected name in PivotTable.
Returns
The local prorected names of PivotTable.
Remarks
In Ms Excel, some names are not allowed to be used as the name of PivotFields in PivotTable. They are different in different region, user may specify them explicitly according to the used region.
GetTextOfRowLabels()
Gets the text of “Row Labels” label in the PivotTable.
public override string GetTextOfRowLabels()Returns
The text of row labels
GetTextOfSubTotal(PivotFieldSubtotalType)
Gets the text of Aspose.Cells.Pivot.PivotFieldSubtotalType type in the PivotTable.
public override string GetTextOfSubTotal(PivotFieldSubtotalType subTotalType)Parameters
subTotalType PivotFieldSubtotalType
The Aspose.Cells.Pivot.PivotFieldSubtotalType
Returns
The text of given type
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.
public override string GetTextOfTotal()Returns
The text of “Total” label
SetTextOfAll(string)
Sets the text of “(All)” label in the PivotTable.
public void SetTextOfAll(string text)Parameters
text string
custom text
SetTextOfColumnLabels(string)
Gets the text of “Column Labels” label in the PivotTable.
public void SetTextOfColumnLabels(string text)Parameters
text string
The text of column labels
SetTextOfDataFieldHeader(string)
Sets the the text of the value area field header in the PivotTable.
public void SetTextOfDataFieldHeader(string text)Parameters
text string
The text of data field header name
SetTextOfEmptyData(string)
Sets the text of “(blank)” label in the PivotTable.
public void SetTextOfEmptyData(string text)Parameters
text string
The text of empty data
SetTextOfGrandTotal(string)
Sets the text of “Grand Total” label in the PivotTable.
public void SetTextOfGrandTotal(string text)Parameters
text string
custom text
SetTextOfMultipleItems(string)
Sets the text of “(Multiple Items)” label in the PivotTable.
public void SetTextOfMultipleItems(string text)Parameters
text string
custom text
SetTextOfProtectedName(string, string)
Sets the text for specific protected name.
public void SetTextOfProtectedName(string protectedName, string text)Parameters
protectedName string
The protected name in PivotTable.
text string
The local prorected names of PivotTable.
SetTextOfRowLabels(string)
Sets the text of “Row Labels” label in the PivotTable.
public void SetTextOfRowLabels(string text)Parameters
text string
The text of row labels
SetTextOfSubTotal(PivotFieldSubtotalType, string)
Sets the text of Aspose.Cells.Pivot.PivotFieldSubtotalType type in the PivotTable.
public void SetTextOfSubTotal(PivotFieldSubtotalType subTotalType, string text)Parameters
subTotalType PivotFieldSubtotalType
The Aspose.Cells.Pivot.PivotFieldSubtotalType
text string
The text of given type
SetTextOfTotal(string)
Sets the text of “Total” label in the PivotTable.
public void SetTextOfTotal(string text)Parameters
text string
custom text