https://bugs.documentfoundation.org/show_bug.cgi?id=130961
John Murrell <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
--- Comment #2 from John Murrell <[email protected]> ---
Created attachment 158229
--> https://bugs.documentfoundation.org/attachment.cgi?id=158229&action=edit
Spreadsheet that freezes after Solver Run
As supplied changing the value of Cell D1 causes the sheet to recalculate and
the result in J131 to change, the graph also changes but that is not material.
To reproduce fault
Set up the solver to minimise J131 (Result)
By varying Cell D1 (Period)
Constraint Period < 1000 (otherwise it will find a minimum at max value
possible)
Use option in solver to select SCO Evolutionary Algorithm
Tick select non-negative variables
Run solver
When it solves that may take some time save the result and then save the file.
The values should have frozen. If you change D1(Period) manually The result in
J131 does not change however the value in L130 that just shows the period in a
more convenient place still changes.
If you try to run the solver again it stops (almost ?) immediately due to
stagnation - I presume this is due to the calculations not working however the
value shown in the period cell will be updated.
Carrying out a manual recalculation (with a different value in period) has no
effect.
If you turn off automatic recalculation and then turn it on again all the
calculations fail with errors in the named ranges even though they are still
defined.
--
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
