Apache OpenOffice (AOO) Bugzilla – Issue 110678
circular reference iteration stop before convergence
Last modified: 2014-02-18 15:53:10 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.
Created attachment 68810 [details] xls file entered in openoffice calc
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.
Why the 'regression' keyword? Why importance 'major'?
Created attachment 82617 [details] screenshot of spreadsheet immediately after open This is why regression.
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.
@Edwin: Thanks for the info.