[Libreoffice-ux-advise] [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 on the CC list for the bug.
More information about the Libreoffice-ux-advise
mailing list