Issue 59423 - Calculation stops after one change
Summary: Calculation stops after one change
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords: ms_interoperability, oooqa
Depends on:
Blocks:
 
Reported: 2005-12-15 22:58 UTC by merschmann
Modified: 2013-08-07 15:14 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Spreadsheet which does not recalculate (28.32 KB, application/vnd.sun.xml.calc)
2005-12-15 22:59 UTC, merschmann 		no flags Details
Spreadsheet with indirect circular references (colum M) (29.48 KB, application/vnd.sun.xml.calc)
2005-12-16 10:52 UTC, ecastro 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description merschmann 2005-12-15 22:58:41 UTC 
Steps to reproduce:
- Open the attached SXW
- Change one value and see re-calculation
- Change next value and see that nothing happens
Comment 1 merschmann 2005-12-15 22:59:53 UTC 
Created attachment 32468 [details]
Spreadsheet which does not recalculate
Comment 2 ecastro 2005-12-16 10:31:53 UTC 
The issue is reproducible on OOo2.0 series on Windows and Linux.
The offending part is range O4:O24 that contains circular references. Deleting
this range (or the circular reference within that formulas) eliminates the
problem. I have tried to bypass it writing in a non-circular form (see attached
Bio_20051213_issue-2.sxc). However, the formulas emit a "result not converge"
message in the status bar and spreadsheet stops updating. I have observed that
simply going to Tools>Options>calc>Calculate>Iterations and changing  either
setting will immediatly freeze spreadsheet updating. 

OOo 1.1.4 and MS-Excel XP obviate the issue, they simply declare ERROR on that
formulas and the rest of the sheet continue to work properly. I am confirming
this as NEW bug since I think this behaviour is safer than alowing spreadsheet
freezing. This issue is related to #23446, that is quite old (2 years)

On the other hand, I do not understand the purpouse of the calculation.  
Please volkerme, could you explain the rationale of formulae in O4:O24, what
calculation are you interested in? Perhaps can be done in another way.
Comment 3 ecastro 2005-12-16 10:52:39 UTC 
Created attachment 32486 [details]
Spreadsheet with indirect circular references (colum M)
Comment 4 merschmann 2005-12-16 11:01:11 UTC 
The document has been sent to me from the de-users mailinglist.
I have not seen the recursive error, sorry. 
But if I delete only O23 and O24 there is no error displayed and nothing is
calculated.
Comment 5 frank 2006-01-30 15:23:29 UTC 
Hi,

tried it with internal m154 build and does not see a problem.

What values should I change ?

Frank
Comment 6 merschmann 2006-01-30 15:40:47 UTC 
fst: You should change the values in the table E4:I27. It does not work in m153.
Comment 7 frank 2006-01-31 13:51:02 UTC 
Hi Niklas,

please have a look at this one.

Frank
Comment 8 niklas.nebel 2006-05-02 19:48:07 UTC 
The formula in O24 certainly isn't what was intended. Change it (remove the SUM
part), save and reload the file, and everything is fine, you don't need the
"Iteration" setting then.
Nevertheless, the problem exists for files where iteration is used intentionally
and has to be fixed.

nn->er: The formula cell in O4 gets the "bRunning" flag set and never reset again.
Comment 9 ooo 2006-05-03 10:53:11 UTC 
Accepted.
Comment 10 ooo 2006-07-26 21:53:39 UTC 
In CWS calc38:
sc/source/core/data/cell.cxx  1.31.202.1

Now displays proper Err:523 (no convergence) for all cells of the circular
dependency, bRunning state is restored.
Comment 11 ooo 2006-07-27 14:18:30 UTC 
Reassigning to QA.
Comment 12 oc 2006-08-01 13:05:42 UTC 
verified in internal build cws_calc38
Comment 13 oc 2006-08-15 15:38:01 UTC 
closed because fix available in OOo2.0.4 (680m1)