Issue 70430 - Iteration does not complete, Err 523
Summary: Iteration does not complete, Err 523
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.3
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-10-14 19:00 UTC by reuterr
Modified: 2017-05-20 11:11 UTC (History)
1 user (show)

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

Attachments
Iteration does not converge, Err 523 (98.50 KB, application/octet-stream)
2006-10-14 19:02 UTC, reuterr 		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 reuterr 2006-10-14 19:00:17 UTC 
Hello,
I have extracted from a bigger Excel spreadsheet an iterative calulation which
does not run under OpenOffice 2.0.4. (and older) calc. I have attachted the
sample file under the name "AR_Tools_Berechnug_OO.xls". The trick to bring it
under Excel to convergation is in cells A45 and A76 (ISERROR function). In Excel
2000 under Windows XP it is no problem to run. I have tried a lot to find a
workaround, but now I have no more idea what to try in OO. I am not sure if I
have to change the calculation to bring it to run, or if it is an issue of
OpenOffice calc.
Best regards,
Rudy
Comment 1 reuterr 2006-10-14 19:02:25 UTC 
Created attachment 39753 [details]
Iteration does not converge, Err 523
Comment 2 Joost Andrae 2006-10-15 12:43:02 UTC 
please change the value for iteration steps in /tools/options/calc/calculate and
do a 'hard' recalculation of the document via Shift+Ctrl+F9
Comment 3 reuterr 2006-10-15 15:54:06 UTC 
Thank you for the quick response: "please change the value for iteration steps
in /tools/options/calc/calculate and do a 'hard' recalculation of the document
via Shift+Ctrl+F9".
I did so several times and indeed could remove Err 523. But then I got new
Errors 503 (invalid floating point operation) in line 44, which is not
understandable. Also when I change the key cell D19, the same effect happens again.
With best regards, Rudy
Comment 4 frank 2006-10-16 14:08:26 UTC 
Hi Eike,

one for you.

Frank
Comment 5 Martin Hollmichel 2007-11-09 16:51:52 UTC 
change target from 2.x to 3.x according to
http://wiki.services.openoffice.org/wiki/Target_3x
Comment 6 Marcus 2017-05-20 11:11:07 UTC 
Reset assigne to the default "issues@openoffice.apache.org".