Issue 69975 - Table in writer counts sum incorrectly
Summary: Table in writer counts sum incorrectly
Status: ACCEPTED
Alias: None
Product: Writer
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.3
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-09-29 12:07 UTC by tuharsky
Modified: 2017-05-20 11:18 UTC (History)
2 users (show)

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


Attachments
Test case. The sum is 10 instead of 21. (7.70 KB, application/vnd.oasis.opendocument.text)
2006-09-29 12:08 UTC, tuharsky
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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".