2011/6/6 Regina Henschel <[email protected]>:
> 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.
Yes, I know, which is ”123,5” in my case (Swedish standard is a decimal comma).
>
>>
>>
>>
>>
>> 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.
The Help text says nothing about CDbl removing decimals
(CDbl("123,45") → 123 when it should be 123,45, right?.
>
>> Are there other ways to convert from text to a numerical value?
>
> Try Val function.
Ooops, yes, you are right! Seems like my brain just doesn't work
today… Maybe it's because it was a very long time now since I wrote
any macros…
Still, even if I don't need CDbl, it doesn't seem to me to give the
expected results.
>
> 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
>
Kind regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
--
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
