How does the group feature in LibreOffice Calc work?

Solution 1:

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.

Solution 2:

Regarding the Grouping feature: Often, the OpenOffice documentation has more information on certain features, than the LibreOffice docs. Take care that OO and LO have developed independently since some years, but basic functionality is still the same. The OO docs have some info on hiding/showing data.

In your case, using a AutoFilter is the best way to hide certain empty rows. First, you should add a (quite simple) header row to your data:

enter image description here

Now, just select menu Data -> Filter... -> AutoFilter - this will add some small filter buttons to the header row. For example, the filter button for col C will show the following filter dialog:

enter image description here

To hide row 3, row 5 and so on, click on the AutoFilter button of Col C and select Not empty. This will hide every row where the C cell is empty.

To keep only rows 2, 8 and 14 (with text Alpha, Beta and Gamma), use the AutoFilter button on Col A and select Not empty.


Grouping or outlining data is quite easy if there's a clear structure in the data. For example, assuming that your first example contains sum rows for each of the three groups (E7, E13 and E19 are each the sum of the five cells above):

enter image description here

In such a case, LO calc is able to determine the structure and to auto-outline the data. In this example, just select A2:E19 and select Menu Data -> Group and Outline -> AutoOutline. Calc will create three groups, just based on the sum function in col E:

enter image description here

So, it depends on the data and the use case when choosing between grouping and filtering data.