[Libreoffice-bugs] [Bug 145702] Bad cint() behaviour for languages using comma as separator before the decimal point
https://bugs.documentfoundation.org/show_bug.cgi?id=145702
--- Comment #3 from Kai Struck ---
I can confirm a (mysterious) change in behaviour of the cint command in the 7er
versions.
with English local language setting:
In all previous versions (and OpenOffice) something like
cint("1,a") gave 1
cint("1,e") gave 1
cint("1,e2") gave 1
In LO7 all above give 0
In German local setting the "e" is suddenly treated as exponent:
In all previous versions (and OpenOffice) something like
cint("1,a") gave 1
cint("1,e") gave 1
cint("1,e1") gave 1
cint("1,e2") gave 1
In LO7:
cint("1,a") still gives 1
cint("1,e") gives 0
cint("1,e1") gives 10
cint("1,e2") gives 100
I don't know what's going on but report it here. Tested on Windows 10 and
LinuxMint17 and 21.
--
You are receiving this mail because:
You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145702] Bad cint() behaviour for languages using comma as separator before the decimal point
https://bugs.documentfoundation.org/show_bug.cgi?id=145702 Aron Budea changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=97 ||983 CC||aron.bu...@gmail.com -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145702] Bad cint() behaviour for languages using comma as separator before the decimal point
https://bugs.documentfoundation.org/show_bug.cgi?id=145702
Mike Kaganski changed:
What|Removed |Added
Ever confirmed|0 |1
Status|UNCONFIRMED |NEW
--- Comment #2 from Mike Kaganski ---
I can't repro *exactly* using Russian set as program locale: both
> MsgBox CInt("123.4")
and
> MsgBox CInt("123,4")
result in "123" shown in the dialog.
However, this is still a bug.
(In reply to Fritz R. Paul from comment #0)
> But in the example above, I would expect to either accept the point like a
> comma, or at least just ignore the point and the digit after it.
The expectation in the description is wrong: what should happen is error, where
the input string can't be converted to a number.
For comparison, in VBA one of the two calls above gives Run-time error "13":
Type mismatch.
--
You are receiving this mail because:
You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145702] Bad cint() behaviour for languages using comma as separator before the decimal point
https://bugs.documentfoundation.org/show_bug.cgi?id=145702 --- Comment #1 from Fritz R. Paul --- Created attachment 176274 --> https://bugs.documentfoundation.org/attachment.cgi?id=176274=edit The spreadsheet contains a macro function calling cint on the cell two rows left -- You are receiving this mail because: You are the assignee for the bug.
