SettablePivotGlobalizationSettings

Inheritance: java.lang.Object, com.aspose.cells.PivotGlobalizationSettings

public class SettablePivotGlobalizationSettings extends PivotGlobalizationSettings

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

Constructors

Constructor	Description
SettablePivotGlobalizationSettings()

Methods

Method	Description
equals(Object arg0)
getClass()
getShortTextOf12Months()	Gets all short formatted string of 12 months.
getTextOf4Quaters()	Gets the local text of 4 Quaters.
getTextOfAll()	Gets the text of “(All)” label in the PivotTable.
getTextOfColumnLabels()	Gets the text of “Column Labels” label in the PivotTable.
getTextOfDataFieldHeader()	Gets the the text of the value area field header in the PivotTable.
getTextOfDays()	Gets the local text of “Days”.
getTextOfEmptyData()	Gets the text of “(blank)” label in the PivotTable.
getTextOfGrandTotal()	Gets the text of “Grand Total” label in the PivotTable.
getTextOfHours()	Gets the local text of “Hours”.
getTextOfMinutes()	Gets the local text of “Minutes”.
getTextOfMonths()	Gets the local text of “Months”.
getTextOfMultipleItems()	Gets the text of “(Multiple Items)” label in the PivotTable.
getTextOfProtectedName(String protectedName)	Gets the text for specified protected name.
getTextOfProtection()	Gets the protection name in the PivotTable.
getTextOfQuarters()	Get the local text of “Quarters”.
getTextOfRange()	Gets the local text of “Range”
getTextOfRowLabels()	Gets the text of “Row Labels” label in the PivotTable.
getTextOfSeconds()	Gets the local text of “Seconds”
getTextOfSubTotal(int subTotalType)	Gets the text of PivotFieldSubtotalType type in the PivotTable.
getTextOfTotal()	Gets the text of “Total” label in the PivotTable.
getTextOfYears()	Gets the local text of “Years”.
hashCode()
notify()
notifyAll()
setTextOfAll(String text)	Sets the text of “(All)” label in the PivotTable.
setTextOfColumnLabels(String text)	Gets the text of “Column Labels” label in the PivotTable.
setTextOfDataFieldHeader(String text)	Sets the the text of the value area field header in the PivotTable.
setTextOfEmptyData(String text)	Sets the text of “(blank)” label in the PivotTable.
setTextOfGrandTotal(String text)	Sets the text of “Grand Total” label in the PivotTable.
setTextOfMultipleItems(String text)	Sets the text of “(Multiple Items)” label in the PivotTable.
setTextOfProtectedName(String protectedName, String text)	Sets the text for specific protected name.
setTextOfRowLabels(String text)	Sets the text of “Row Labels” label in the PivotTable.
setTextOfSubTotal(int subTotalType, String text)	Sets the text of PivotFieldSubtotalType type in the PivotTable.
setTextOfTotal(String text)	Sets the text of “Total” label in the PivotTable.
toString()
wait()
wait(long arg0)
wait(long arg0, int arg1)

SettablePivotGlobalizationSettings()

public SettablePivotGlobalizationSettings()

equals(Object arg0)

public boolean equals(Object arg0)

Parameters:

Parameter	Type	Description
arg0	java.lang.Object

Returns: boolean

getClass()

public final native Class<?> getClass()

Returns: java.lang.Class

getShortTextOf12Months()

public String[] getShortTextOf12Months()

Gets all short formatted string of 12 months.

Returns: java.lang.String[] -

getTextOf4Quaters()

public String[] getTextOf4Quaters()

Gets the local text of 4 Quaters.

Returns: java.lang.String[] -

getTextOfAll()

public String getTextOfAll()

Gets the text of “(All)” label in the PivotTable.

Returns: java.lang.String - The text of “(All)” label

getTextOfColumnLabels()

public String getTextOfColumnLabels()

Gets the text of “Column Labels” label in the PivotTable.

Returns: java.lang.String - The text of column labels

getTextOfDataFieldHeader()

public String getTextOfDataFieldHeader()

Gets the the text of the value area field header in the PivotTable.

Returns: java.lang.String - The text of data field header name

getTextOfDays()

public String getTextOfDays()

Gets the local text of “Days”.

Returns: java.lang.String -

getTextOfEmptyData()

public String getTextOfEmptyData()

Gets the text of “(blank)” label in the PivotTable.

Returns: java.lang.String - The text of empty data

getTextOfGrandTotal()

public String getTextOfGrandTotal()

Gets the text of “Grand Total” label in the PivotTable.

Returns: java.lang.String - The text of “Grand Total” label

getTextOfHours()

public String getTextOfHours()

Gets the local text of “Hours”.

Returns: java.lang.String -

getTextOfMinutes()

public String getTextOfMinutes()

Gets the local text of “Minutes”.

Returns: java.lang.String -

getTextOfMonths()

public String getTextOfMonths()

