[Libreoffice-bugs] [Bug 135679] Unwanted recalculation of RAND() data when using SOLVER, SOLVER does not use given start-values.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=135679

--- Comment #3 from Tomaz Vajngerl <quikee at gmail.com> ---
RAND always returns a new random number when the formula is recalculated and
with the solver you are changing the variables (cells), which forces all the
dependent formulas to recalculate. 

You obviously don't want this behaviour so you can store the random values in
the sheet and reference them as cells and use "Sheet->Fill Cells->Fill Random
Numbers..." in the menu to regenerate the random numbers on demand.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200812/c2eaf001/attachment.htm>