Bug 154284 - IsNumeric(" ") returns True
Summary: IsNumeric(" ") returns True
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
Version:
(earliest affected)
6.1 all versions
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Macro
  Show dependency tree / graph
 
Reported: 2023-03-20 11:44 UTC by Xisco Faulí
Modified: 2024-01-24 17:58 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Xisco Faulí 2023-03-20 11:44:10 UTC 
This issue is based on https://bugs.documentfoundation.org/show_bug.cgi?id=123158#c16

run

Sub test
msgbox isNumeric(" ")
End Sub

it returns True while it should return False

Reproduced in


Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: c1af1b9c555480305862336954ceefe14865e27d
CPU threads: 8; OS: Linux 5.10; UI render: default; VCL: gtk3
Locale: es-ES (es_ES.UTF-8); UI: en-US
Calc: threaded

and

Version: 6.0.0.0.alpha1+
Build ID: 6eeac3539ea4cac32d126c5e24141f262eb5a4d9
CPU threads: 8; OS: Linux 5.10; UI render: default; VCL: gtk3; 
Locale: es-ES (es_ES.UTF-8); Calc: group threaded
Comment 1 Rafael Lima 2024-01-24 17:58:44 UTC 
FTR in MSO the same macro would return "False", so indeed this is a bug.

In LO:
isNumeric(" ") -> True (Wrong)
isNumeric("") -> False (OK)

I'd say the problem is in  ImpScan (sbxscan.cxx), but I have to give it a closer look.