Issue 68555 - Goal Seek leads to Calc hang-up
Summary: Goal Seek leads to Calc hang-up
Status: ACCEPTED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.3
Hardware: All All
: P3 Trivial with 3 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: crash, oooqa
: 84863 (view as issue list)
Depends on:
Blocks:
 
Reported: 2006-08-12 09:53 UTC by norbert2
Modified: 2017-05-20 11:11 UTC (History)
3 users (show)

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

Attachments
Tilgungsrechnung.ods (21.58 KB, application/vnd.oasis.opendocument.spreadsheet)
2006-08-12 09:54 UTC, norbert2 		no flags Details
goalseek.png (12.79 KB, image/png)
2006-08-12 09:55 UTC, norbert2 		no flags Details
Goal seek test document (14.54 KB, application/vnd.oasis.opendocument.spreadsheet)
2006-08-15 12:09 UTC, jr 		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 norbert2 2006-08-12 09:53:37 UTC 
Hi.


please ...

- open the attached spreadsheet

- start the goal seek with the parameters shown in the attached screenshot:

It seems to never find an end. Calc hangs!

(A friend told me about this bug. He said that Excel handles Goal Seek for
similar spread sheets without problems and finds the values in a short time. But
I haven't tested Excel.)
Comment 1 norbert2 2006-08-12 09:54:39 UTC 
Created attachment 38471 [details]
Tilgungsrechnung.ods
Comment 2 norbert2 2006-08-12 09:55:15 UTC 
Created attachment 38472 [details]
goalseek.png
Comment 3 jr 2006-08-15 12:08:32 UTC 
confirmed with 2.0.3 and m180 on WinXP and Linux

Goal seek works fine up to result cell F108, starting with F109 OOo loops.

Opening the same document in version 1.1.5 the goal seek brings no result, but
OOo doesn't loop.

OOo loops with even easier structured formulas, it seems to me, that the problem
is the number of iterations. I'll attach another test document, where the goal
seek works fine up to result cell C200 and loops from C201.
Comment 4 jr 2006-08-15 12:09:51 UTC 
Created attachment 38530 [details]
Goal seek test document
Comment 5 oc 2006-08-16 12:10:50 UTC 
Hi Eike, please have a look
Comment 6 ooo 2006-08-16 18:15:30 UTC 
Accepted.

I don't see this is a P2, goal seek in combination with deeply nested/stacked
dependencies is not very common => P3.
Comment 7 norbert2 2006-08-16 18:55:37 UTC 
@es:

This is a common used way of calculation. And such bugs are also a reason way
SO/OOo ist not so accepted in business.

P2 is ok because of the crash.
Comment 8 norbert2 2006-08-16 18:57:08 UTC 
typing error: es -> er
Comment 9 norbert2 2006-08-20 16:46:55 UTC 
You can also download such a spreadsheet (XLS) from
http://www.klicktipps.de/download.htm
(Annuitätendarlehen berechnen)

And this way to use the goal seek to calculate the payment per month is very common!

Eike: Ist it possible to have this bug fixed in the next releases?
Comment 10 ooo 2006-09-04 13:49:05 UTC 
Can't promise, otherwise I would had set the 2.1 target.
Comment 11 norbert2 2008-09-06 14:37:47 UTC 
Is issue 84863 a duplicate of this issue?
Comment 12 niklas.nebel 2008-09-08 17:08:55 UTC 
*** Issue 84863 has been marked as a duplicate of this issue. ***
Comment 13 mmacleod 2010-07-05 05:06:51 UTC 
4 years and such a simple show stopping feature has not been fixed?
At the very least could you add a warning so that users don't waste time hoping
that if they "wait a little bit longer" it will eventually work? (This would
probably take 2 seconds to do so hopefully you will consider it - seeing as the
3 minutes it would take to fix such a simple bug properly is obviously just too
much to ask)
Comment 14 Marcus 2017-05-20 11:11:21 UTC 
Reset assigne to the default "issues@openoffice.apache.org".