There is not possibility to check all column (with headers) at once in Calc Subtotals configuration window.
If you have file with many columns with daily revenue for example you have to check 30 or more columns per month.
It would be nice to have button or checkbox to check all column (with headers) at once and uncheck couple columns.
Created attachment 162425 [details]
Calc Subtotals configuration window
Making Subtotals on many columns in Calc
Created attachment 162427 [details]
Calc new Subtotals configuration window
New Subtotal configuration window should look like this.
When you check Select all columns checkbox it will check all columns listed in the list of Calculate subtotals for.
Let's ask the UX-team.
In general +1 from me
We could add a checkbox "[ ] all columns" next to the list header (Calculate subtotals for:). Checking it enables all checkboxes in the list, unchecking would consequently uncheck all, and the indetermined state is needed for varying states.
Alternatively a context menu could provide the singular function "Check All".
Tomofumi Yagi committed a patch related to this issue.
It has been pushed to "master":
tdf#133886 - Libreoffice Calc Subtotals check all columns at once
It will be available in 7.1.0.
The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
Tomofumi: if this is fixed, you can set the status to resolved fixed. Peter could also test and comment. https://dev-builds.libreoffice.org/daily/master/current.html