https://bugs.freedesktop.org/show_bug.cgi?id=64499

--- Comment #2 from Bruce Sobey <[email protected]> ---
Load the spreadsheet I attached
On the RetCalc worksheet go to cell D9
Tools  GoalSeek
Set Formula Cell to $D$9 (should show that if you are on it)
For target Value set the amount shown in PV Required Balance 200000
variable Cell set to $B$6  (monthly draw)
Press OK
You will get "*Goal Seek not successful.
No exact value found.
Insert closest value (R 0)?*"
The same spreadsheet loaded into Excel gets an answer no problem (3584)

Trust that helps
Bruce Sobey


On Wed, May 15, 2013 at 6:49 PM, <[email protected]> wrote:

>  ign_christian <[email protected]> changed bug 
> 64499<https://bugs.freedesktop.org/show_bug.cgi?id=64499>
>  What Removed Added  Status UNCONFIRMED NEEDINFO  Ever confirmed   1
>
>  *Comment # 1 <https://bugs.freedesktop.org/show_bug.cgi?id=64499#c1> on bug
> 64499 <https://bugs.freedesktop.org/show_bug.cgi?id=64499> from
> ign_christian <[email protected]> *
>
> Please explain how to reproduce that problem, so others can easily test it.
>
>  ------------------------------
> You are receiving this mail because:
>
>    - You reported the bug.
>
>

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to