Issue 62056 - Using subtotals put meaningless grouping on the top
Summary: Using subtotals put meaningless grouping on the top
Status: CONFIRMED
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:
URL:
Keywords:
Depends on:
Blocks:
 
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: ---

Attachments
A simple example of the bug (10.11 KB, application/vnd.oasis.opendocument.spreadsheet)
2006-02-14 16:34 UTC, gee 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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.

Frank
Comment 3 Marcus 2017-05-20 11:13:28 UTC 
Reset assigne to the default "issues@openoffice.apache.org".