PivotFieldTop10AutoShowSettings
Inheritance: java.lang.Object
public class PivotFieldTop10AutoShowSettings
Represents the Top 10 AutoShow settings for a pivot field.
Remarks
In xls : Implementing top 10 filters in Xls through Top 10 AutoShow In ooxml files: The underlying ooxml file format supports Top10 AutoShow, but Excel 2007 and later user interface only provides access via Top10 filter. If XLS compatibility is not required, it is recommended to use Top10 filter instead.
Methods
| Method | Description |
|---|---|
| equals(Object arg0) | |
| getAutoShowCount() | Represent the number of top or bottom items that are automatically shown in the specified PivotTable field. |
| getClass() | |
| getRankBy() | Specifies the index of data field for AutoShow ranking. |
| hashCode() | |
| isAutoShow() | Indicates whether an “Top 10 AutoShow” filter is applied to this field. |
| isTop() | Indicates whether the specified PivotTable field is autoshown ascending. |
| notify() | |
| notifyAll() | |
| setAutoShow(boolean value) | Indicates whether an “Top 10 AutoShow” filter is applied to this field. |
| setAutoShowCount(int value) | Represent the number of top or bottom items that are automatically shown in the specified PivotTable field. |
| setRankBy(int value) | Specifies the index of data field for AutoShow ranking. |
| setTop(boolean value) | Indicates whether the specified PivotTable field is autoshown ascending. |
| toString() | |
| wait() | |
| wait(long arg0) | |
| wait(long arg0, int arg1) |
equals(Object arg0)
public boolean equals(Object arg0)
Parameters:
| Parameter | Type | Description |
|---|---|---|
| arg0 | java.lang.Object |
Returns: boolean
getAutoShowCount()
public int getAutoShowCount()
Represent the number of top or bottom items that are automatically shown in the specified PivotTable field.
Returns: int
getClass()
public final native Class<?> getClass()
Returns: java.lang.Class
getRankBy()
public int getRankBy()
Specifies the index of data field for AutoShow ranking. Represents auto show field index. -1 means PivotField itself. It should be the index of the data fields.
Returns: int
hashCode()
public native int hashCode()
Returns: int
isAutoShow()
public boolean isAutoShow()
Indicates whether an “Top 10 AutoShow” filter is applied to this field.
Returns: boolean
isTop()
public boolean isTop()
Indicates whether the specified PivotTable field is autoshown ascending.
Returns: boolean
notify()
public final native void notify()
notifyAll()
public final native void notifyAll()
setAutoShow(boolean value)
public void setAutoShow(boolean value)
Indicates whether an “Top 10 AutoShow” filter is applied to this field.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setAutoShowCount(int value)
public void setAutoShowCount(int value)
Represent the number of top or bottom items that are automatically shown in the specified PivotTable field.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | int |
setRankBy(int value)
public void setRankBy(int value)
Specifies the index of data field for AutoShow ranking. Represents auto show field index. -1 means PivotField itself. It should be the index of the data fields.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | int |
setTop(boolean value)
public void setTop(boolean value)
Indicates whether the specified PivotTable field is autoshown ascending.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
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 |