https://bugs.freedesktop.org/show_bug.cgi?id=64499
--- Comment #9 from Owen Genat <[email protected]> --- Created attachment 89341 --> https://bugs.freedesktop.org/attachment.cgi?id=89341&action=edit XLS and screenshots showing behaviour under Word Mac 2011 and LOv4132. I can confirm the behaviour described in comment #2. I tested the provided under Crunchbang 11 x86_64 running LO v4.1.3.2 Build ID: 70feb7d99726f064edab4605a8ab840c50ec57a. I then saved this file as an XLS and XLSX for testing under MacOS 10.6.8 running Word Mac 2011. Screenshots of what I am seeing are attached along with a copy of the XLS. The XLSX cause a "File is damaged, would you like to repair?" error in the indicated version of Word and even though it appeared to repair / work it is probably no more use than the XLS. (In reply to comment #5) > Goalseeking is a bit of a black art; I do not profess to being a financial or formula whizz, but this would seem disheartening if true. Is it simply because there are multiple methods? I notice in the code (e.g., http://opengrok.libreoffice.org/xref/core/sc/source/core/data/documen4.cxx#51) that there are comments like: > This function is used internally for the goal seek operation. It uses the > Regula Falsi (aka false position) algorithm to find a root of f(x). The > start value and the target value are to be given by the user in the > goal seek dialog. The f(x) in this case is defined as the formula in the > formula cell minus target value. ... and on the web that there is also a secant method as well as others for determining / solving this type of equation. Presumably this is what is being referred to? I just want to clarify what the goal seek is attempting to do in this case. It takes the formula in cell D9 and examines the references: A13 (start year); B7-1 (end year, b/c start is year 1 rather than 0); 4 (closing balance column). The goal seek is then telling Calc to adjust the value in B6 (monthly draw / salary) to determine a value that will result in the requested value (200,000) appearing as a closing balance at the 35 year mark. Is that right? -- 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
