Created attachment 169656 [details] Sample demo worksheet Hello, Having upgraded from version 5 to the latest 7.1.0.3, I can't anymore show only the last line (grand sum) for subtotals. When clicking on level 1 (on the left-hand side), it always shows the last sub-total line **and** the grand sum one. Attached is a sample worksheet, although the issue can easily be replicated. Thank you for your time. John B.
Created attachment 169668 [details] working I tested on Version: 7.1.0.3 (x64) / LibreOffice Community Build ID: f6099ecf3d29644b5008cc8f48f42f4a40986e4c CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win Locale: ro-RO (ro_RO); UI: en-US Calc: threaded and this is how it looks. It's ok like that?
Works fine with: Versión: 5.4.0.0.beta1 (x64) Id. de compilación: 8672113ead4e403c55e31b1d9a3d1e0f3b299577 Subproc. CPU: 4; SO: Windows 6.19; Repres. IU: predet.; Configuración regional: es-ES (es_ES); Calc: group Reproducible Versión: 6.0.7.1 (x64) Id. de compilación: 5d2cb2a5dd04fe174b336488731eb50bbb5faed3 Subprocs. CPU: 4; SO: Windows 10.0; Repres. IU: predet.; Configuración regional: es-ES (es_ES); Calc: group threaded up to Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 44b914b1e2616ca8f70e896e653a46ca93610234 CPU threads: 4; OS: Windows 10.0 Build 21296; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL
(In reply to m.a.riosv from comment #2) > Works fine with: > Versión: 5.4.0.0.beta1 (x64) > Id. de compilación: 8672113ead4e403c55e31b1d9a3d1e0f3b299577 > Subproc. CPU: 4; SO: Windows 6.19; Repres. IU: predet.; > Configuración regional: es-ES (es_ES); Calc: group > I checked back to 5.0 version and in every version I still see two rows with Subtotal when I click to level 1. Question to bug reporter: how did you set up a group for level 1? If I do some rework of your file then I get a needed result - I see only grand total for level 1
(In reply to Roman Kuznetsov from comment #3) > I checked back to 5.0 version and in every version I still see two rows with > Subtotal when I click to level 1. > > Question to bug reporter: how did you set up a group for level 1? > > If I do some rework of your file then I get a needed result - I see only > grand total for level 1 Please see the first 3 attached PNG screenshots showing how I created the sub-totals. I still cannot display the grand sum row only when clicking on level 1. However, if I create a second (useless to me) group (see attachment #4), clicking on level 2 will then show two grand totals lines (Grand Count AND Grand Sum), and clicking on level 1 will show only Grand Sum. You mentioned doing some rework on the sheet: Could you please give me the details? Thank you.
Created attachment 169975 [details] Creating group(s) for the sample demo sheet #1
Created attachment 169976 [details] Creating group(s) for the sample demo sheet #2
Created attachment 169977 [details] Creating group(s) for the sample demo sheet #3
Created attachment 169978 [details] Creating group(s) for the sample demo sheet #4
Damn! I'm so sorry for the noise, I just thought wrong about your problem=( Miguel in Comment 2 was absolutely right, it's a regression in 6.0 version. I'll try bisect it... So I made the bisect and got a sha - e8d370e84af5dc9b8817cbf5aa66e50db150a0c6 https://gerrit.libreoffice.org/c/core/+/42042 https://git.libreoffice.org/core/commit/e8d370e84af5dc9b8817cbf5aa66e50db150a0c6 Added to CC: Eike Rathke, Jean-Sebastien Bevilacqua
Wrong also in Version: 7.3.0.0.alpha0+ / LibreOffice Community Build ID: 5aa74aa1e6fac571f99146ebcb6adc9feb1459ad CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-07-28_19:35:14 Calc: threaded