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

MethodDescription
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:

ParameterTypeDescription
arg0java.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:

ParameterTypeDescription
valueboolean

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:

ParameterTypeDescription
valueint

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:

ParameterTypeDescription
valueint

setTop(boolean value)

public void setTop(boolean value)

Indicates whether the specified PivotTable field is autoshown ascending.

Parameters:

ParameterTypeDescription
valueboolean

toString()

public String toString()

Returns: java.lang.String

wait()

public final void wait()

wait(long arg0)

public final native void wait(long arg0)

Parameters:

ParameterTypeDescription
arg0long

wait(long arg0, int arg1)

public final void wait(long arg0, int arg1)

Parameters:

ParameterTypeDescription
arg0long
arg1int