Apache OpenOffice (AOO) Bugzilla – Issue 54049
Basic : String to Currency conversion is incorrect
Last modified: 2017-05-20 11:29:32 UTC
In a document create this macro and run it: Sub bugStr2Curr dim c as currency, t as string t = "200,0000" c = t msgbox(t & " = " & c) End Sub On my 1.9.113 Win XP I get : 200,0000 = 6333188975989.7600 Another user on Linux OOo2Beta2RC gets this : 200,0000 = 0.0001 Other values for t give other strange values. Sometimes even without the comma. Conclusion : the implicit conversion from string to currency is bugged.
I can confirm this behaviour. The interpreter seems to take the values to be a US_en string. This means that other locale representations of currency strings return incorrect results. Setting oooqa keyword. alex
.
reassign to ab
Started
There is an overflow for all values above (2^31 - 1)/10000 which seems to indicate that the problem is linked to a wrong casting of a 32-bit variable into a 64-bit variable.
Reset assigne to the default "issues@openoffice.apache.org".