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

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #5 from Simon <simon2 at smcalister.me.uk> ---
(In reply to Simon from comment #4)
> (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.

(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.


Actually though, the mixed addressing in a named range is 75% of a solution

THANK YOU. 

Just need to set up hidden columns of lags (delayed rows) as necessary and name
them - a worthwhile trade-off for the added simplicity in expression. 

It'll be great if I can use the same named ranges in Data and Forecast sections
too - at the moment with absolute addressing in ranges CALC complains about
self referencing (522) because of overlap of named ranges between the two
areas. Hopefully with mixed addressing CALC will default to single cell
referencing, but we will see.

-- 
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/764656be/attachment.htm>