https://bugs.freedesktop.org/show_bug.cgi?id=64499
--- Comment #7 from Bruce Sobey <[email protected]> --- Hi Foss I think I initially submitted an xls file (RetirementCalc.xls), but I may have saved it as an ods file as well. It makes no difference they both give the same problem when goal seek is run in LibreOffice. It is a file to calculate how much one can draw (cell B6) to reach the target at the number of years. To do this one runs goal seek (or makes many successive changes to cell B6). Running goal see (Tools, Goal Seek)one would tell it to set Formula cell D7, Target value = 0, Variable cell B6. However LibreOffice (like OpenOffice before it) does not find a solution. However Excel does not have a problem withe this - In fact the excel file has a macro to do this automatically, which I was intending to move to LibreOffice. I made a small test file doing something similar and it ran Goal Seek fine, so there is some problem with the convergence algorithm in this case. Hope this helps Bruce On Thu, Nov 14, 2013 at 9:09 PM, <[email protected]> wrote: > Foss <[email protected]> changed bug > 64499<https://bugs.freedesktop.org/show_bug.cgi?id=64499> > What Removed Added Status UNCONFIRMED NEEDINFO Ever confirmed 1 > > *Comment # 6 <https://bugs.freedesktop.org/show_bug.cgi?id=64499#c6> on > bug 64499 <https://bugs.freedesktop.org/show_bug.cgi?id=64499> from Foss > <[email protected]> * > > Bruce, sorry for being an ubernoob. Could you post exact reproduce steps? > Which > file is opened in which format with which application. > > This seems to be about excel but the test file is a ods file? > > ------------------------------ > 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
