Aspose::Cells::Pivot::PivotFieldTop10AutoShowSettings class

PivotFieldTop10AutoShowSettings class

Represents the Top 10 AutoShow settings for a pivot field.

class PivotFieldTop10AutoShowSettings

Methods

MethodDescription
GetAutoShowCount()Represent the number of top or bottom items that are automatically shown in the specified PivotTable field.
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.
IsAutoShow()Indicates whether an “Top 10 AutoShow” filter is applied to this field.
IsNull() constChecks whether the implementation object is nullptr.
IsTop()Indicates whether the specified PivotTable field is autoshown ascending.
explicit operator bool() constoperator bool()
operator=(const PivotFieldTop10AutoShowSettings& src)operator=
PivotFieldTop10AutoShowSettings(PivotFieldTop10AutoShowSettings_Impl* impl)Constructs from an implementation object.
PivotFieldTop10AutoShowSettings(const PivotFieldTop10AutoShowSettings& src)Copy constructor.
SetAutoShowCount(int32_t value)Represent the number of top or bottom items that are automatically shown in the specified PivotTable field.
SetIsAutoShow(bool value)Indicates whether an “Top 10 AutoShow” filter is applied to this field.
SetIsTop(bool value)Indicates whether the specified PivotTable field is autoshown ascending.
SetRankBy(int32_t 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.
~PivotFieldTop10AutoShowSettings()Destructor.

Fields

FieldDescription
_implThe implementation object.

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.

See Also