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

          Priority: medium
            Bug ID: 70815
          Assignee: [email protected]
           Summary: EDITING: cell is not updated when referenced cell
                    becomes empty due to sort
          Severity: major
    Classification: Unclassified
                OS: All
          Reporter: [email protected]
          Hardware: All
            Status: UNCONFIRMED
           Version: 4.1.2.3 release
         Component: Spreadsheet
           Product: LibreOffice

Steps to reproduce:

enter 1 into cell A2
enter =A2 into cell B2 (will show 1)
mark A1:A2
sort (A1 will be 1 and A2 will be empty afterwards)

Current behavior: Formula in B2 still is =A2, but shown result still is 1

Expected behavior: Formula in B2 still is =A2, and result is 0

F9 does not help.

Shift+Ctrl+F9 does fix the error.

The underlying problem is probably similar to Bug
https://www.libreoffice.org/bugzilla/show_bug.cgi?id=55059

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