Issue 44115 - Error in Iterations
Summary: Error in Iterations
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0 Beta
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-03-04 21:12 UTC by lpiccilli
Modified: 2013-08-07 15:15 UTC (History)
1 user (show)

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

Attachments
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 lpiccilli 2005-03-04 21:12:34 UTC 
It´s dificult to describe the bug:

fill the cells in this order (with iterations activated in options) 

B1  100
B2  100
B6  =sum(b1:b5)
A3  5
A4  10
A5  20
B3  =b6*a3/100 (all right here)
B4  =b6*a4/100 (strange, no modification in b6)
B5  =b6*a5/100 (strange again, this not works!!)

If I del and fill again b6 aparently works, but this is not the correct 
behavior.
Comment 1 lpiccilli 2005-03-11 16:29:19 UTC 
This is related to issue 956 ??
Comment 2 frank 2005-03-14 08:45:05 UTC 
Hi Eike,

please have a look at this one.

Frank
Comment 3 ooo 2005-03-14 15:57:29 UTC 
Not related to issue 956 anymore, since that covered more than one problem of
which now only one remains, added comment there and adjusted summary. Note that
the behavior of iterations changed with SRC680_m85 where CWS "calcer" was
integrated. However, there are still cases like this one here where calculations
converge too early and only give a non-changing result after additional hard
recalcs using Shift-Ctrl-F9.

On branch cws_src680_dr34:
sc/source/core/data/cell.cxx 1.28.2.1
Comment 4 ooo 2005-03-21 10:56:06 UTC 
Reassigning to QA.

re-open issue and reassign to oc@openoffice.org
Comment 5 ooo 2005-03-21 10:56:12 UTC 
reassign to oc@openoffice.org
Comment 6 ooo 2005-03-21 10:56:17 UTC 
reset resolution to FIXED
Comment 7 oc 2005-03-23 12:18:55 UTC 
verified in internal build cws_dr34
Comment 8 lpiccilli 2005-03-28 19:06:11 UTC 
Ok. Now aparently works, but if I do the same thing in other programs, the sum 
is equal to 307.69 and not 297.45.

Changing the value of cell a3 to 500 the other cells give me a error 503 (Ok). 
If I change back a3 to 5 and fill again the other cells, sometimes the sum in b6 
 does not work anymore.

I hope that you can understand.
Sorry for my bad english.
Comment 9 oc 2005-03-29 09:40:22 UTC 
PLEASE: An issue which is set to fixed/verified in an internal version could NOT
be verified in an available OOo version (because of the workflow). Therfore
please wait untill the issue is closed to check the fix.
Reset resolution to fixed
Comment 10 oc 2005-03-29 09:40:56 UTC 
reset status verified (internal)
Comment 11 oc 2005-04-06 14:53:45 UTC 
closed because fix available in OOo1.9m91