https://issues.apache.org/ooo/show_bug.cgi?id=123577
Bug ID: 123577
Issue Type: DEFECT
Summary: EDITING: Wrong update in formulas after inserting new
row or column
Product: Calc
Version: 4.0.1
Hardware: PC
OS: Windows XP
Status: UNCONFIRMED
Severity: critical
Priority: P3
Component: editing
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Created attachment 81840
--> https://issues.apache.org/ooo/attachment.cgi?id=81840&action=edit
simple example spreadsheet (created with libreoffice)
In row 3, column A I have the following formula:
=b3+b2
If I insert a new row above row 3, the old row 3 is shifted down and becomes
row 4.
Formula in row 4 is now
=b4+b2
instead of
=b4+b3
This happens only in row 4 (the first row shifted), while in the following rows
the formula updates as espected.
If the reference is to the second preceding row the error propagates to the two
following rows.
If the reference is to the third preceding row the error propagates to the
three following rows.
...and so on
Deleting inserted rows restores correct formulas.
The same thing happens with columns.
The same thing happens with libreoffice (I've reported the bug there as well)
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
