https://bugs.freedesktop.org/show_bug.cgi?id=67989

          Priority: medium
            Bug ID: 67989
          Assignee: [email protected]
           Summary: EDITING: Cell reference not working any more when
                    columns added
          Severity: normal
    Classification: Unclassified
                OS: All
          Reporter: [email protected]
          Hardware: Other
        Whiteboard: BSA
            Status: UNCONFIRMED
           Version: 4.1.0.4 release
         Component: Spreadsheet
           Product: LibreOffice

With LO 4.10 create a new sheet and enter a value wathsoever in a cell, let’s
say in D5 enter “ok”

enter in anoter cell e.g. G5 the formula “=D5”

Now in cell G5 same value of D5 is displayed, i.e. “ok”.

Now add a column between columns A and D, for example add a column between
existing columns B and C. Former cell D5 is now E5 (still with value “NO”) and
former cell G5 is now H5, still with formula “=E5” and display “NO” 

Change the value of cell E5, enetring for example “Yes”, formula in H5 is still
“=E5”, but display has not been recalculated, and is still “NO”.

Current behavior:

Value displayed in cell H5 remains "NO" (the previous value of cell E5

Expected behavior:

The new value "YES" should be displayed.

It happens in windows XP, Seven, Linux Debian (Sid) and PCLinux OS. LO release
4.0.4.2 was not affected (at least in Debian Sid)

Operating System: All
Version: 4.1.0.4 release

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to