So I am using Calc to generate random attributes for a roleplaying game I’m in. The problem is, every time I make any change in the document (like changing the alignment in an empty cell), everything re-rolls. Is it possible to create a random number that won’t change unless you do something specific?
Thanks.
-J
Think you are looking for this fron the help file
RAND.NV()
This function produces a non-volatile random number on input. A non-volatile function is
not recalculated at new input events. The function does not recalculate when pressing F9,
except when the cursor is on the cell containing the function. The function is recalculated
when opening the file.
You could also use Sheet > Fill Cells > Fill Random Number which fills selected cells with a random number; no formula but no recalculation either
Oh yes, that works just fine. Thank you!
reepicheep
August 28
Think you are looking for this fron the help file
RAND.NV()
This function produces a non-volatile random number on input. A non-volatile function is
not recalculated at new input events. The function does not recalculate when pressing F9,
except when the cursor is on the cell containing the function. The function is recalculated
when opening the file.