New to Telerik Document Processing? Start a free 30-day trial

IFilter

Interface

Common contract for filters that control row visibility in AutoFilter ranges by evaluating cell values.

Definition

Assembly:Telerik.Windows.Documents.Spreadsheet.dll

Syntax:

public interface IFilter

Retrieves the cell value at the specified position, transforming it as needed for filter evaluation.

object GetValue(Cells cells, int rowIndex, int columnIndex)

Parameters:cellsCells

The cells of the worksheet.

rowIndexint

Index of the row.

columnIndexint

Index of the column.

Returns:

The value of the cell.

Evaluates whether the row containing the specified value should remain visible based on the filter criteria.

bool ShouldShowValue(object value)

Parameters:valueobject

The value retrieved by the GetValue method.

Returns:

A value indicating whether the row which contains the specified value will be shown

Column index within the filter range where this filter applies, zero-based relative to the first column of the filter range.

int RelativeColumnIndex { get; }

Property Value:

The relative index of the column.