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:
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:
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):
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:
So, it depends on the data and the use case when choosing between grouping and filtering data.
This is really helpful in my case, on the other hand it still leaves me wondering what the group feature is actually meant to do. Maybe it's just misnamed -- as far as I understand it, there is no real grouping going on. It just folds rows or columns. – tmh – 2015-12-20T11:08:48.807
AutoFilter is more flexible - but you can't define beforehand which rows to hide. Grouping is useful if you want to hide/show certain rows often - with groups defined, only one click is required to hide/show the group. There may also be cases with big sheets where AutoFilter doesn't work in the way i've described, e.g. if there are now empty cells to use as filter criteria. If there are no empty cells, defining groups is usually the better way to show/hide content (gerenally speaking - depends on the use case). – tohuwawohu – 2015-12-20T11:15:35.667