> For the complete documentation index, see [llms.txt](https://docs.wiclax.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.wiclax.com/it/utilizza-wiclax/linterfaccia-generale/lavorare-con-le-griglie.md).

# Lavorare con le griglie

È importante familiarizzare con il lavoro con le griglie di dati. Ecco cosa devi sapere a riguardo.

## Selecting columns

Cliccando sul pannello sopra le griglie principali, o in alternativa su questo pulsante <img src="https://2309109415-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMmAbOjoyl6NhBeeNtxJy%2Fuploads%2FmtOEM5iYMkUQtCMmlgA7%2Fimage.png?alt=media&amp;token=f76b9bd6-ed23-4ae1-9246-749c3910848d" alt="" data-size="line">, viene visualizzato il menu di selezione delle colonne. I dati sono organizzati in blocchi logici:&#x20;

&#x20;

<figure><img src="https://2309109415-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMmAbOjoyl6NhBeeNtxJy%2Fuploads%2F2VT2dt9BS8qZCrZcXUkH%2Fimage.png?alt=media&amp;token=959d010a-e129-429e-9445-822a740fd69d" alt="" width="332"><figcaption></figcaption></figure>

La voce `Nascondi` nel menu contestuale di un'intestazione di colonna consente di renderla invisibile.

L'ordine e la larghezza delle colonne possono essere modificati utilizzando il mouse.

## Filtri

Una griglia può essere filtrata da una colonna. Cliccando sul pulsante filtro nella sua intestazione, puoi selezionare diversi tipi di condizioni o persino creare una combinazione logica di diverse condizioni:&#x20;

| <img src="https://2309109415-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMmAbOjoyl6NhBeeNtxJy%2Fuploads%2FTAgNoZf82LAAucBij0fO%2Fimage.png?alt=media&amp;token=825f3ced-ae78-4206-9910-d1830bc16b11" alt="" data-size="original"> | <img src="https://2309109415-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMmAbOjoyl6NhBeeNtxJy%2Fuploads%2FYa65lg465iBDQd9ys7bA%2Fimage.png?alt=media&amp;token=e2e20962-f47c-40fe-88de-7c9ca44d5965" alt="" data-size="original"> |
| --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |

Quando un filtro è attivo viene visualizzato sotto la griglia, da dove puoi facilmente disattivarlo e riattivarlo, oppure modificarlo per modificarlo:

<figure><img src="https://2309109415-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMmAbOjoyl6NhBeeNtxJy%2Fuploads%2FXgzCtrvlpSmfY4J4jahN%2Fimage.png?alt=media&amp;token=beaa1f3a-4198-4cad-ba33-b570cb92c573" alt="" width="379"><figcaption></figcaption></figure>

In quest'area puoi trovare anche l'elenco degli ultimi filtri utilizzati per riassegnarli più rapidamente.

L'editor di filtri consente la costruzione di condizioni più avanzate. Lo troviamo in diversi posti in Wiclax, ogni volta che una condizione di selezione dei partecipanti può essere personalizzata.

Le condizioni nell'editor possono essere raggruppate/organizzate utilizzando gli operatori e o o.

<figure><img src="https://2309109415-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMmAbOjoyl6NhBeeNtxJy%2Fuploads%2F0UZb8wGw9lf2uX8d8Uoq%2Fimage.png?alt=media&amp;token=891ecdd5-928a-441b-bd08-19e623cedad4" alt="" width="421"><figcaption></figcaption></figure>

<figure><img src="https://2309109415-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMmAbOjoyl6NhBeeNtxJy%2Fuploads%2FA3k2qtSVB99u74s7lSy9%2Fimage.png?alt=media&amp;token=d3f422aa-704d-4d41-94ae-5139fe43dcff" alt="" width="446"><figcaption></figcaption></figure>

### Riga di filtro

Più veloce per alcune operazioni, è comunque possibile visualizzare la riga di filtro (menu contestuale) e poi inserire i valori da cercare, proprio sotto l'intestazione. L'operatore di ricerca può essere selezionato secondo la vostra comodità.

<figure><img src="https://2309109415-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMmAbOjoyl6NhBeeNtxJy%2Fuploads%2FMwQoBaACPKkNvKtiiQSi%2Fimage.png?alt=media&amp;token=5f186fb9-fc07-455c-8c09-881df005e6e4" alt="" width="274"><figcaption></figcaption></figure>

<figure><img src="https://2309109415-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMmAbOjoyl6NhBeeNtxJy%2Fuploads%2FL5O6E4dkCeETIZ7RKkSo%2Fimage.png?alt=media&amp;token=9ff08d6a-654b-434e-9919-b2ff6635b519" alt="" width="341"><figcaption></figcaption></figure>

### Filtri predefiniti

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:

<figure><img src="https://2309109415-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMmAbOjoyl6NhBeeNtxJy%2Fuploads%2FBsp7MtPyQTzZ0sRY28MO%2Fimage.png?alt=media&amp;token=463303a8-655e-4f83-acf4-bb4a35025777" alt="" width="175"><figcaption></figcaption></figure>

## Sorting

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

<figure><img src="https://2309109415-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMmAbOjoyl6NhBeeNtxJy%2Fuploads%2FtcGTqQpIOWtJMw09WFRG%2Fimage.png?alt=media&amp;token=64756b1c-3d70-423c-91d8-9cc1fdea7cab" alt="" width="190"><figcaption></figcaption></figure>

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:&#x20;

<figure><img src="https://2309109415-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMmAbOjoyl6NhBeeNtxJy%2Fuploads%2FHblAHbN3YlP4CKUSmJ1t%2Fimage.png?alt=media&amp;token=9357b884-ca56-457f-b1d6-232d8333f349" alt="" width="239"><figcaption></figcaption></figure>

{% hint style="info" %}
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.
{% endhint %}

## Raggruppamento

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:

<figure><img src="https://2309109415-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMmAbOjoyl6NhBeeNtxJy%2Fuploads%2F6H9Kb2tHiQ6vwvANmCR8%2Fimage.png?alt=media&amp;token=ea2d8f01-7f24-4eba-9f03-39d260c7ee51" alt="" width="189"><figcaption></figcaption></figure>

Right click on a group row to select all its child rows:&#x20;

<figure><img src="https://2309109415-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMmAbOjoyl6NhBeeNtxJy%2Fuploads%2FY7DbGqhjf5yhzEbkvaF0%2Fimage.png?alt=media&amp;token=bf0839a4-d50d-482d-9540-a9c9c317288f" alt="" width="407"><figcaption></figcaption></figure>

{% hint style="info" %}
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.
{% endhint %}

## 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:

<figure><img src="https://2309109415-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMmAbOjoyl6NhBeeNtxJy%2Fuploads%2FfqJ1Simc7vJcwVaUhPbj%2Fimage.png?alt=media&amp;token=7071a4ee-1fcb-4746-abea-dcdf2f34506e" alt="" width="280"><figcaption></figcaption></figure>

<figure><img src="https://2309109415-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMmAbOjoyl6NhBeeNtxJy%2Fuploads%2FIaUVBdiKHgkwzRECU7b4%2Fimage.png?alt=media&amp;token=5e75e184-4dd6-40d6-adbd-7ec793d4ce60" alt="" width="308"><figcaption></figcaption></figure>

## Clear a column

For columns that allow it, context menu on the header:&#x20;

<figure><img src="https://2309109415-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMmAbOjoyl6NhBeeNtxJy%2Fuploads%2F6FGaTGdfPEqL8FMg260h%2Fimage.png?alt=media&amp;token=60eaf500-7188-408b-9fa8-09e0f0278f9e" alt="" width="227"><figcaption></figcaption></figure>

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:&#x20;

* to convert all data in the column to uppercase
* to replace one text fragment with another

<figure><img src="https://2309109415-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMmAbOjoyl6NhBeeNtxJy%2Fuploads%2F0PlBqRzfW0mEKVmpdfPn%2Fimage.png?alt=media&amp;token=44c07a50-9e91-4990-a88f-e66ce9a0ae7f" alt="" width="269"><figcaption></figcaption></figure>

## Ricerca

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.

<figure><img src="https://2309109415-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMmAbOjoyl6NhBeeNtxJy%2Fuploads%2FWgEO54R8hUhtv7eD0ZWv%2Fimage.png?alt=media&amp;token=24b28d80-c59d-4df9-805f-91734e428887" alt="" width="124"><figcaption></figcaption></figure>

<figure><img src="https://2309109415-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMmAbOjoyl6NhBeeNtxJy%2Fuploads%2FINY7RUdP9Dx0GdIHGNeh%2Fimage.png?alt=media&amp;token=e822e23d-c464-4013-b1c8-b77220068a67" alt="" width="364"><figcaption></figcaption></figure>

Viene visualizzato il numero di occorrenze e la barra di scorrimento della griglia indica la loro posizione.

## Ricerca incrementale

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.

<figure><img src="https://2309109415-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMmAbOjoyl6NhBeeNtxJy%2Fuploads%2FDk1e1z7rS6yBP4znETct%2Fimage.png?alt=media&amp;token=fb5bced0-198f-45f7-92c7-44a885b6febb" alt="" width="185"><figcaption></figcaption></figure>

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

## Copy-Paste

## Conditional formatting


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.wiclax.com/it/utilizza-wiclax/linterfaccia-generale/lavorare-con-le-griglie.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
