https://bugs.documentfoundation.org/show_bug.cgi?id=155148
Bug ID: 155148
Summary: CDbl is local dependent but should not
Product: LibreOffice
Version: Inherited From OOo
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: BASIC
Assignee: [email protected]
Reporter: [email protected]
Execute the following macro (Put the macro in any module in your Standard
library, go to a document, press Alt+F11, select the macro and run it.)
sub decimalTest
dim sValue as string
sValue = InputBox("use a decimal point", "CDbl test", "0.5")
dim fValue as double
fValue = CDbl(sValue)
MsgBox("received " & fValue)
end sub
When I enter 0.4 in the input box, I get 4 in the MsgBox.
When I enter 0,4 in the input box, I get 0,4 in the MsgBox.
These are the results when my local setting is "Germany". When I set the local
to "English US" I get 0.4 from 0.4 input as expected.
The help states, that CDbl expects a decimal point, but that is not the case
for me.
https://help.libreoffice.org/latest/de/text/sbasic/shared/03100400.html?DbPAR=BASIC#bm_id3153750
The problem is likely inherited from OOo. I see the local dependency in AOO
too.
--
You are receiving this mail because:
You are the assignee for the bug.
