TopFilterCriterion Class

TopFilterCriterionlink

Filters to the top or bottom N items (or N percent) of a column.

Declaration

public TopFilterCriterion()

Bottomlink

When true, keep the lowest values instead of the highest.

Declaration

public bool Bottom { get; set; }

Property Value

Columnlink

The column this filter applies to.

Declaration

public int Column { get; set; }

Property Value

Countlink

When Percent is false, the number of rows to keep. When true, a 0..100 percentage of the rows.

Declaration

public int Count { get; set; }

Property Value

Percentlink

Count is interpreted as a percentage instead of a row count.

Declaration

public bool Percent { get; set; }

Property Value

Acceptlink

Declaration

public override void Accept(Documents.Spreadsheet.IFilterCriterionVisitor visitor)

Parameters

Matcheslink

Declaration

public override bool Matches(Documents.Spreadsheet.Worksheet sheet, int row)

Parameters

Returns

OnApplylink

Declaration

public override void OnApply(Documents.Spreadsheet.Worksheet sheet, Documents.Spreadsheet.RangeRef range)

Parameters