Issue 69975

Summary: Table in writer counts sum incorrectly
Product: Writer Reporter: tuharsky <tuharsky>
Component: codeAssignee: AOO issues mailing list <issues>
Status: ACCEPTED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: baumux, issues
Version: OOo 2.0.3   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Test case. The sum is 10 instead of 21. none

Description tuharsky 2006-09-29 12:07:25 UTC 
1, Open an empty Writer document
2, insert table with several rows.
3, Put some numbers into the empty cells.
4, Insert a sum function to the last row so that it counts the sum of all cells
above. 
5, Select all cells (expecting the last one) and change the Table -> Format to
Text. Try to sum again.
6, Select again, change Format to Number. Sum it.

Now insert few rows to the table, above the sum row and do the steps 3-6. Play
with it a while.

As You can probably see, the sum dosen't always give good results. Seems like
the inserted rows simply aren't taken into account sometimes.
Comment 1 tuharsky 2006-09-29 12:08:15 UTC 
Created attachment 39452 [details]
Test case. The sum is 10 instead of 21.
Comment 2 michael.ruess 2006-09-29 13:27:02 UTC 
MRU->OS: odd thing, but here in the attached document, the sum function
calculates "wrongly". It looks that the cells A5 and A6 are not take into
account of the calculation.
Comment 3 cyphra 2006-12-02 03:14:41 UTC 
it works for the 2nd column
Comment 4 Martin Hollmichel 2007-09-10 13:36:42 UTC 
move target to 3.x according http://wiki.services.openoffice.org/wiki/Target_3x
Comment 5 Oliver Specht 2009-02-05 13:01:27 UTC 
The cells in row 1 to 4 contain a float value related to their text content. Row
5-6 contain a float value of 0. If all cells get a number format applied this
will be visible. It should better be prohibited to calculate cells that are
formatted as text to prevent confusion. 
The way the table has been created seems a bit strange, anyway.
Comment 6 tuharsky 2009-02-05 13:47:49 UTC 
Well, nobody could ever test the program to greater extent than the users do :-)
Comment 7 Marcus 2017-05-20 11:18:09 UTC 
Reset assigne to the default "issues@openoffice.apache.org".