[Libreoffice-bugs] [Bug 95278] Solving for the local maxima by providing limiting conditions results in an answer , but causes strange behavior in LibreOffice/Solver.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=95278

Carlos <carlos.deambroggio at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEEDINFO
     Ever confirmed|0                           |1

--- Comment #2 from Carlos <carlos.deambroggio at gmail.com> ---
(In reply to whiys from comment #0)
> Created attachment 119910 [details]
> An example spreadsheet to use for duplication of the error
> 
> 0) Download the attached example.ods.
> 0.5) Install nlpsolver if you haven't already.
> (http://extensions.openoffice.org/en/project/solver-nonlinear-programming-
> beta)
> 1) Summon Solver.
> 2) Select $B$7 as your target cell.
> 3) Optimize the result to maximize that cell.
> 4) Select $B$6 as the cells to change.
> 5) If we solved now, we'd get the absolute maxima. We want a local maxima
> instead, so add in two limiting conditions, one for $B$6 <= 2, and one for
> $B$6 => 3.
> 6) Solve.
> 7) You can either wait out the 2000 iterations, or stop shortly after
> starting. Either way, Solver will have arrived at the answer (Should say
> 2.90). It should be noted that $B$6 will be (approximately) equal to $B$11,
> and $B$7 will be (approximately) equal to $B$12. This is the answer we want.
> 8) After hitting OK, Solver will declare that "No solution was found." and
> revert the two cells to what they were before Solving.
> 
> I don't know if this is an edge case on Solver, or the result of weirdness
> from the NLP Solving plugin, but even if Solver couldn't be convinced that
> this is the answer I want, it'd be nice to have the "No solution was found."
> box give me the option to keep the answers, rather than reverting them with
> no recourse. The answer can still be extracted (as you can see), but it
> requires typing everything out manually outside of LibreOffice, which is a
> pain.


Did you try version 5.3.2?

I have set the bug's status to 'NEEDINFO'. Please change it back to
'UNCONFIRMED' once the requested information is provided.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170420/41ddd51e/attachment-0001.html>