Gets the local text of “Months”.

Returns: java.lang.String -

getTextOfMultipleItems()

public String getTextOfMultipleItems()

Gets the text of “(Multiple Items)” label in the PivotTable.

Returns: java.lang.String - The text of “(Multiple Items)” label

getTextOfProtectedName(String protectedName)

public String getTextOfProtectedName(String protectedName)

Gets the text for specified protected name.

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.

Parameters:

Parameter	Type	Description
protectedName	java.lang.String	The protected name in PivotTable.

Returns: java.lang.String - The local prorected names of PivotTable.

getTextOfProtection()

public String getTextOfProtection()

Gets the protection name in the PivotTable.

Remarks

NOTE: This member is now obsolete. Instead, please use PivotGlobalizationSettings.GetTextOfProtectedName(string) method. This property will be removed 12 months later since March 2023. Aspose apologizes for any inconvenience you may have experienced.

Returns: java.lang.String - The protection name of PivotTable

getTextOfQuarters()

public String getTextOfQuarters()

Get the local text of “Quarters”.

Returns: java.lang.String -

getTextOfRange()

public String getTextOfRange()

Gets the local text of “Range”

Returns: java.lang.String -

getTextOfRowLabels()

public String getTextOfRowLabels()

Gets the text of “Row Labels” label in the PivotTable.

Returns: java.lang.String - The text of row labels

getTextOfSeconds()

public String getTextOfSeconds()

Gets the local text of “Seconds”

Returns: java.lang.String -

getTextOfSubTotal(int subTotalType)

public String getTextOfSubTotal(int subTotalType)

Gets the text of PivotFieldSubtotalType type in the PivotTable.

Parameters:

Parameter	Type	Description
subTotalType	int	PivotFieldSubtotalType. The PivotFieldSubtotalType

Returns: java.lang.String - The text of given type

getTextOfTotal()

public String 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.

Returns: java.lang.String - The text of “Total” label

getTextOfYears()

public String getTextOfYears()

Gets the local text of “Years”.

Returns: java.lang.String -

hashCode()

public native int hashCode()

Returns: int

notify()

public final native void notify()

notifyAll()

public final native void notifyAll()

setTextOfAll(String text)

public void setTextOfAll(String text)

Sets the text of “(All)” label in the PivotTable.

Parameters:

Parameter	Type	Description
text	java.lang.String	custom text

setTextOfColumnLabels(String text)

public void setTextOfColumnLabels(String text)

Gets the text of “Column Labels” label in the PivotTable.

Parameters:

Parameter	Type	Description
text	java.lang.String	The text of column labels

setTextOfDataFieldHeader(String text)

public void setTextOfDataFieldHeader(String text)

Sets the the text of the value area field header in the PivotTable.

Parameters:

Parameter	Type	Description
text	java.lang.String	The text of data field header name

setTextOfEmptyData(String text)

public void setTextOfEmptyData(String text)

Sets the text of “(blank)” label in the PivotTable.

Parameters:

Parameter	Type	Description
text	java.lang.String	The text of empty data

setTextOfGrandTotal(String text)

public void setTextOfGrandTotal(String text)

Sets the text of “Grand Total” label in the PivotTable.

Parameters:

Parameter	Type	Description
text	java.lang.String	custom text

setTextOfMultipleItems(String text)

public void setTextOfMultipleItems(String text)

Sets the text of “(Multiple Items)” label in the PivotTable.

Parameters:

Parameter	Type	Description
text	java.lang.String	custom text

setTextOfProtectedName(String protectedName, String text)

public void setTextOfProtectedName(String protectedName, String text)

Sets the text for specific protected name.

Parameters:

Parameter	Type	Description
protectedName	java.lang.String	The protected name in PivotTable.
text	java.lang.String	The local prorected names of PivotTable.

setTextOfRowLabels(String text)

public void setTextOfRowLabels(String text)

Sets the text of “Row Labels” label in the PivotTable.

Parameters:

Parameter	Type	Description
text	java.lang.String	The text of row labels

setTextOfSubTotal(int subTotalType, String text)

public void setTextOfSubTotal(int subTotalType, String text)

Sets the text of PivotFieldSubtotalType type in the PivotTable.

Parameters:

Parameter	Type	Description
subTotalType	int	PivotFieldSubtotalType. The PivotFieldSubtotalType
text	java.lang.String	The text of given type

setTextOfTotal(String text)

public void setTextOfTotal(String text)

Sets the text of “Total” label in the PivotTable.

Parameters:

Parameter	Type	Description
text	java.lang.String	custom text

toString()

public String toString()

Returns: java.lang.String

wait()

public final void wait()

wait(long arg0)

public final native void wait(long arg0)

Parameters:

Parameter	Type	Description
arg0	long

wait(long arg0, int arg1)

public final void wait(long arg0, int arg1)

Parameters:

Parameter	Type	Description
arg0	long
arg1	int