[Libreoffice-bugs] [Bug 142239] New: 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

            Bug ID: 142239
           Summary: Formula:  =ISNUMBER(ADDRESS(ROW(),6,4)) is not
                    returning the correct value
           Product: LibreOffice
           Version: 7.1.1.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: protoxavier at yahoo.com

Description:
The formula:  =ISNUMBER(ADDRESS(ROW(),6,4)) is returning a value of FALSE when
it should be evaluating to a value of TRUE.

Steps to Reproduce:
1.Put 1234 in cell F11
2.Put the formula:  =ADDRESS(ROW(),6,4) in cell R11 
3.Put the formula:  =ISNUMBER(F11) in cell S12
4.Put the formula:  =ISNUMBER(ADDRESS(ROW(),6,4)) in cell S11

Actual Results:
Cell R11 has a value of:  F11, which is correct.
Cell S12 has a value of:  TRUE, which is correct.
But cell S11 has a value of:  FALSE, which is wrong.  It should have a value of
TRUE.

Expected Results:
Cell S11 should have a value of TRUE, not FALSE.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Version: 7.1.2.2 (x64) / LibreOffice Community
Build ID: 8a45595d069ef5570103caea1b71cc9d82b2aae4
CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

I need the formula:  =ISNUMBER(ADDRESS(ROW(),6,4)) to work correctly.  It is
vital to conditional formatting that I am doing.

-- 
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/f98ed824/attachment.htm>