<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - isNumeric returns false if number is passed as String" href="https://bugs.documentfoundation.org/show_bug.cgi?id=123158#c9">Comment # 9</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - isNumeric returns false if number is passed as String" href="https://bugs.documentfoundation.org/show_bug.cgi?id=123158">bug 123158</a> from <a class="email" href="mailto:leosenko@gmail.com" title="Leos Pohl <leosenko@gmail.com>"> Leos Pohl</a> <pre>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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>