To comment on the following update, log in, then open the
issue:
http://www.openoffice.org/issues/show_bug.cgi?id=82728
Issue #|82728
Summary|Iteration count not saved.
Component|Spreadsheet
Version Oo 2.2.1
Platform|PC
URL|
OS/Version|Linux
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|ui
Assigned to|spreadsheet
Reported by|oldetc
------- Additional comments from oldetc openoffice.org Wed Oct 17 19:01:24 +0000 2007
-------
Description of Problem:
I load my spread sheet, which has some cell recursions
(can't be helped).
When I update it I get error 523 which shows in the help
file as:
523
The calculation procedure does not converge
Function missed a targeted value, or iterative references do
not reach the
minimum change within the maximum steps that are set.
Steps to reproduce the problem:
1.load the spread sheet with the recursive cells
2.make any change
3. get error 523
4. turn off iteration in
tools>options>calc>calculate
5. click OK.
6. turn on iteration in tools>opetions>calculate and
set iterations to 2000 or
greater.
7. click OK.
8. error is fixed and calculation is good.
9. remove the change.
10. the error returns.
11. Check iterations and it has reset to 1000 (insufficient
for my needs)
12. go back to step 4.
Actual Results:
error keeps returning, iteration count is reset and
insufficient.
Expected Results:
changing the iteration count should work and save the
desired value. given
todays processors, an iteration count of 32K or 64K would
not be unreasonable.
How often does this happen?
every time.
Additional Information (OS patch level, drivers, library
version, etc.)
OO version 2.2.1
I can provide the spreadsheet to the programmer, but do not
want it posted
(personal information on it.)
------------------------------------------------------------
---------
Please do not reply to this automatically generated
notification from
Issue Tracker. Please log onto the website and enter your
comments.
http://qa.openoffice.org/issue_handling/
project_issues.html#notification
------------------------------------------------------------
---------
To unsubscribe, e-mail: issues-unsubscribe sc.openoffice.org
For additional commands, e-mail: issues-help sc.openoffice.org
|