[Libreoffice-bugs] [Bug 128110] #REF! error in running total formula after delete of row

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #5 from Eike Rathke <erack at redhat.com> ---
Normal spreadsheet behaviour, not a bug. If cells/rows/columns are deleted that
entirely encompass a reference that reference is invalidated.
If you want "floating" (or whatever one might call that) references then use a
named expression, e.g. on cell B2 define name RELREF to B1+A2 and use =RELREF
as formula in B2 and copy down.

-- 
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/20191014/96816836/attachment.html>