List windows

To display lists, a universal list object was created.

The following actions are available:
 
Sort
Contents are sorted by columns, ascending or descending, when sort is chosen from the menu it is descending. Secondary sorting is also available, in the case the values in the primary one are equal. It can be set from the menu or by holding down Ctrl when pressing the column title.
Filtering
A given logical expression is evaluated for each row, rows for which it is false or zero are hidden. An empty expression is true. 
Cancel filter
Same as setting an empty filter expression.
Queries
Queries to the table, aggregation functions can be used (i.e. sum)
Selection
A list of unique vales of the given column is created and positioned as a separate menu item, late choosing a value in that menu will quickly select records with the appropriate value in the column. The column in this case is removed from the table. Filtering and sorting are  preserved.
Cancel selection
Cancel selection, filtering and sorting are preserved.
“Manual filters”
An easy way to create a simple filter like "Column" = "Value", you chose from a list of all unique values in the column. 
Custom column
Additional column is created, the user is asked to provide expression which is evaluated and shown for every row in that column.

Thus, to make the lists look like in GV one should chose selection by Race.

Keyboard shortcuts
 
Sort by (Alt+S)
Filter (Alt+L)
Query (Alt+Q)
Ctrl+A
Select all
Ctrl+Ins
Copy to clipboard

 

Mouse controls:
 
Single left button click in the column title
Change primary sort type (None -> Descending -> Ascending).
Ctrl+left in the title
Same for the secondary sort 
Right button in the title
local menu 

Also, one can always chose the "always on top" window placing, to do so use the window system menu.

back