[Libreoffice-bugs] [Bug 130180] copying sheets, even together, breaks formulas that link between them

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sat Jan 25 19:42:25 UTC 2020


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

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

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

--- Comment #1 from m.a.riosv <miguelangelrv at libreoffice.org> ---
It's simple you must avoid the reference to the sheet being absolute.
With:
=$Sheet1.a1 refers to the original file, what it right it is an absolute
reference.

but instead using
=Sheet1.a1 do as you like, again it does right not carrying the reference the
the original file.

-- 
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/20200125/39746949/attachment.htm>


More information about the Libreoffice-bugs mailing list