You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2013/10/29 19:04:46 UTC

[Bug 123577] New: EDITING: Wrong update in formulas after inserting new row or column

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: issues@openoffice.apache.org
          Reporter: flaviocolnago@gmail.com
                CC: issues@openoffice.apache.org

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.

[Bug 123577] EDITING: Wrong update in formulas after inserting new row or column

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123577

flallo75 <fl...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #1 from flallo75 <fl...@gmail.com> ---
I've tried with other spreadsheets (googledocs, 123) and the same think
happens... I don't understand the rule...

-- 
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.

[Bug 123577] EDITING: Wrong update in formulas after inserting new row or column

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123577

flallo75 <fl...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |flaviocolnago@gmail.com

-- 
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.