Issue 110678 - circular reference iteration stop before convergence
Summary: circular reference iteration stop before convergence
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOO310m19
Hardware: PC All
: P3 Major (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2010-04-07 21:36 UTC by sauvard
Modified: 2014-02-18 15:53 UTC (History)
3 users (show)

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


Attachments
xls file entered in openoffice calc (19.50 KB, application/vnd.ms-excel)
2010-04-07 21:39 UTC, sauvard
no flags Details
screenshot of spreadsheet immediately after open (326.58 KB, image/png)
2014-02-18 13:29 UTC, Edwin Sharp
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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.