[]
Provides a Top10Filter class to filter cells whose values are numeric.
public class Top10FilterItem : BaseFilterItem, ISerializeSupport, ISortedFilterItem, IFilterItem
Public Class Top10FilterItem
Inherits BaseFilterItem
Implements ISerializeSupport, ISortedFilterItem, IFilterItem
| Name | Description |
|---|---|
| Top10FilterItem(bool, int, bool) | Creates a new Top10Filter instance with customized settings. |
| Name | Description |
|---|---|
| DisplayAtTopOfList | Gets or sets whether the display name is added to the top of the filter drop-down list. |
| DisplayName | Gets the display name of the filter. |
| IsDescending | Gets or sets a boolean value that specifies whether numeric numbers are filtered in descending order. |
| IsPercent | Gets or sets a boolean value that specifies whether the filter is based on a percentage. |
| Rank | Gets or sets a number filter. |
| SheetView | Sets the SheetView object to the filter. |
| Name | Description |
|---|---|
| Deserialize(XmlNodeReader) | Loads the object from XML. |
| Filter(int) | Filters the specified column of the sheet. |
| Serialize(XmlTextWriter) | Saves the object to XML. |
| ShowInDropDown(int, int[]) | Determines whether the name is displayed in the filter drop-down list. |