[Libreoffice-bugs] [Bug 88979] EDITING. The sheet portion of label ref are always absolute. Relative sheet ref not supported.

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |erack at redhat.com
           Hardware|x86 (IA32)                  |All
            Version|4.2.8.2 release             |Inherited From OOo

--- Comment #10 from Eike Rathke <erack at redhat.com> ---
Labels with relative sheet references don't make much sense. As soon as rows or
columns are deleted in a sheet where an affected label range is used in a
formula on another sheet that formula is out of sync. Similar for insertions.
What might be possible instead could be to copy labels when a sheet is copied,
along with adapting all formulas on the copied sheet that use such a copied
label range.

Btw, "Automatically find column and row labels" should be used with care and
generally is not advisable.

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