[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

--- Comment #5 from John Murrell <Bug2020 at JohnMurrell.org.uk> ---
Thought I would try to get a frozen spreadsheet working again to see if this
gives a clue to what is happening:

1: On a frozen version of the spreadsheet turn off auto calc and then turn it
back on

This results in the named ranges with the calculations all reporting a #NAME?
error

2: Checked the named ranges using Sheet - Named Ranges and Expressions - Manage
one obvious thing is that the name 'period' for cell D1 no longer exists

3: replaced the name in cell D1 as 'period' using Sheet - Named Ranges and
Expressions - Define. Sheet still does not calculate

4: redefined the range 'Phase' using Sheet - Named Ranges and Expressions -
Manage I just selected the 'Phase' range then clicked after the expression in
the 'Range or formula expression' box and then clicked Ok which redefined the
range without any other changes.

This resulted in the spreadsheet starting to work again. So it appears it
freezes as the result of:

a: Loss of the named cell 'period'
b: loss of the definition of the range 'Phase'

Does this help ?

John Murrell

-- 
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/20200228/a907b3c0/attachment.htm>