[Libreoffice-bugs] [Bug 135679] Unwanted recalculation of RAND() data when using SOLVER, SOLVER does not use given start-values.
https://bugs.documentfoundation.org/show_bug.cgi?id=135679 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED CC||79045_79...@mail.ru Resolution|--- |NOTABUG --- Comment #5 from Roman Kuznetsov <79045_79...@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.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 135679] Unwanted recalculation of RAND() data when using SOLVER, SOLVER does not use given start-values.
https://bugs.documentfoundation.org/show_bug.cgi?id=135679 --- Comment #4 from gmild...@t-online.de --- 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 are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 135679] Unwanted recalculation of RAND() data when using SOLVER, SOLVER does not use given start-values.
https://bugs.documentfoundation.org/show_bug.cgi?id=135679 --- Comment #3 from Tomaz Vajngerl --- 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 Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 135679] Unwanted recalculation of RAND() data when using SOLVER, SOLVER does not use given start-values.
https://bugs.documentfoundation.org/show_bug.cgi?id=135679 --- Comment #2 from gmild...@t-online.de --- this bug(s) makes CALC-SOLVER unusable for some tasks, so i.m.h.o. it is at least as major bug. Maybe I should reinstall and try MS-Office 2010,..hm... but I really don´t like MS. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 135679] Unwanted recalculation of RAND() data when using SOLVER, SOLVER does not use given start-values.
https://bugs.documentfoundation.org/show_bug.cgi?id=135679 --- Comment #1 from gmild...@t-online.de --- Created attachment 164219 --> https://bugs.documentfoundation.org/attachment.cgi?id=164219&action=edit Gauss distributed RANDom() numbers, SOLVER -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs