Top10Filter

Top10Filter class

Represents the top N (percent or number of items) to filter by.

class Top10Filter;

Constructors

NameDescription
constructor(VObject)Constructs from a VObject convertible to this.

Properties

PropertyTypeDescription
isTopbooleanIndicates whether or not to filter by top order
isPercentbooleanIndicates whether or not to filter by percent value of the column
itemsnumberGets and sets top or bottom value to use as the filter criteria.
criteriaVObjectThe actual cell value in the range which is used to perform the comparison for this filter. This is the cache value during the refresh process.

Methods

MethodDescription
toVObject()Gets the VObject.

constructor(VObject)

Constructs from a VObject convertible to this.

constructor(vobj: VObject);

Parameters:

ParameterTypeDescription
vobjVObjectThe vobject.

isTop

Indicates whether or not to filter by top order

isTop : boolean;

isPercent

Indicates whether or not to filter by percent value of the column

isPercent : boolean;

items

Gets and sets top or bottom value to use as the filter criteria.

items : number;

criteria

The actual cell value in the range which is used to perform the comparison for this filter. This is the cache value during the refresh process.

criteria : VObject;

Remarks

NOTE: This member is now obsolete. Instead,please ignore this property. This property will be removed 12 months later since October 2025. Aspose apologizes for any inconvenience you may have experienced.

toVObject()

Gets the VObject.

toVObject() : VObject;