Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||removing last row from a text table doesn't update formulas|
|Component:||editing||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P3||CC:||issues, lars_o_hansen, pet.ebe|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
Description buzzy 2005-11-22 13:25:12 UTC
assume a table that sums up the contents of three rows in a fourth row. the formula in the the fourth rows are: =sum(<A1:A3>) when I remove one of the first three lines, then the formula is not automatically updated, but a "** Expression is faulty **" is shown in that field. Note that adding a line, e.g. between the second and third, does update the formula, therefore I think is a defect rather than an enhancement or feature.
Comment 1 buzzy 2005-11-22 14:06:56 UTC
Created attachment 31715 [details] test document with table with formulas
Comment 2 buzzy 2005-11-22 14:08:08 UTC
the issue only applies when the last row is removed. When removing the second or third row, then the formulas in the first row gets updated correctly.
Comment 3 lars 2005-11-22 20:32:59 UTC
confirmed on Windows XP SP2 with OOo-dev 2.0.139; open attached file and delete the last row: Expression is faulty; not so when deleting the second row
Comment 4 michael.ruess 2005-12-14 16:17:58 UTC
MRU->OS: delete the last row of the table (in the attached document) and see that the formulas turn to "faulty expression". I think, this old problem should be solved somehow.
Comment 5 chenxiao 2006-01-27 06:35:22 UTC
I also test the attached file on on Windows XP home SP2 with OOo 2.0, but get some different results compared to lars' test: --deleting the last row, then each formula in the first row becomes "** Expression is faulty **". This result is same as lars'; --deleting the second row, then each formula in the first row also becomes "** Expression is faulty **". This result is different from lars'; --I also create another table which is same as the one in the attached file, except that now formulas are in the last row. Then I delete the second row, or fourth row, in both case, each formula in the fifth row becomes "** Expression is faulty **". My tests shows that if the formula is "=sum(<A2:A4>)", then deleting the row containing A2 or A4 would make formula faulty. And deleting the row containing A3 would not make formula faulty. So, do there anybody would like to test it again?
Comment 6 lohmaier 2006-03-19 20:43:26 UTC
*** Issue 63358 has been marked as a duplicate of this issue. ***
Comment 7 michael.ruess 2009-09-09 14:49:23 UTC
*** Issue 104903 has been marked as a duplicate of this issue. ***
Comment 8 niklas.nebel 2010-12-02 10:07:38 UTC
*** Issue 115803 has been marked as a duplicate of this issue. ***