[Libreoffice-bugs] [Bug 127633] Relative Cells

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Tue Sep 24 22:05:32 UTC 2019


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

--- Comment #8 from m.a.riosv <miguelangelrv at libreoffice.org> ---
If I'm not wrong table functionalities works in Calc, but you need to save the
file in xlsx format.
https://wiki.documentfoundation.org/ReleaseNotes/5.1#Table_structured_references

Similar, in some way, to table functionalities is the use of Labels in ODF,
(Menu/Sheet/Named ranges/Labels)

Also there is the option to use ExcelR1C1 formula syntax.
Something like <L1U1> (left 1 up 1) = =R[-1]C[-1]

-- 
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/20190924/dbe90e28/attachment-0001.html>


More information about the Libreoffice-bugs mailing list