Issue 62056 - Using subtotals put meaningless grouping on the top
Summary: Using subtotals put meaningless grouping on the top
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 2.0.1
Hardware: All All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2006-02-14 16:32 UTC by gee
Modified: 2017-05-20 11:13 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

A simple example of the bug (10.11 KB, application/vnd.oasis.opendocument.spreadsheet)
2006-02-14 16:34 UTC, gee
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description gee 2006-02-14 16:32:12 UTC
Hi, check out the file I attach!

I have several rows, I turn on subtotals summarizing 3 columns grouping first 
by year then by quarter.

The subtotals are OK. The grouping of the rows are OK.

However on the top, there is a grouping, that groups one column apparently 
several times.

It is meaningless, as all it does is hide one single columnt, and when you 
have 5 or 6 similar grouping marks on a single coulumn, it is quite 
embrassing. It takes too much space and gives nothing.

In the example I am attaching there are only 2 lines and 3 numbers; in the 
real spreadsheet I use I have seven lines and 8 numbers, and another column is 
grouped similarly, although only once (meaningless all the same).

I don't understand the whole point, why is tehere a grouping at all?
Comment 1 gee 2006-02-14 16:34:49 UTC
Created attachment 34152 [details]
A simple example of the bug
Comment 2 frank 2006-02-15 13:13:06 UTC
Hi Niklas,

as you told me this seems to be caused by the generation of the subtotal
formulas and the according groupings.

Comment 3 Marcus 2017-05-20 11:13:28 UTC
Reset assigne to the default "".