[Libreoffice-bugs] [Bug 142953] New: CALC OFFSET error when used with named range of multiple cells for the reference arg and defaults

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 142953
           Summary: CALC OFFSET error when used with named range of
                    multiple cells for the reference arg and defaults
           Product: LibreOffice
           Version: 6.4.7.2 release
          Hardware: x86 (IA32)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: simon2 at smcalister.me.uk

Description:
Linux LibreOffice v6.4.7.2 OFFSET has an error when the 1st arg is a named
range that refers to a column not a single cell.

If all args are fully specified it works as expected using the first cell
referenced in the named range.

If however the length and width of the returned array are not specified (which
default to 1,1), then it does not matter what is input for the row arg, the
result is always the same cell value.

Obviously, the workaround is to specify all args, but unintended errors can
occur if you don't know, so could this be flagged for future fix please.

Thank you from longtime grateful user of LO CALC

Steps to Reproduce:
1.create named range of multiple cells say myRange
2.create cell  =OFFSET( myRange, 1, 0)
3.vary row arg to see the same value
4. now amend OFFSET to add defaults explicitly 1,1 - do same vary row

Actual Results:
see above

Expected Results:
see above


Reproducible: Always


User Profile Reset: No



Additional Info:
see above

-- 
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/1cd96b15/attachment.htm>