To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=49689
Issue #:|49689
Summary:|Inserting new rows in a spreadsheet with formulas may
|result in un-updated formulas.
Component:|Spreadsheet
Version:|OOo 2.0 Beta
Platform:|PC
URL:|
OS/Version:|Linux
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P3
Subcomponent:|editing
Assigned to:|spreadsheet
Reported by:|pal
------- Additional comments from [EMAIL PROTECTED] Sun May 22 19:18:32 -0700
2005 -------
Suppose you have a spreadsheet with rows of data in columns A thru L. Suppose
column L has a formula, such that, for example, at row 2 column L we have
L2=L1+A1 and so on for each row of column L.
Now insert a new row somewhere in the middle of the spreadsheet. This new row
is, say, row 29. This new row has nothing in it. So copy row 28 into our new
row 29.
Look at column L, row 29 formula. It reads:
L29=L28+A29. That is OK.
Look at column L, row 30 formula. It reads:
L30=L28+A30. That is WRONG!!!!.
Look at column L, row 31 formula. It reads:
L31=L30+A31. That is OK.
So the row after the new row had a term that did not update correctly.
In the attached file, this problem occurs in rows L and J.
I use Linux (OOo 1.9.104), so that's where I found the error. I would assume
the issue will be present in the other OS versions of OOo2.0Beta also.
Pedro
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
