<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:carlos.deambroggio@gmail.com" title="Carlos <carlos.deambroggio@gmail.com>"> <span class="fn">Carlos</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - Solving for the local maxima by providing limiting conditions results in an answer, but causes strange behavior in LibreOffice/Solver."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=95278">bug 95278</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>NEEDINFO
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - Solving for the local maxima by providing limiting conditions results in an answer, but causes strange behavior in LibreOffice/Solver."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=95278#c2">Comment # 2</a>
on <a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - Solving for the local maxima by providing limiting conditions results in an answer, but causes strange behavior in LibreOffice/Solver."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=95278">bug 95278</a>
from <span class="vcard"><a class="email" href="mailto:carlos.deambroggio@gmail.com" title="Carlos <carlos.deambroggio@gmail.com>"> <span class="fn">Carlos</span></a>
</span></b>
<pre>(In reply to whiys from <a href="show_bug.cgi?id=95278#c0">comment #0</a>)
<span class="quote">> Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=119910" name="attach_119910" title="An example spreadsheet to use for duplication of the error">attachment 119910</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=119910&action=edit" title="An example spreadsheet to use for duplication of the error">[details]</a></span>
> 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.
> (<a href="http://extensions.openoffice.org/en/project/solver-nonlinear-programming">http://extensions.openoffice.org/en/project/solver-nonlinear-programming</a>-
> 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.</span >
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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>