To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78165 Issue #|78165 Summary|Rand() Function and Data Tables (Multiple Operations) Component|Spreadsheet Version|OOo 2.2 Platform|Macintosh URL| OS/Version|Mac OS X Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|jpdaley
------- Additional comments from [EMAIL PROTECTED] Thu Jun 7 04:49:01 +0000 2007 ------- I am using version 2.2 on Mac OS X v10.4.9 In the Calc program There appears to be a problem with how the Rand() function works in conjunction with data tables (multiple.operations). If the formula used for the data table involves a random number directly (such as NORMINV(RAND(),10,2)) then the data table will be populated with random numbers. If however, the formula used for the data table is a function of other cells involving random numbers (such as "=(C4+C5)/2" where C4 and C5 are each randomly generated numbers using NORMINV(RAND(),10,2) then the data table will NOT be populated with randomized numbers, but rather only 1 number. The Random function is not acting as a truly volatile function as it should. OpenOffice is only forcing it to be volatile if it is the directly in the cell used for the Formulas Input. It is not volatile if it is in another cell then used as part of the formula used in the Formulas Input cell. Here are the details of how to reproduce the problem. Set cell A1 = RAND() Set cell A2 =RAND() Set cell A3 = A1+A2 Setup a datatable by entering numbers 1 through 5 in cells A6 through A10, highlighting cells A6 through B10 and clicking Data - Multiple Operations. For the Formulas input, select either A2, or A3 (see further discussion below) For the Column input, select any empty cell (say C1). IF I use A2 in my Formulas input above, I get random numbers in my data table (as expected). IF I use A3 in my Formulas input above, I get a single number down the table (not random). This number will be equal to the current value of A3, even though it should be randomized as in the A2 case. This functionality is very important in simulation spreadsheet models where the output is a function of multiple inputs that may have random distributions. This is used for Engineering and Finance models and would be very valuable to fix in OpenOffice. I have also confirmed that this issue exists in the Windows version of OpenOffice. Thanks, Jon --------------------------------------------------------------------- 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]