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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
