[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
----------------------------------------------------------------------------
         Resolution|INSUFFICIENTDATA            |---
             Status|RESOLVED                    |UNCONFIRMED
     Ever confirmed|1                           |0

--- Comment #11 from John Murrell <Bug2020 at JohnMurrell.org.uk> ---
I have updated LibreOffice as requested to:

Version: 7.1.1.2 / LibreOffice Community
Build ID: fe0b08f4af1bacafe4c7ecc87ce55bb426164676
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-GB
Flatpak
Calc: threaded

The bug still exists

The attached files shows names added by the solver, some of these refer to the
same cells / ranges as my original named ranges for instance the cell Period is
also referenced as solver_adj, this shows up in the name box when that cell is
selected rather than period.

Some action that I have not been able to determine triggers the removal of most
of the named cell / ranges in the spreadsheet both the solver ones and my named
ranges. The only one that remains is the Chart_Title that is on a different
sheet and contains text rather than a number.

It looks as though the erasure of the names may be triggered by a sequence of
actions but I have not been able to reproduce it consistently.

Any information on when the solver solution / names are removed and what
triggers this ?

-- 
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/20210315/c687192f/attachment.htm>