The "issue" is visible / replicate-able on my computer.
Your problem is your input parameter, you have: =ISNUMBER(A1:C1)
A1:C1 references a RANGE, but the ISNUMBER function expects a VALUE, or
a single cell reference.
If I enter =A1:C1 in any cell in columns A-C it shows TRUE, but by
clearing the cell formatting I can see that the actual return value is
the column index (A=1).
If I enter =A1:C1 in any cell beyond column C it returns #VALUE!
Apparently ISNUMBER translates this to FALSE, rather then propagating
the error value.
I don't understand why it's doing this, what this particular formula is
actually supposed to do.
To fix you will need to reference a single cell, like this: =ISNUMBER(A1)
You can use AND to link a number of them together, I suspect this will
get the result you want:
=AND(ISNUMBER(A1), ISNUMBER(B1), ISNUMBER(C1))
On 6/10/25 16:29, quickinbox99...@yahoo.com wrote:
I am not familiar with mailing lists, so hopefully this message associates with the correct thread.
I have uploaded an example document at https://filebin.net/uduv0iqejt3y94y5 which hopefully helps
demonstrate the issue I am having. I have included a screenshot from my machine in the event that
the issue only occurs for me. All cells with "TRUE" and "FALSE" have the same
formula in them.
-A
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
