To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78165
------- Additional comments from [EMAIL PROTECTED] Thu Jun 7 14:13:00 +0000 2007 ------- This may very well be the same root problem as described in Issue 67135 but I am not possitive. They both appear to be related to the volatility of the Rand() function. It is not behaving as truely volatile. As far as design, I can only say that Excel works the way I describe as "expected" and this feature is used extensively in financial and engineering modeling involving uncertain inputs. If I have several variables all that have some random distribution, and I have an output that is a function of those inputs, I want to be able to simulate what the distribution of those outputs would be. You do this by creating a data table of the output. You can then measure the statistics on the output data table. If the Rand() function is not working as expected however, and you only get one value in the data table, you cannot determine what distribution the output will have. I will attach a financial spreadsheet created in Excel that does what I am describing. Although I know we may not be trying to copy excel directly in OpenOffice, I think that the way Excel functions on this point is more valuable. --------------------------------------------------------------------- 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]
