https://bugs.documentfoundation.org/show_bug.cgi?id=142953
Wolfgang Jäger <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #13 from Wolfgang Jäger <[email protected]> --- The result would be exactly the same if in place of the defined range name the explicit designator ($Sheet1.$A$3:$A$19 in the example) it stands for is used in the OFFSET() expression. That's because the expression is correctly evaluated in intersection mode. See subchapter 6.3.3 "Implied intersection" of "Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula" To get what the bug reporter expected (hoped for) =OFFSET(myRange; 1; 0; 1; 1) entered for array evaluation would help. [INDEX() may also help to get a workaround. I think INDEX() is not eligible for intersection mode(?).] Suggest change to NOTABUG. -- You are receiving this mail because: You are the assignee for the bug.
