To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110539 Issue #|110539 Summary|solver does return possitive results when using abs() |in target cell Component|Spreadsheet Version|1.0.3 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|e3k
------- Additional comments from [email protected] Wed Mar 31 22:31:25 +0000 2010 ------- i am trying to find a solution for 2 cells with diverse terms inside where their value is 0 (both of them). i created a cell with =abs(a1) + abs(a2) (the sum of abs values of the 2 cells above). targeted the cell with the solver and did run the solver on some variables. the problem is that he reports finding the right solution with a number != 0 but i specificly said i am searching for 'value of' = 0. for example both cells are = -1630 and the solver says he found the solution 3260. which is not right as i was searching for 0. --------------------------------------------------------------------- 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]
