Class PivotGlobalizationSettings
Namespace: Aspose.Cells.Settings
Assembly: Aspose.Cells.dll (25.2.0)
Represents the globalization settings for pivot tables.
public class PivotGlobalizationSettingsInheritance
object ← PivotGlobalizationSettings
Derived
SettablePivotGlobalizationSettings
Inherited Members
object.GetType(), object.MemberwiseClone(), object.ToString(), object.Equals(object?), object.Equals(object?, object?), object.ReferenceEquals(object?, object?), object.GetHashCode()
Constructors
PivotGlobalizationSettings()
public PivotGlobalizationSettings()Methods
GetShortTextOf12Months()
Gets all short formatted string of 12 months.
public virtual string[] GetShortTextOf12Months()Returns
string[]
GetTextOf4Quaters()
Gets the local text of 4 Quaters.
public virtual string[] GetTextOf4Quaters()Returns
string[]
GetTextOfAll()
Gets the text of “(All)” label in the PivotTable.
public virtual string GetTextOfAll()Returns
The text of “(All)” label
GetTextOfColumnLabels()
Gets the text of “Column Labels” label in the PivotTable.
public virtual string GetTextOfColumnLabels()Returns
The text of column labels
GetTextOfDataFieldHeader()
Gets the the text of the value area field header in the PivotTable.
public virtual string GetTextOfDataFieldHeader()Returns
The text of data field header name
GetTextOfDays()
Gets the local text of “Days”.
public virtual string GetTextOfDays()Returns
GetTextOfEmptyData()
Gets the text of “(blank)” label in the PivotTable.
public virtual string GetTextOfEmptyData()Returns
The text of empty data
GetTextOfGrandTotal()
Gets the text of “Grand Total” label in the PivotTable.
public virtual string GetTextOfGrandTotal()Returns
The text of “Grand Total” label
GetTextOfHours()
Gets the local text of “Hours”.
public virtual string GetTextOfHours()Returns
GetTextOfMinutes()
Gets the local text of “Minutes”.
public virtual string GetTextOfMinutes()Returns
GetTextOfMonths()
Gets the local text of “Months”.
public virtual string GetTextOfMonths()Returns
GetTextOfMultipleItems()
Gets the text of “(Multiple Items)” label in the PivotTable.
public virtual string GetTextOfMultipleItems()Returns
The text of “(Multiple Items)” label
GetTextOfProtectedName(string)
Gets the text for specified protected name.
public virtual 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.
GetTextOfQuarters()
Get the local text of “Quarters”.
public virtual string GetTextOfQuarters()Returns
GetTextOfRange()
Gets the local text of “Range”
public virtual string GetTextOfRange()Returns
GetTextOfRowLabels()
Gets the text of “Row Labels” label in the PivotTable.
public virtual string GetTextOfRowLabels()Returns
The text of row labels
GetTextOfSeconds()
Gets the local text of “Seconds”
public virtual string GetTextOfSeconds()Returns
GetTextOfSubTotal(PivotFieldSubtotalType)
Gets the text of Aspose.Cells.Pivot.PivotFieldSubtotalType type in the PivotTable.
public virtual 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 virtual string GetTextOfTotal()Returns
The text of “Total” label
GetTextOfYears()
Gets the local text of “Years”.
public virtual string GetTextOfYears()