Apache OpenOffice (AOO) Bugzilla – Issue 69975
Table in writer counts sum incorrectly
Last modified: 2017-05-20 11:18:09 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.
Created attachment 39452 [details] Test case. The sum is 10 instead of 21.
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.
it works for the 2nd column
move target to 3.x according http://wiki.services.openoffice.org/wiki/Target_3x
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.
Well, nobody could ever test the program to greater extent than the users do :-)
Reset assigne to the default "issues@openoffice.apache.org".