PivotTableRefreshOption
Inheritance: java.lang.Object
public class PivotTableRefreshOption
Represents the options of refreshing data source of the pivot table.
Constructors
| Constructor | Description |
|---|---|
| PivotTableRefreshOption() | Represents the options of refreshing data source of the pivot table. |
Methods
| Method | Description |
|---|---|
| equals(Object arg0) | |
| getClass() | |
| getKeepCachedLocalGroupData() | Indicates whether to keep cached local group data if the maximum and minimum values remain unchanged. |
| getReserveMissingPivotItemType() | Represents how to reserve missing pivot items. |
| hashCode() | |
| isKeepOriginalOrder() | Indicates whether to keep pivot items’ original order as old data source. |
| notify() | |
| notifyAll() | |
| setKeepCachedLocalGroupData(boolean value) | Indicates whether to keep cached local group data if the maximum and minimum values remain unchanged. |
| setKeepOriginalOrder(boolean value) | Indicates whether to keep pivot items’ original order as old data source. |
| setReserveMissingPivotItemType(int value) | Represents how to reserve missing pivot items. |
| toString() | |
| wait() | |
| wait(long arg0) | |
| wait(long arg0, int arg1) |
PivotTableRefreshOption()
public PivotTableRefreshOption()
Represents the options of refreshing data source of the pivot table.
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
getKeepCachedLocalGroupData()
public boolean getKeepCachedLocalGroupData()
Indicates whether to keep cached local group data if the maximum and minimum values remain unchanged. The default value is false which means refreshing group with local setting.
Remarks
This is a temporary solution, please localize pivot tables by implementing PivotGlobalizationSettings
Returns: boolean
getReserveMissingPivotItemType()
public int getReserveMissingPivotItemType()
Represents how to reserve missing pivot items.
See ReserveMissingPivotItemType.
Returns: int
hashCode()
public native int hashCode()
Returns: int
isKeepOriginalOrder()
public boolean isKeepOriginalOrder()
Indicates whether to keep pivot items’ original order as old data source.
Remarks
Only applicable for the pivot field which is not sorted. When refreshing such kind of pivot field, Ms Excel keeps the original order of old data source. Default value of this property is true, representing the same behavior with Ms Excel. If user needs the pivot field to be refreshed completely as the data in the new data source, this property should be set as false.
Returns: boolean
notify()
public final native void notify()
notifyAll()
public final native void notifyAll()
setKeepCachedLocalGroupData(boolean value)
public void setKeepCachedLocalGroupData(boolean value)
Indicates whether to keep cached local group data if the maximum and minimum values remain unchanged. The default value is false which means refreshing group with local setting.
Remarks
This is a temporary solution, please localize pivot tables by implementing PivotGlobalizationSettings
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setKeepOriginalOrder(boolean value)
public void setKeepOriginalOrder(boolean value)
Indicates whether to keep pivot items’ original order as old data source.
Remarks
Only applicable for the pivot field which is not sorted. When refreshing such kind of pivot field, Ms Excel keeps the original order of old data source. Default value of this property is true, representing the same behavior with Ms Excel. If user needs the pivot field to be refreshed completely as the data in the new data source, this property should be set as false.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setReserveMissingPivotItemType(int value)
public void setReserveMissingPivotItemType(int value)
Represents how to reserve missing pivot items.
See ReserveMissingPivotItemType.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | int |
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 |
