https://bugs.freedesktop.org/show_bug.cgi?id=59108
Priority: medium
Bug ID: 59108
Assignee: [email protected]
Summary: no formula update when deleteing referenced row/column
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 3.6.4.3 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 72642
--> https://bugs.freedesktop.org/attachment.cgi?id=72642&action=edit
referencing deleted row/column
I have cells referencing a previous row/column.
When I delete that referenced row/column then the formula shows "#REF!".
I expect it to reference the new row/column which is now its previous one.
I have attached a simple test file. Either delete row 2 or delete column B.
When deleting row 2, I expect D3 (which will then be D2) to show the content of
C1.
When deleting column B, I expect D1 (which will then be C1) to show the content
of the new B1 (which was C1).
Using an absolut reference ($B$1) does not work.
--
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
