[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