https://bugs.documentfoundation.org/show_bug.cgi?id=135679
--- Comment #3 from Tomaz Vajngerl <[email protected]> ---
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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
