Issue 76163 - Goal seek does not work with fact() or fakultät()
Summary: Goal seek does not work with fact() or fakultät()
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.4
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-04-06 23:57 UTC by gleppert
Modified: 2017-05-20 11:13 UTC (History)
2 users (show)

See Also:
Issue Type: ENHANCEMENT
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 gleppert 2007-04-06 23:57:03 UTC 
Trying a goal seek on the factorial function fakultät(a1) does not calculate any
useful value.

I tried to calculate the value for the goal 1.000.000 and the variable cell a1,
but goal seek displayed that it was unsuccessful. The proposed approximate value
was 1, which is wrong.

I tried the same goal seek with the factorial function in Excel 2003 and it worked.
Comment 1 kpalagin 2007-04-09 13:01:14 UTC 
Confirming with 2.2 on WinXP - as described.
Comment 2 frank 2007-04-10 15:27:39 UTC 
Hi Eike,

one for you.

Frank
Comment 3 Marcus 2017-05-20 11:13:11 UTC 
Reset assigne to the default "issues@openoffice.apache.org".