Working with grids

It's important to familiarize yourself with working with data grids. Here's what you need to know about it.

Selecting columns

By clicking on the panel above the main grids, or more specifically on this button , The column selection menu is displayed. The data is organized by logical blocks:

The Hide entry in the context menu on a column header allows you to make it invisible.

The order and width of columns can be adjusted using the mouse.

Filters

A grid can be filtered from a column. By clicking on the filter button in its header, you can select different types of conditions or even build a logical combination of several conditions:

When a filter is active it is displayed below the grid, from where you can easily deactivate and reactivate it, or edit it to modify it:

In this area you can also find a list of the last filters used to reassign them more quickly.

The filter editor allows the construction of more advanced conditions. We find it in different places in Wiclax, whenever a participant selection condition can be customized.

Conditions in the editor can be grouped/organized using the and or or operators.

Filter row

Plus rapide pour certaines opérations, on peut encore afficher la ligne de filtre (menu contextuel) et ensuite saisir des valeurs à rechercher, juste sous l'entête. L'opérateur de recherche peut être sélectionné selon votre convenance.

Predefined filters

Wiclax also offers some useful filters for the grids of participants and results, which in this case complement the editable filters. They can get selected from this button located at the top right:

Sorting

Click on a column header to sort the grid by that data, in ascending order; click again to sort it in reverse order.

By holding down the Shift key, you keep the sorting of one column and complete it with that of another (secondary key).

Control + click on a header removes the column sorting.

Right click on a header also gives access to these features:

The natural sorting of the participant grid is done on the bib number, that of a result grid reflects the order of the ranking. This means that you do not have to worry about sorting the grid on the bib column in the first case or the place column in the second, you just have to make sure that no column is sorted.

Grouping

Grouping data is done by dragging a column header to the grouping panel at the top of the grid.

Multiple levels of grouping can be achieved by dragging the columns successively:

Right click on a group row to select all its child rows:

In some cases, you can drag lines of participants from one group to another to assign them the value corresponding to the destination group. For example, if the grid is grouped by heat number, or by starting wave.

Multiple edit

Multiple edit provides the ability to modify the same data for all the selected grid rows, in a single operation. After selection is ready, right click in one of the cells:

Clear a column

For columns that allow it, context menu on the header:

The operation applies to all visible rows of the grid.

Character case, replacements

Contextual menu on the header of a column, these 2 entries allow:

• to convert all data in the column to uppercase

• to replace one text fragment with another

Search

To search for specific data rather than participants, the magnifying glass at the top right of the grids allows you to quickly view the rows containing a subtext, in any column, and navigate among them.

The number of occurrences is displayed and the grid slider indicates their position.

Incremental search

A cell has the focus but is not in edit mode: by typing one or more characters the selection automatically moves to the next row where data begins with this text, among the active column.

Then using the Control+up arrow and Control+down arrow combinations, you can go to the previous or next occurrence.

Copy-Paste

Conditional formatting