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:
I'd like to be able to fold it like this:
And also like this:
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:
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:
Continue doing so for rows 10-14 and so forth.
Finally, it should look something like this:
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.