[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

Roman Kuznetsov <79045_79045 at mail.ru> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |79045_79045 at mail.ru
         Resolution|---                         |NOTABUG

--- Comment #5 from Roman Kuznetsov <79045_79045 at mail.ru> ---
(In reply to gmildner from comment #4)
> Thanks Tomasz for pointing me to the rand number generator. This works well.
> However, I just wanted to check NORMINV() whether this really would generate
> gauss-distributed numbers. Now I copied these numbers to a named cell-range
> and applied the regression analysis to this one. It´s a bit circuitious but
> works well.
> Thanks and please excuse my bad english.

You can update your LibreOffice to 7.0 version and use a new RAND.NV()
function. It's a non-volatile random number generating function that are not
recalculated on every input like RAND()

And I think we can close this as notabug by Comment 3

-- 
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/20200813/88658cc1/attachment.htm>