I tested your piece of code for OOo 1.1.2 - locale setting "german" - on Fedora Core 3 and it didn't print 0 but the correct value "0,3".
Best Regards Christian Junker
Sevastian `seva` Foglia wrote:
With your code and your cell content I get a runtime error from CDbl : "Incompatible data types". This is normal because the string does not represent a number. You should remove the apostrophe.
If you don't get a runtime error then you have somewhere an instruction On Error Resume Next. Of course the result of CDbl is undefined in case of error.
Bernard
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Try this code
Sub Main Dim sVal as String sVal = "0,30" print CDbl(sVal) End Sub
On my iBook with NeoOffice 1.1 I get 0,3 On a PC with Window XP professional and OOo 1.1.3 I get 0,3 On my PC with Debian and OOo 1.1.4 I get 0
Why???
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]