2011/7/3 Andrew Douglas Pitonyak <andrew@pitonyak.org>
StarBasic converts a string representations of a number in a locale
specific way. In other words, in the USA, I expect "12.5" to round to an
integer as 13. In Germany, I expect "12,5" to round to 13. I have a report
of this NOT working on Linux in Germany. I am interested in the results from
a few different languages, locales, and operating systems. Note that this
works for me with the latest OOo release and the latest LO release candidate
3 on 64-bit Fedora on en-US.
Dim l As Long
Dim d As Double
l = CLng("12.5") : Print l ' Expect 13 in en-US
l = CLng("12,5") : Print l
d = cdbl("12.5") : Print d
d = cdbl("12,5") : Print d
Based on responses, I will open a bug report
Running the test with Danish (da) locale confirms. The result is 12, 12, 125
and 12. We use ccomma (",") as decimal separator as in German locale.
I'm using Linux with LibreOffice 3.4.1 (OOO340m1 (Build:101)).
I hope this can help.
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.