[Libreoffice-bugs] [Bug 142954] CALC addressing Enhancement

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #4 from Simon <simon2 at smcalister.me.uk> ---
(In reply to m.a.riosv from comment #1)
> Do you known about Menu/Tools/Options/LibreOffice calc/Formula/Formula
> syntax - Excel R1C1.
> 
> And maybe named ranges with relative address, not absolute, can help also.


OK never used R1C1
I'm not seeing how that would help. The point is to introduce names for columns
so it is legible.

Named ranges with fixed column and relative row enables me to address the same
row with a named column - halfway there. I also need to refer back a few rows
too - don't see how to do that? 

I am using INDEX( myRange, $B7 ) where column B contains the index for the
range. Still messy though.

-- 
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/20210621/3c3878c5/attachment-0001.htm>