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. Thank you.
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". Code pointer: sc/uiconfig/scalc/ui/subtotalgrppage.ui sc/source/ui/dbgui/tpsubt.cxx
Tomofumi Yagi committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/e0c1fdcab23dbd2b7a0a7227557d7afc41b49bd7 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: https://wiki.documentfoundation.org/Testing_Daily_Builds 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