To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111808 Issue #|111808 Summary|Multiple Operations calculations Component|Spreadsheet Version|OOO320m9 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|tyleong
------- Additional comments from tyle...@openoffice.org Tue May 25 01:12:11 +0000 2010 ------- Suppose you want to collect the values of the sum of 3 throws of a dice (or an even more complicated problem in financial analysis). I would set up three cells with Randbetween(1,6) and a fourth cell to sum these three cells. Next, I would set up a Multiple Operations (i.e., DataTable in Excel) to collect thousands of replications of that sum. This is done by setting any two blank cells as the row and column input cells. I know we can use relative referencing to set up the table but this approach cannot apply in the actual problem in financial analysis. Using Excel’s DataTable to collect replication results for such Monte-Carlo simulations works fine, but not Calc’s Multiple Operations. Specifically, Multiple Operations will give the same answer for all the replications. Thus, the implication that recalculation is not triggered in the algorithmic steps in Multiple Operations. I can submit example (xls and ods) files but don't know how. --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org