[Libreoffice-bugs] [Bug 130961] New: 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

            Bug ID: 130961
           Summary: LibreOffice Calc - Calculations frozen after solver
                    and lost named ranges
           Product: LibreOffice
           Version: unspecified
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: Bug2020 at JohnMurrell.org.uk

Description:
using Calc Solver - SCO Evolutionary Algorithm.
Allow to solve then save the solution when the ''Solving successfully finished'
pop-up appears using the 'Keep Result' button
Then save the spreadsheet.
The calculations in the spreadsheet involved in the Solver now freeze.
If you try to run the solver again the input cell changes but nothing happens
and the solver stops immediately on 'Stagnation'
If you change the number in the input cell manually nothing happens even after
a manual recalc.

If you turn off automatic recalculation and then do a manual calculation the
calculations that involve named ranges all fail with a NAME? error. However the
names are still defined when you check.

There does not appear to be any way to recover from this other than reload a
backup copy of the spreadsheet before the solver was used. 

This may also apply to other versions of the solver ?

This failure can be confusing as it is easy to think it has found another
solution with the same result rather than the entire sheet having frozen.

Calculations that are not involved in the solver still seem to work for
instance I have a cell that shows the current value of the input cell in
another part of the spreadsheet so I can see the input and the result - this
still works even though all the other calculations have frozen.

If the developers want a copy of the (working) or frozen spreadsheet please
email me and I will PM it to them.

Could not find any similar bugs reported or in internet search. 

Steps to Reproduce:
1.As above
2.
3.

Actual Results:
Spreadsheet calculations freeze
Named Ranges Lost

Expected Results:
Calculations should still work so alternative solutions or solvers can be tried
Named ranges should still work correctly.


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
The spreadsheet should still have working calculations so the solver can be run
again.

The named ranges should not be lost when switching to manual calculation - I
assume this bug is related but could be separate ?

-- 
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/20200226/f54a72bc/attachment.htm>