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: libreoffice-bugs@lists.freedesktop.org
          Reporter: rb.hensc...@t-online.de

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.

Reply via email to