[Libreoffice-bugs] [Bug 137564] EDITING CALC Simple relative references not updated inserting or deleting row(s) directly above

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sat Oct 17 19:30:21 UTC 2020


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

m.a.riosv <miguelangelrv at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |miguelangelrv at libreoffice.o
                   |                            |rg

--- Comment #1 from m.a.riosv <miguelangelrv at libreoffice.org> ---
If you delete the row or column of a reference cell, the reference it's
replaced with !REF# what it's fine the referenced cell doesn't exit anymore.

With functions like SUM the reference it's adapted depending on the status of
Menu/Tools/Options/LibreOffice calc/General - Expand references when new
columns/rows are inserted.

https://help.libreoffice.org/latest/en-US/text/shared/optionen/01060300.html?DbPAR=SHARED#bm_id3151110

There is not a bug.

Please when new issues like this one, can you go first to
https://ask.libreoffice.org/en/questions/

-- 
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/20201017/ffb4fdda/attachment-0001.htm>


More information about the Libreoffice-bugs mailing list