https://bugs.documentfoundation.org/show_bug.cgi?id=120002
Mike Kaganski <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |NOTABUG
Status|NEEDINFO |RESOLVED
--- Comment #3 from Mike Kaganski <[email protected]> ---
This is not a bug. ISNUMBER() takes a value, which may be, among others, a
scalar or a range. In case of formula in F2 in your sample file, evaluator
passes a value "by intersection" (= in the same row or in the same column; the
latter being used in this case) - so ISNUMBER operates on a single cell F3,
which holds a number; thus the function result is TRUE.
In case of formula in M3, the intersection gives not a single cell, but a range
(the whole A3:L3). The range value is *not* a number, but an array (of
numbers). An array's type isn't a number => rightfully it's FALSE.
--
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
