To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78878 Issue #|78878 Summary|Grouping cells makes incorrect sum Component|Spreadsheet Version|OOo 2.2 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|mrbeardy
------- Additional comments from [EMAIL PROTECTED] Tue Jun 26 02:40:12 +0000 2007 ------- 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 Cat,Cat,Cat,Cat,Dog,Dog,Dog,Mouse,Mouse,Rabit - 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 ==end== --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]