https://bugs.documentfoundation.org/show_bug.cgi?id=142953
--- Comment #2 from Uwe Auer <[email protected]> ---
(In reply to Simon from comment #0)
> 1.create named range of multiple cells say myRange
> 2.create cell =OFFSET( myRange, 1, 0)
This doesn't work at all and gives a "#VALUE!" (wrong data type) error. This
needs to be an array formula "{=OFFSET( myRange;1;0)}" to work, if myRange is a
multicell range.
--
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