[Libreoffice-bugs] [Bug 120002] If you use the ISNUMBER() function above a row of data, you get different results to using it next to a row of data

[bugzilla-daemon at bugs.documentfoundation.org]

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

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
             Status|NEEDINFO                    |RESOLVED

--- Comment #3 from Mike Kaganski <mikekaganski at hotmail.com> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180920/81ee0df4/attachment.html>