is there any shortcut that lets you unhide\re-expand all closed groups at once ?
Click on the number of the group on the top left of cells.
We learn something new every day. Even yesterday I had thought this was an answer. Now I learned it is a comment. 
Yes never is late to learn. IMHO the question is about a shortcut, my comment only indicates an alternative not a real answer to the question.
As always (next to?) you are right.
This is not really an answer to the original question. Regard the “if you can accept…”!
As far as I know there isn’t such a shortcut.
If you can accept the removal of the grouping on the occasion, you can create a shortcut for it via
>Tools>Customize>>Keyboard>>>Category=Data&Function=RemoveOutline.
Since the Group command and the Ungroup command seem to be assigned by default to F12 and Ctrl+F12, I would suggest you use Alt+F12 for the purpose.
To get (functionally) a solution for what I guess the original question aimed at, you would need some user code. You may use one or some of the folluwing Basic routines, and assign them to shortcuts:
Sub showAllHiddenColumnGroups()
sheet = ThisComponent.CurrentController.ActiveSheet
sheet.showLevel(&HFFFF, 0)
End Sub
Sub showAllHiddenRowGroups()
sheet = ThisComponent.CurrentController.ActiveSheet
sheet.showLevel(&HFFFF, 1)
End Sub
Sub showAllHiddenGroups()
showAllHiddenColumnGroups()
showAllHiddenRowGroups()
End Sub
Sub hideAllColumnGroups()
sheet = ThisComponent.CurrentController.ActiveSheet
sheet.showLevel(0, 0)
End Sub
Sub hideAllRowGroups()
sheet = ThisComponent.CurrentController.ActiveSheet
sheet.showLevel(0, 1)
End Sub
Sub hideAllGroups()
hideAllColumnGroups()
hideAllRowGroups()
End Sub
See also:
https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1sheet_1_1XSheetOutline.html
1 Like