Bug 88794 - EDITING, editing subtotal function options adds columns group
Summary: EDITING, editing subtotal function options adds columns group
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.5.0 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Function-Subtotal
  Show dependency treegraph
Reported: 2015-01-25 20:51 UTC by Robert Gonzalez MX
Modified: 2022-02-07 16:49 UTC (History)
4 users (show)

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

Test file (71.88 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-01-25 20:51 UTC, Robert Gonzalez MX
screenshoots (281.63 KB, application/vnd.oasis.opendocument.text)
2015-06-20 23:35 UTC, Robert Gonzalez MX
Demonstrates multiple column groups (36.16 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-06-28 07:22 UTC, Dietrich Schulten
Test file subtotals (26.58 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-04-29 15:47 UTC, Robert Gonzalez MX

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Gonzalez MX 2015-01-25 20:51:21 UTC
Created attachment 112796 [details]
Test file

In LO on Wondows 8.1 editing the subtotals options in the dialog, adds another column grouping each time.

Steps to reproduce

Open test file
go to cell A1
Select Data from the menu bar
Select Subtotals
Select Group by: Group
Select Calculate subtotals for: months
Select use fuction: sum
Select tab options
Select option include formats
Apply with OK

Repeat the steps to edit any option
Apply with OK
A new columns group appear

Repeat again editng any other option
A new columns group appear

Remove the subtotals
Select Data from the menu bar
Select option subtotals
Select in the dialog the Remove option
The subtotals are removed but the grouping doesn't.

You have to remove it with the menu option as fallows:
Group and Outline

Expected behavior:
Editing subtotals options it shouldn't add more column grouping
When removing the subtotals it should revome the column grouping as it does with the rows grouping.
Comment 1 raal 2015-01-26 15:16:57 UTC
I can confirm with Version:
Build ID: 60143f4f7bc50054dcef923218b8c7c3bc154933
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-01-21_04:58:34

Reproducible with LO 3.5, lowering version
Comment 2 Robert Gonzalez MX 2015-05-24 00:24:18 UTC
Reproducible with Version:
Build ID: 0a16c3dda4150008d9be6f24cbd15ac198d116d3
Locale: es-MX (es_MX)on windows 8
Comment 3 Robert Gonzalez MX 2015-06-20 23:33:22 UTC
Just tested this with LO 3.3 and OO 3.2.1 on Windows 8 and is present. So I can say it is inherited form OO.
Comment 4 Robert Gonzalez MX 2015-06-20 23:35:08 UTC
Created attachment 116692 [details]
Comment 5 Dietrich Schulten 2015-06-28 07:22:29 UTC
Created attachment 116881 [details]
Demonstrates multiple column groups
Comment 6 Dietrich Schulten 2015-06-28 07:24:43 UTC
As a workaround, one can use Data-Group and Outline-Remove to get rid of the superfluous column groups.

I must also say, I do not understand how the column grouping is applied for subtotals. The column grouping seems not to be documented anywhere.

In the attached sample document, I have grouped by week and let calc sum up both the the items and the items+1 columns. Hit Data-Subtotals to see what I did.

The column grouping allows to hide the date and the items column. I fail to see the logic behind this.
Comment 7 QA Administrators 2016-09-20 10:11:39 UTC Comment hidden (obsolete)
Comment 8 Robert Gonzalez MX 2018-04-29 15:45:44 UTC
Tested with Version: (x64)
Build ID: cb47f0d320994e001bc38dc2ee9b7d957b15e6ab
CPU threads: 8; OS: Windows 10.0; UI render: GL; 
Locale: es-MX (es_MX); Calc: CL

Still present. 

In the attached spreadsheet, with four numeric data columns, every time I repeat the process to apply subtotals, selecting one column at a time, a new data group is created on top of the spreadsheet.
Comment 9 Robert Gonzalez MX 2018-04-29 15:47:29 UTC
Created attachment 141759 [details]
Test file subtotals
Comment 10 QA Administrators 2019-04-30 02:41:32 UTC Comment hidden (obsolete)
Comment 11 Robert Gonzalez MX 2019-09-24 19:06:33 UTC
Hi there.

Tested with Version:
Build ID: b79626edf0065ac373bd1df5c28bd630b4424273
CPU threads: 8; OS: Linux 4.12; UI render: default; VCL: kde5; 
Locale: es-MX (es_MX.UTF-8); UI-Language: en-US
Calc: threaded

Same behavior. Every time I repeat the process to apply subtotals a new column data group is created on top of the spreadsheet.
Comment 12 QA Administrators 2021-09-24 04:07:03 UTC Comment hidden (obsolete)
Comment 13 BogdanB 2022-02-05 19:19:02 UTC
Also in
Version: / 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
Comment 14 Robert Gonzalez MX 2022-02-07 16:49:43 UTC
Good day to every one.

Just tested with

Version: / LibreOffice Community
Build ID: 0f246aa12d0eee4a0f7adcefbf7c878fc2238db3
CPU threads: 4; OS: Linux 5.16; UI render: default; VCL: kf5 (cairo+xcb)
Locale: es-MX (es_MX.UTF-8); UI: es-ES
Calc: threaded

It is still reproducible. Just repeat Data-Subtotals-OK several times, and a new column group is added.