[libreoffice-users] Re: [libreoffice-users] LibreOffice/OpenOffice.org BASIC – CDbl doesn't work properly with string argument

Hi Johnny,

Johnny Rosenberg schrieb:
> CDbl returns an integer when the argument is a text string.
>
> LibreOffice 3.4.0
> OOO340m1 (Build:12)
>
> OpenOffice.org 3.2.1
> OOO320m19 (Build:9505)
> ooo-build 3.2.1.4, Ubuntu package 1:3.2.1-7ubuntu1.1
>
> Ubuntu 10.10
>
>
> REM  *****  BASIC  *****
>
> Option Explicit
>
> Sub Main
>         Print CDbl("123.45")
> ' This gives an error message since my locale is Swedish (Sweden) →
> decimal separator=comma.
> End Sub

Help: the number must be entered as normal text ("123.5") using the 
default number format of your operating system.

> REM  *****  BASIC  *****
>
> Option Explicit
>
> Sub Main
>         Print CDbl("123,45")
> ' Prints 123, the decimals are gone.
> End Sub
>
>
> Is this a bug?

No, see help text.

> Are there other ways to convert from text to a numerical value?

Try Val function.

Kind regards
Regina

--
Unsubscribe instructions: E-mail to users+help@libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted