How does the group feature in LibreOffice Calc work

libreofficelibreoffice-calc

LibreOffice Calc has as Group feature. The official help site just tells you where to find the button and what hotkey to use, but doesn't explain what grouping actually does:

https://help.libreoffice.org/Calc/Group

I remember that MS Excel has something similar, but I can't recall how to make this work — I have a table that looks something like this:

enter image description here

I'd like to be able to fold it like this:

enter image description here

And also like this:

enter image description here

Can this be achieved using Calc's Group feature?

Best Answer

Apparently, the Group feature can be used in the following way to hide certain rows, however, it involves selecting a lot of rows (considering a large table) manually and so isn't really user-friendly:

Step 1: Select row 4 and hit F12 to group (hide) the row:

enter image description here

Continue doing so for rows 6, 8, 10 and so on.

Step 2: Select rows 4-8 and hit F12 to group (hide) the rows:

enter image description here

Continue doing so for rows 10-14 and so forth.

Finally, it should look something like this:

enter image description here

Now, rows can be folded as desired.

To sum it up, the Group feature doesn't seem to do anything automatically. It just allows you to fold/hide certain rows or columns that you defined manually.

Related Question