Apache OpenOffice (AOO) Bugzilla – Issue 76163
Goal seek does not work with fact() or fakultät()
Last modified: 2017-05-20 11:13:11 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.
Confirming with 2.2 on WinXP - as described.
Hi Eike, one for you. Frank
Reset assigne to the default "issues@openoffice.apache.org".