[Libreoffice-bugs] [Bug 130961] LibreOffice Calc - Calculations frozen after solver and lost named ranges

[bugzilla-daemon at bugs.documentfoundation.org]

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

John Murrell <Bug2020 at JohnMurrell.org.uk> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |Bug2020 at JohnMurrell.org.uk

--- Comment #2 from John Murrell <Bug2020 at JohnMurrell.org.uk> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200227/46da5b19/attachment.htm>