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 [email protected]
In case of problems unsubscribing, write to [email protected]
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
