XlTop10Filter(Double) Constructor

Initializes a new instance of the XlTop10Filter class with the specified settings.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v18.2.Core.dll

Declaration

C#

public XlTop10Filter(
    double filterValue
)

VB.NET

Public Sub New(
    filterValue As Double
)

Parameters

Name	Type	Description
filterValue	Double	A Double value that is the actual cell value used by the filter to perform the comparison. This value is assigned to the XlTop10Filter.FilterValue property.

Remarks

This constructor enables you to quickly create a filter criterion that shows the top 10 items in the filtered column.

If you wish to change the default filter settings, use the following properties of the XlTop10Filter object:

• XlTop10Filter.Value - specifies how many top/bottom items to display;
• XlTop10Filter.Top - specifies whether column values are filtered by top or bottom order;
• XlTop10Filter.Percent - specifies whether to show values that fall in the top/bottom N percent of column values.