Issue 78878 - Grouping cells makes incorrect sum
Summary: Grouping cells makes incorrect sum
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.2
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2007-06-26 03:40 UTC by mrbeardy
Modified: 2013-08-07 15:12 UTC (History)
3 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

Spreadsheet as described in bug report (10.97 KB, text/plain)
2007-06-26 03:52 UTC, mrbeardy
no flags Details
Spreadsheet as described in bug report (10.97 KB, application/vnd.sun.xml.calc)
2007-06-26 03:52 UTC, mrbeardy
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description mrbeardy 2007-06-26 03:40:12 UTC
This may be a bug or just a counter-intuitive result of grouping cells.

Issue: Two columns that should add up to the same value don't.

How to reproduce:

- Open calc doc
- Form three columns with 10 rows
- Put the following headings, Animal Type, Animal Weight, Sum of Animal Group
- Place values in first column going down
- In second column put a random number between 1 and 20 in each row
- In last column copy and past the values from second column
- Go to the first Cat row, in the third column use the sum function to sum all
the weights of Cats in row two.
- Select the cell you just put the sum in for cats, select down over other Cat
rows then hit the Merge Cells button, when prompted with an option dialogue say No.
- Repeat until the third column has a summed weight for each animal type.
- In the row below the last put a Total row in and then individually sum column
two then three

You will observe that while visually you would expect both columns to add up to
the same number they don't. The reason is that the sum function is adding up
values hidden under the merged cells. You can expose those numbers by
highlighting the merged cell and unmerging it.

Email me if you need any more information

Comment 1 mrbeardy 2007-06-26 03:52:34 UTC
Created attachment 46242 [details]
Spreadsheet as described in bug report
Comment 2 mrbeardy 2007-06-26 03:52:49 UTC
Created attachment 46243 [details]
Spreadsheet as described in bug report
Comment 3 mrbeardy 2007-06-26 03:54:05 UTC
Ignore the first file I uploaded. That was a mistake.

P.S. this is my first OOo bug report so sorry if I broke any conventions.
Comment 4 helenrussian 2007-07-01 05:12:09 UTC
Confirming with OOo 2.2.1 on Linux
Comment 5 kpalagin 2007-07-01 05:53:33 UTC
Confirming with 2.2 on WinXP - as described.
Comment 6 frank 2007-07-11 14:02:05 UTC

the cells under the merged ones contain data and this data can be used in
calculations, therefore the SUM function works as expected.

But is this the desired behavior ? As this is not a defect but an enhancement
request, user experience has to decide how to proceed.

Comment 7 frank.loehmann 2007-09-03 16:35:15 UTC
Set target.
Comment 8 pmike 2008-02-09 09:25:03 UTC
Could this issue be targeted to 3.0?
OOo shows completely incorrect behavior from users' point of view. And this may
lead to "miscalculations" or wrong assumptions (especially if Calc is being used
for financial calculations).