[Libreoffice-bugs] [Bug 132986] New: Redefined #REF! values recovers the last value and fórmula, however it's never updated anymore EDITING the referenced cell

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=132986

            Bug ID: 132986
           Summary: Redefined #REF! values recovers the last value and
                    fórmula, however it's never updated anymore EDITING
                    the referenced cell
           Product: LibreOffice
           Version: 7.0.0.0.alpha1+ Master
          Hardware: x86 (IA32)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: danijulia at gmail.com

Description:
Deleting a row makes references become #REF! and after reinserting the deleted
row, #REF! cell recovers the last value and fórmula, however it's never updated
anymore.

Steps to Reproduce:
1.In cell A2 put "=A1"
2.Select Row 1 and delete row (A2 will go to A1 and will become "=A#REF!")
3.Select Row 1 and insert row (A2 will become "=A1") however.
4.Insert a value to A1 cell (like "1").


Actual Results:
A2 cell doesn't update it's value to "1", even when it's pointing to A1 that
contains the value "1"

Expected Results:
A2 cell should get value "1"


Reproducible: Always


User Profile Reset: Yes



Additional Info:
I've tried with Version 6.4.2.2 and the new 7.0.0.0.alpha1

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200512/6c528d8a/attachment.htm>