Issue 110678

Summary: circular reference iteration stop before convergence
Product: Calc Reporter: sauvard <michel.sauvard>
Component: programmingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Major    
Priority: P3 CC: awf.aoo, elish, issues
Version: OOO310m19Keywords: regression
Target Milestone: ---   
Hardware: PC   
OS: All   
Issue Type: DEFECT Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---
Attachments:
Description Flags
xls file entered in openoffice calc
none
screenshot of spreadsheet immediately after open none

Description sauvard 2010-04-07 21:36:40 UTC 
In the supplied tst.xml document there are circular references.
The iteration stop before convergence.
It seems that a new value of a cell is not propagated completely until returning
to the cell but stops before.

There is a small chance that this is related to issue 956 but here the calculus
is non linear.
Comment 1 sauvard 2010-04-07 21:39:14 UTC 
Created attachment 68810 [details]
xls file entered in openoffice calc
Comment 2 Edwin Sharp 2013-08-02 08:46:08 UTC 
Cell E1 of attachment in 2.4.3 when opening file shows 3498.48 = converged answer.

Cell E1 of attachment in Rev. 1503704 when opening file shows 332.7626332864. It takes 17 times(!) Ctrl-Shift-F9 to reach 3498.4763682112.
Comment 3 Andre 2014-02-18 09:44:55 UTC 
Why the 'regression' keyword?
Why importance 'major'?
Comment 4 Edwin Sharp 2014-02-18 13:29:15 UTC 
Created attachment 82617 [details]
screenshot of spreadsheet immediately after open

This is why regression.
Comment 5 Edwin Sharp 2014-02-18 13:32:30 UTC 
https://wiki.openoffice.org/wiki/QA/HowToFileIssue  :
"major: The bug cause function doesn't work but there is typically workaround. It includes but is not limited to:

    Basic function doesn't work correctly
    Data lost
    Crash in special circumstances
    Examples: Cannot rename a sheet, document saved without character font setting"

This is why major.
Comment 6 Andre 2014-02-18 15:53:10 UTC 
@Edwin: Thanks for the info.