To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102981 Issue #|102981 Summary|Chaining of multiple-operations gives incorrect result |s Component|Spreadsheet Version|OOo 3.1 Platform|PC URL| OS/Version|Windows Vista Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|ui Assigned to|spreadsheet Reported by|bhut_ooto
------- Additional comments from [email protected] Sun Jun 21 12:52:25 +0000 2009 ------- When chaining multiple-operations, one multiple-operation function corrupts the result from another, leaving an incorrect value in the cells. * A1 := 2 ; A2 := 3 ; A3 := 5 * A6 := 7 * B1 := A2*A1 // (expect: 6; actual: 10) * B2 := B1 // (expect: 6; actual: 10) * B3 := MULTIPLE.OPERATIONS(B2; A2; A3) // (expect: 10; actual: 10) * B5 := B2 + B3 // (expect: 16; actual: 20) * B6 := MULTIPLE.OPERATIONS(B5; A1; A6) // (expect: 56; actual: 20) If you replace the equation B3 with its non-MULTIPLE.OPERATION() equivalent: * B3 := A3*A1 then all of the values come out as expected, after you trick Calc to recalculate everything (by hitting enter at each formula which has the wrong value). Testcase is attached. --------------------------------------------------------------------- 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]
