SpreadTop10Filter
Represents a Top 10 filter that shows the top or bottom N items or percentages.
Value represents a count when FilterType is TopNumber or BottomNumber, and a percentage when FilterType is TopPercent or BottomPercent. Note that BeginFiltering(SpreadAutoFilter) does not evaluate Top10 filters; the rules are emitted to the output but no rows are hidden based on them.
Definition
Namespace:Telerik.Documents.SpreadsheetStreaming
Assembly:Telerik.Documents.SpreadsheetStreaming.dll
Syntax:
public class SpreadTop10Filter : ISpreadFilterInheritance: objectSpreadTop10Filter
Implements:
Constructors
Initializes a new instance of the SpreadTop10Filter class.
public SpreadTop10Filter(SpreadTop10FilterType filterType, double value)The type of top/bottom filter.
valuedoubleThe count or percentage value. Must be a finite number greater than zero.
Exceptions: ArgumentOutOfRangeExceptionThrown when value is less than or equal to zero.
Thrown when value is NaN or Infinity.
See the class-level remarks for streaming-mode limitations regarding Top10 filter evaluation.
Properties
Gets the type of top/bottom filter.
public SpreadTop10FilterType FilterType { get; }