Fig.1a

Click arrows to widen the filter pane (Fig.1a and Fig.2a) 

 

Fig.2a 

 

One of the most important functionalities of the FreeForm Viewer screen is Filtering.

FreeForm Report Filtering functionality helps filter rows displayed on the Free Form Report screen. 
 

Each worksheet can have a set of conditions associated with it.
Conditions control whether rows on that worksheet are hidden or not. By default the conditions are empty, and all rows are shown.
User can enter conditions on Report Editor and on Report Viewer. Conditions are not persisted in any way, they are discarded when user closes the screen (and the rows are returned to their un-hidden state). 

It is not recommended to use conditions on the same sheet on which hideRows() function is used, as the two will conflict. 

Conditions let you check the value of any given column on the worksheet (e.g. A, B, etc), in any combination. 

There is a button to add a predefined condition on a currently selected column in a worksheet (Fig.1): *Single value (adds condition where column != empty string)  

*List of values (adds a list condition populated with all distinct values of the column) 
*Wildcard (adds a wildcard condition where column LIKE ‘*’)]
*Freehand (adds 1=1 condition) 

 

 

Fig. 1 

1. “Single value option” lets you filter against a single value for a column

2. “List of values” option lets you filter against multiple values 

3. “Wildcard” option lets you filter on a wildcard, using * or ? as the wildcard symbols. * matches any part of the string, ? matches any single character 

If you have a row containing value ‘ aaaaa7’ and ‘ aaaaaa7’ you can create condition A is like ‘aaa*’ (where aaa* is a set value ) and both rows will be displayed. If you create condition ‘aaaa?’ then rows containing values with only one symbol after ‘aaaa’ will be displayed (Fig.6). 

 4. “Freehand” option lets you enter a formula which can compare multiple columns in a single expression. 

Also you can click x≥y and you see a list of conditions: 

 

Fig. 2 

Conditions are reevaluated and rows visibility is updated only at predefined moments, not every time something changes on a spreadsheet. For example, if user adjusts the cell which should have an effect on the rows visibility (and the adjusted cell is on the same sheet as the conditions), the rows will not be automatically shown/hidden. This is so for performance reasons. A “refresh” button on the condition panel may be clicked to reapply the conditions. 

The conditions are reapplied automatically at the following times: * When “refresh” button is clicked on condition panel ,  

Fig.3 

* When main “refresh” button is clicked on report editor, 

 

Fig.4 

* When user changes the conditions,
* When active sheet changes (convenient when adjustments are on a sheet different than the one with hidden rows). 

Whenever conditions are applied, the worksheet columns which are affected by conditions are specially marked so the user can see that he has filtering in effect. The marked columns have different title, e.g. “A [Filtered]” (Fig.5) 

Fig. 5 

Fig.6 

These conditions can be changed by user later on, or any other types of conditions can be added directly from the condition panel.
Value lookups are provided for convenience, based on the currently available values of cells in a given column on a worksheet.