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.
Example,
A1 formula is "=NORMINV(RAND();10;2)"
A2 formula is "=NORMINV(RAND();10;2)"
A3 formula is "=A1+A2"
If I create a data table of 5 rows using the Multiple Operations and
select A1 as my Formula and any blank cell for column input cell,
then I get 5 rows of random numbers (different in each row).
If I create a data table of 5 rows using the Multiple Operations and
select A3 as my Formula and any blank cell for column input cell,
then I get 5 rows of identical numbers (no randomization).
The program should recalculate the entire sheet (including formulas
of random numbers) for each row of a data table. This is highly
important for performing simulations of outputs that are the
functions of multiple randomized inputs.
I'm using OOo2.2 on Vista and I cannot replicate your results. When I
construct a table using random numbers they change each time something in
the worksheet changes.
When the rand() function is used within another function the result is the
same as above (ie, they change when something changes in the spreadsheet).
I would suggest that since you can replicate this issue, you lodge a bug and
make sure you note that it seems to be MAC specific.
/paul
--
Processing Key for cracking HD DVD's:
09 F9 11 02 9D 74 E3 5B D8 41 56 C5 63 56 88 C0
-----
Try Torpark; a small portable, open-source, built on Firefox browser that
enables anonymous browsing. Requires no installation :
http://www.torrify.com/
