Created attachment 195599 [details] Example file from Excel In the Excel Subtotal dialog, it is possible to use the "Summary below data" option to show the subtotals below or above the data. Calc does not have such an option, it can only put subtotals below the data, but not above it. 1. Open attached document in Excel and Calc 2. In Excel, go to Data - Outline - Subtotal -> there is a "Summary below data" box, checked on the "Below" sheet and not checked on the "Not below" sheet. 3. Open attached document in Calc 4. Go to Data - Subtotals - Options -> No similar box. Pressing OK on the "Not below" sheet would reset the layout of the subtotals to look like on the Below sheet. Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 46f7dcc5f499892ef093147b3f739c258bbf6b81 CPU threads: 14; OS: Windows 10 X86_64 (10.0 build 19045); UI render: default; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: default
Created attachment 195600 [details] Subtotal summary on the Below sheet in Excel and Calc
Created attachment 195601 [details] Subtotal summary on the Not Below sheet in Excel and Calc
Balazs Varga committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/26c08356d1b2a963efdca570979cb04388371400 tdf#162262 sc add "Summary below data" option for Subtotal dialog It will be available in 25.2.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.