[Libreoffice-bugs] [Bug 114582] Calc stops autorecalc

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed Dec 27 05:53:39 UTC 2017


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

Elmar <roberg at iafrica.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |UNCONFIRMED
     Ever confirmed|1                           |0

--- Comment #5 from Elmar <roberg at iafrica.com> ---
Interesting. I wonder how that happened. Thank you. Did not see that.

== should produce an error - i did not find in the docum any reference to what
such a 

When I tried to remove the double == it kept on putting it back.
So I deleted the contents of cells and copied the columns to a new workbook
The the problem was solved.
Row 144 then gave me error 522, which I cleared by setting Iterations on.
However, I do not understand why that should be, since the simple addition in
row 144 should not have a problem if the formulas in rows 145-149 produce
results (and they are the ones that involve ranges)

Actually, if I think about that. It does make sense - you cannot resolve row
144 until rows 145-149 have been calculated.
However, why does row 143 not give the same error?

Also: the calculation still doe not happen - for example if I add a "C" in row
137, it is increment row 146 by 1. It does not. But in version5.4 it does.

If I then save the v5.4 file and open it in v6.1dev, it seems to work fine -
maybe the DEV file was corrupted at some point?

I then created an empty workbook in v6.1dev and copied the columns from the
working sheet to the new workbook. Seems to work.

So will try it out again over the next few days.

-- 
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/20171227/9ae432b2/attachment.html>


More information about the Libreoffice-bugs mailing list