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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
