Thanks for the response Paul.
I downloaded OpenOffice for Windows on my XP machine.
I set cell A1 = NORMINV(RAND();10;2)
I set cell A2 =NORMINV(RAND();10;2)
I set cell A3 = A1+A2
I then 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, I select either A2, or A3 (see further discussion
below)
For the Column input, I select any empty cell (say C1).
IF I used A2 in my Formulas input above, I get random numbers in my data
table (as expected).
IF I used 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. 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.
It appears from this that the Windows and Mac versions have the same
issue.
Check my inputs to see if you get the same response.
Also, how do you report bugs? I couldn't find a direct bug reporting
tool.
Thanks,
Jon
Thank you for the clear instructions. I've replicated the issue. I'm not
entirely sure I understand the 'multiple operations' functionality but if
your sure that this is not how it should be working then use the following
page to lodge a bug :
http://qa.openoffice.org/
/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/
