Issue 58307 - removing last row from a text table doesn't update formulas
Summary: removing last row from a text table doesn't update formulas
Status: CONFIRMED
Alias: None
Product: Writer
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0
Hardware: PC Linux, all
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
: 63358 104903 115803 (view as issue list)
Depends on:
Blocks:
 
Reported: 2005-11-22 13:25 UTC by buzzy
Modified: 2017-05-20 11:19 UTC (History)
3 users (show)

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

Attachments
test document with table with formulas (6.71 KB, application/vnd.sun.xml.writer)
2005-11-22 14:06 UTC, buzzy 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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. ***
Comment 9 Marcus 2017-05-20 11:19:40 UTC 
Reset assigne to the default "issues@openoffice.apache.org".