To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=31001
------- Additional comments from [EMAIL PROTECTED] Wed Jul 16 19:53:31 +0000 2008 ------- As published in the OOo User forum by lorenzo2 (http://user.services.openoffice.org/en/forum/viewtopic.php?f=45&t=7885&p=37054), the currency type is not properly handled in some basic math operations. There is an overflow after (2^31 - 1) / 10000. How to reproduce the bug ------------------------ 1. Create the following macro in an empty Calc document Sub Main Dim oSheet as object, oCell as object Dim cost as currency, total as currency Dim buy as integer oSheet=ThisComponent.Sheets.getByName("Sheet1") oCell=oSheet.getCellByPosition(0,0) 'A1 buy = oCell.getValue oCell=oSheet.getCellByPosition(1,0) 'B1 cost = oCell.getValue total = buy*cost oCell=oSheet.getCellByPosition(2,0) 'C1 oCell.setValue(total) End Sub 2. Now, if you set A1 to 5 and B1 to 40000 and execute the macro, cell C1 contains 200000, as expected. 3. If you now change B1 to 50000 and execute the macro again, C1 doesn't contain the expected value of 250000 - on my computer, it's now 38,252,449,584,978.1 --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- 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]
