[Libreoffice-bugs] [Bug 131065] New: After removing few lines in XLSX, some formula became #REF, though formula did not referenced into deleted lines

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 131065
           Summary: After removing few lines in XLSX, some formula became
                    #REF, though formula did not referenced into deleted
                    lines
           Product: LibreOffice
           Version: 6.4.0.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: opensuse.lietuviu.kalba at gmail.com

Created attachment 158302
  --> https://bugs.documentfoundation.org/attachment.cgi?id=158302&action=edit
XLSX document for testing: after removing 9-40 lines, H9 cell will be REF

After removing few lines in XLSX created in Microsoft Excel, some formula
became #REF.

How to reproduce:
1. Open attached document
2. Remove 9-40 lines

Result:
 H9 cell contains formula =+#REF!*#REF!

Expected:
 H9 cell contains formula =+G9*F9

Note, that before removing lines, this cell was H41 and it contained formula
=+G41*F41
Thus formula did not referred into removed cell.
Besides, after removing lines, doing Undo and Redo fixed formula.

I have LibreOffice 6.4.0.3 in openSUSE Linux, LibreOffice installed from RPMs
from LibreOffice site.

Versija: 6.4.0.3
Darinio identifikatorius: b0a288ab3d2d4774cb44b62f04d5d28733ac6df8
Procesoriaus gijos: 4; OS:Linux 4.12; Sąsajos pateikimas: numatytasis; VCL:
kf5; 
Lokalė: lt-LT (lt_LT.UTF-8); Sąsajos kalba: lt-LT
Calc: threaded

-- 
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/20200302/694088fb/attachment.htm>