In most tables, sorting is performed by clicking the left mouse button
on the title of the column along which you want to sort. By default,
sorting is done in an ascending way. If you click again on a column that
was sorted in an ascending order, it will become sorted in a descending
order.
In some tables, several columns can be sorted in a specific order. To do
so, hold down the Ctrl key and select the columns in the desired
order, without releasing the Ctrl key. Once you have selected the
columns, release the key.
Press the Ctrl+F keyboard shortcut to switch a table's column to
search mode. Next, type the symbol sequence that you are searching for.
To find the next match of the text, press the Ctrl+Enter keyboard
shortcut. If you want to find the previous match, press
Ctrl+Shift+Enter.
When the column in which the search is performed is protected from
editing, entering in edit mode is done automatically by directly writing
the character sequence that you are searching for. After a span of 1.5
seconds of inactivity, the table will automatically exit the search
mode.
In most tables, filtering is performed by entering the criterion by
which you will filter specific column(s) in the filter field of the
specified column (the grey fields, right below the table's header. If
they are not visible, check below how to activate them.) and pressing
Enter.
More complex filter criteria are also available, for example:
10.% - all rows that begin with 10 in the specified column will
be displayed. In other words, "%" replaces multiple characters.
20.1_ - all records that begin with 20, such as 20.10,
20.11, 20.12 * will be displayed, but not 20.10.10. In other words,
**"_*"** replaces one character.
< 50 - all that are less than 50
>0.5 AND <=50 - there is an option to use the logical operator
"AND"
< 10.11.2004 - it is possible to filter records before a
specified date (or after а specified date, if the symbol ">" is
used)
< 50 OR >100 - the logical operator "OR" is used
in (1,2,3,4) - enumerating a list of values
- ~ Text% - similar to
The filter criteria form is
[Operator1] Operand1 [)] [AND|OR Operator2 Operand2[)]]
where the OperatorX is one of
[=|<>|!=|>|<|>=|<=|~|!~|IN(]
and OperatorX is a number, date, or string, whereas for the
Operator, IN is a list of values, separated by a comma.
If the button is
available at the upper left corner of the table, when you select it, the
table's system menu will appear. The system menu will give you access to
some additional functions. These functions may vary depending on the
program product that you are using.
Some of the functions are:
The context menu allows for print preview, preview in
editor, saving files in various formats (Text, HTML, RTF, XLS, CSV,
VCLDBIFF), as well as their visualisation in MS Excel and OpenOffice.
To be able to change some of the settings, you must first disable the
Use default settings option.
When you open the Columns tab, the column list will be shown. Mark or
unmark each option to indicate whether the column will be visible or
not. If you want to rearrange the columns, you can use the and buttons.
For each column, you can set the following parameters:
Once you are ready, click the Save button to save the changes.