[libreoffice-users] ISNUMBER help

2025-06-09 Thread quickinbox99...@yahoo.com
ISNUMBER seems to give different output given the same input. The output of this function seems to be different based on the cell the formula is in. I have attached a minimal example document. I would prefer to ask for help on  https://ask.libreoffice.org/, however, after creating an account ther

Re: [libreoffice-users] ISNUMBER help

2025-06-10 Thread quickinbox99...@yahoo.com
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

Re: [libreoffice-users] ISNUMBER help

2025-06-10 Thread quickinbox99...@yahoo.com
> 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). This helps me see what is happening. The range is actually being resolved to the value of the cell in the same column as the form