[Libreoffice-bugs] [Bug 123158] isNumeric returns false if number is passed as String

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #8 from Leos Pohl <leosenko at gmail.com> ---
To complement my full results:
Version: 6.1.5.2
Build ID: 90f8dcf33c87b3705e78202e3df5142b201bd805
CPU threads: 8; OS: Mac OS X 10.14.3; UI render: default; 
Locale: cs-CZ (cs_CZ.UTF-8); Calc: group threaded
(locale decimal separator is ",")

IsNumeric(1,2) = True
IsNumeric(1.2) = True
IsNumeric("1.2") = False
IsNumeric("1,2") = True

So maybe if the input is a String, it does depend on the Locale but regardless
of the input type, it needs to provide consistent results which it does not.
Whether it is correct to take into account the locale or not is a good question
because, if a the table has numbers stored as text (e.g. '1.2) then when such a
workbook is transported onto a system with such locale that the decimal
separator is "," these numbers are not automatically transformed to have the
correct decimal separator but it is still a number (at least it was supposed as
such on the other system), regardless of the fact that it is stored as text and
since the point of isNumeric is to determine whether a Variant type (i.e. even
a string) is a correct number, from this point of view both isNumber should be
insensitive to the locale.

-- 
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/20190222/fdb27c4d/attachment.html>