wks.col.filter

filter

Syntax

wks.col.filter([Dialog])

Description

Open the filter dialog, where Dialog is:

0 = (default) open the associated filter dialog (Top N, Simple Numeric Filter, etc.).

1 = open the Custom Data Filter dialog.

Examples

The following example shows how to set up a Worksheet Filter. In this example we have a column of temperatures where we wish only to show rows where the temperature is greater than 75. The last line of script allows the user to manually modify and reapply filter.

newbook;
col(1) = data(1,31);
col(2)=uniform(31)*10+70;
wks.col2.filter = 1;
wks.col2.filterx$ = "temperature"; // variable name we will use
wks.col2.filter$ = "temperature > 75"; // our filter condition
wks.runfilter();
wks.col2.filter(); // open the associated filter dialog box to modify filter

See also

wks.col.filter, wks.col.filterx$