Description: ISNUMBER() seems to fail on rows of data in a really unusual way. Steps to Reproduce: 1. Make a row of numbers, say from A2:E2 from 1 to 5 2. In cell B1, put "=ISNUMBER(A2:E2)". This returns TRUE for me. 3. In cell F2, put "=ISNUMBER(A2:E2)". This returns FALSE for me. Actual Results: The row-wise function said false. Expected Results: They should have both said true. Reproducible: Always User Profile Reset: No Additional Info:
Created attachment 145052 [details] Example of bug
5.1.6 is EOL Please give a try to a recent LO version, either 6.0.6 or brand new 6.1.1
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.
Thanks for the clarification, sorry to waste your time.