Issue 116254 - Iteration doesn't converge
Summary: Iteration doesn't converge
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO320m18
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-12-30 06:26 UTC by bagusmahawan
Modified: 2017-05-20 11:35 UTC (History)
2 users (show)

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

Attachments
This is the example. Try to enter A: 50, it will give you F:2.5 instead of the correct answer 2.94 (10.40 KB, text/plain)
2010-12-30 06:30 UTC, bagusmahawan 		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 bagusmahawan 2010-12-30 06:26:38 UTC 
I don't know why but in the following case calc won't iterate properly.
Here's the example:
 A:    50                      ; let's say 50
 B:    = D + E
 C:    = A + F
 D:    = MIN(C4*0.05;2.5)
 E:    = MAX(C4-50;0)*0.15
 F:    = D + E                 ; F is exactly the same as B

The expected result is F (or B)= 2.94. But instead it gives us 2.50 for the
first try. You need to enter A:50 several times in other to have the right
calculation F = 2.94.
If you delete column B, then it works properly.
Comment 1 bagusmahawan 2010-12-30 06:30:56 UTC 
Created attachment 75440 [details]
This is the example. Try to enter A: 50, it will give you F:2.5 instead of the correct answer 2.94
Comment 2 Marcus 2010-12-30 16:58:47 UTC 
can confirm on OOO330m18 (OOo 3.3.0 RC 8) on Solaris Sparc that it's not working
properly

when deleting B4 in the attached file and then re-entering 50 into A4, then the
result in F4 is 2.94
Comment 3 Marcus 2010-12-30 16:59:48 UTC 
@er: can you help here?
Comment 4 Oliver Brinzing 2010-12-31 10:27:53 UTC 
,
Comment 5 Marcus 2017-05-20 11:35:19 UTC 
Reset assigne to the default "issues@openoffice.apache.org".