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

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 142954
           Summary: CALC addressing Enhancement
           Product: LibreOffice
           Version: 6.4.7.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: simon2 at smcalister.me.uk

Description:
This suggestion would make life so much easier for me. I am working with about
10 sheets each with 15-20 columns of time-series data. I am creating some
complex forecasting equations which refer across sheets. Although parameterised
I have to change the structure frequently. They look unintelligible in CALC
notation.

Imagine if you could use named ranges to refer to the columns the equations
would be intelligible again. Well I can do this in the data range using named
ranges as arrays - simple.

However, where results are calculated for forecasting on a row by row basis (as
time increases) I have found arrays are unsuitable and generate weird error
codes for no discernable reason. So back to single cell formulas (arrays are
probably inefficient anyway since they need to be reevaluated for each new
row).

My ideal would be a notation like column_name at row# example: apples at 34 OR
perhaps more generally the @ operator would be the index to a cell within the
named range. Either would be good, but the row/index would need to be
increased/amended as you extend or copy the cell. You can do something similar
with OFFSET( apples, $B34, 0, 1, 1) where column B contains the index you want
to use, but it is clumsy.

Its a simple change but would make a world of difference to power-users in
terms of legibility.

Actual Results:
none - enhancement request

Expected Results:
none - enhancement request


Reproducible: Always


User Profile Reset: No



Additional Info:
none - enhancement request

-- 
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/20210620/393cf6a4/attachment.htm>