To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102411 Issue #|102411 Summary|Solver cannot solve this Component|Spreadsheet Version|OOo 3.1 Platform|PC URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|peterbrown77
------- Additional comments from [email protected] Mon Jun 1 11:53:14 +0000 2009 ------- In the attached spreadsheet, I solve for an involute. I want to solve for the value in G20 by changing H20; the target cell is H21. When I run Solver, it goes to the maximum iterations (2000) and - before I clear the dialog box - shows the correct values in H20 and H21. When I select "OK", a dialog opens that says "No Solution Was Found". When I clear that, the initial values are reinstated in cells H20 and H21 even though it found the solution. I asked this on the forum and got this workaround: " see the same behavior. I found a simple workaround. If you change the formula in H21 to CODE: SELECT ALL EXPAND VIEW =TAN(H20)-H20-G20 and then set the Solver to "optimize to value of 0" the solution converges in less than a second and 100 iterations and successfully recognizes that. This problem is not due just your particular set up. I tried the case of CODE: SELECT ALL EXPAND VIEW A1 = 10 A2 = 5 A3 = A1^2 - A2 If I try to optimize A3 to a value of 2, the Solver does not recognize when it finds a solution. Changing A3 to CODE: SELECT ALL EXPAND VIEW = A1^2 - A2 - 2 and optimizing to a value of zero works fine. The bug is very strange. If I change your G20 to CODE: SELECT ALL EXPAND VIEW =(C21/C17)+(G19)-(G4/(2*C4))+2 and H21 to CODE: SELECT ALL EXPAND VIEW =TAN(H20)-H20+2 that is, just add 2 to each, the solver also converges correctly and recognizes that it does. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
