[Libreoffice-bugs] [Bug 142239] Formula: =ISNUMBER(ADDRESS(ROW(), 6, 4)) is not returning the correct value

[bugzilla-daemon at bugs.documentfoundation.org]

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

Uwe Auer <uwe at franke-auer.de> changed:

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

--- Comment #2 from Uwe Auer <uwe at franke-auer.de> ---
1) Result of "ADDRESS(ROW();6;4)" is a text - Help page
https://help.libreoffice.org/latest/en-US/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3146968
 states: "Returns a cell address (reference) as text"

2) Function ISNUMBER (Step.4) requires a value -
https://help.libreoffice.org/latest/en-US/text/scalc/01/04060104.html?DbPAR=CALC#bm_id3148688

3) If you test text "F11" using "ISNUMBER()" the this correctly is FALSE. Text
"F11" is not a number but text.

4) If you want text "F11" to reference the context of cell "F11" you need to
turn text F11 into a reference using function INDIRECT - Help page
https://help.libreoffice.org/latest/en-US/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3153181
states: "Returns the reference specified by a text string."

5) Finally to achieve you goal, your formula need to read:

=ISNUMBER(INDIRECT(ADDRESS(ROW();6;4))) (which yields TRUE)

Not a bug.

-- 
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/20210512/6c8eea12/attachment.htm>