Bug 140322 - Calc subtotals: can't only show the last line (grand sum)
Summary: Calc subtotals: can't only show the last line (grand sum)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.7.3 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, regression
Depends on:
Blocks: Function-Subtotal
  Show dependency treegraph
 
Reported: 2021-02-10 20:17 UTC by Shlage
Modified: 2022-02-05 19:10 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
Sample demo worksheet (8.00 KB, application/vnd.ms-excel)
2021-02-10 20:17 UTC, Shlage
Details
working (25.72 KB, image/png)
2021-02-11 11:52 UTC, BogdanB
Details
Creating group(s) for the sample demo sheet #1 (71.54 KB, image/png)
2021-02-22 23:32 UTC, Shlage
Details
Creating group(s) for the sample demo sheet #2 (29.03 KB, image/png)
2021-02-22 23:33 UTC, Shlage
Details
Creating group(s) for the sample demo sheet #3 (11.36 KB, image/png)
2021-02-22 23:33 UTC, Shlage
Details
Creating group(s) for the sample demo sheet #4 (53.93 KB, image/png)
2021-02-22 23:34 UTC, Shlage
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Shlage 2021-02-10 20:17:28 UTC
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.
Comment 1 BogdanB 2021-02-11 11:52:28 UTC Comment hidden (obsolete)
Comment 2 m.a.riosv 2021-02-11 17:18:36 UTC
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
Comment 3 Roman Kuznetsov 2021-02-22 21:54:09 UTC
(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
Comment 4 Shlage 2021-02-22 23:25:40 UTC
(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.
Comment 5 Shlage 2021-02-22 23:32:33 UTC
Created attachment 169975 [details]
Creating group(s) for the sample demo sheet #1
Comment 6 Shlage 2021-02-22 23:33:04 UTC
Created attachment 169976 [details]
Creating group(s) for the sample demo sheet #2
Comment 7 Shlage 2021-02-22 23:33:38 UTC
Created attachment 169977 [details]
Creating group(s) for the sample demo sheet #3
Comment 8 Shlage 2021-02-22 23:34:10 UTC
Created attachment 169978 [details]
Creating group(s) for the sample demo sheet #4
Comment 9 Roman Kuznetsov 2021-02-23 15:25:43 UTC
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
Comment 10 BogdanB 2021-07-31 05:44:20 UTC
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
Comment 11 BogdanB 2022-02-05 19:10:20 UTC
Still in
Version: 7.4.0.0.alpha0+ / LibreOffice Community
Build ID: d5f015185240a7bddfed7ddf10d6b5426e35fb72
CPU threads: 16; OS: Linux 5.13; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded