Bug 114582

Summary:	Calc stops autorecalc
Product:	LibreOffice	Reporter:	Elmar <roberg>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	normal	CC:	ilmari.lauhakangas, raal
Priority:	medium
Version:	5.4.3.2 release
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	File where reclac no longer works file before recalc stopped working formula

Description Elmar 2017-12-20 09:45:56 UTC

Description:
Working in a calc document. Auto recalc stops working.
v6.1 dev
and 
v5.4.3.2

Steps to Reproduce:
1. work on spreadsheet
2. change field contents
3. recalc stops working

Actual Results:  
see rows 143-156
around col x 

Expected Results:
to count correctly


Reproducible: Always


User Profile Reset: No



Additional Info:
have included before and after docs.


User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:57.0) Gecko/20100101 Firefox/57.0

Comment 1 Elmar 2017-12-20 10:09:22 UTC

Created attachment 138546 [details]
File where reclac no longer works

Comment 2 Elmar 2017-12-20 10:13:37 UTC

Created attachment 138547 [details]
file before recalc stopped working

Comment 3 raal 2017-12-23 09:08:01 UTC

Created attachment 138607 [details]
formula

Hi,
see W145 - W149 : in the formula is "=" twice.

Comment 4 Buovjaga 2017-12-26 17:46:52 UTC

(In reply to raal from comment #3)
> Created attachment 138607 [details]
> formula
> 
> Hi,
> see W145 - W149 : in the formula is "=" twice.

Elmar: what do you think?

Comment 5 Elmar 2017-12-27 05:53:39 UTC

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.

Comment 6 Buovjaga 2018-01-07 15:09:14 UTC

(In reply to Elmar from comment #5)
> So will try it out again over the next few days.

Are you happy to close this?

Comment 7 Elmar 2018-01-17 11:31:34 UTC

(In reply to Buovjaga from comment #6)
> (In reply to Elmar from comment #5)
> > So will try it out again over the next few days.
> 
> Are you happy to close this?

Yes, I do not have the problem anymore