[Libreoffice-bugs] [Bug 85538] Copying sheet to new document (or somewhere in same document) causes formula error if cells have relative reference to other sheets

[bugzilla-daemon at bugs.documentfoundation.org]

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

Kevin Suo <suokunlong at 126.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Copying sheet to new        |Copying sheet to new
                   |document or before source   |document (or somewhere in
                   |sheet in same document      |same document) causes
                   |causes #REF! error if cells |formula error if cells have
                   |have relative reference to  |relative reference to other
                   |other sheets                |sheets

--- Comment #17 from Kevin Suo <suokunlong at 126.com> ---
(In reply to Timur from comment #15)
#REF! error is just the result, the root cause is the treatment of sheet names
as relative reference.
It really does not matter where the source sheet is copied to: coping to the
beginning, or coping to a new file, they all resulted in the same formula
error, the root cause is because libreoffice is treating the cross reference as
relative reference.

All these duplicates should be either duplicates of bug 85538, or the new
enhancement request I have filed as bug 107257.

-- 
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/20170419/b81a551f/attachment.html>