<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Solver Macro cannot solve to a target because there is not suitable API object"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=127974">127974</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Solver Macro cannot solve to a target because there is not suitable API object
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.3.1.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>BASIC
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>bsobey@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=154768" name="attach_154768" title="File to Demonstrate problem with Basic Macro to Solve to target">attachment 154768</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=154768&action=edit" title="File to Demonstrate problem with Basic Macro to Solve to target">[details]</a></span>
File to Demonstrate problem with Basic Macro to Solve to target
It is possible to call Solver from a macro program and solve for a maximum (and
I think minimum) but there is no object one can set such as there is for
"solv.maximise = true" I would expect something such as "solve.target =
dTarget" I have checked the documentation and forums and used xray and got the
list at the end but nothing indicates that a target can be set.
Calling solver with the uno does not allow presetting any values so is also not
useful.
The examples are shown in the file HelloSheet3.ods
AssumeNonNegative boolean False
SwarmSize long 70
LearningCycles long 2000
GuessVariableRange boolean True
VariableRangeThreshold double 3
UseACRComparator boolean False
UseRandomStartingPoint boolean False
StagnationLimit long 70
Tolerance double 1E-06
EnhancedSolverStatus boolean True
AgentSwitchRate double 0.5
DEFactor double 0.5
DECR double 0.9
PSC1 double 1.494
PSC2 double 1.494
PSWeight double 0.729
PSCL double 0
ImplementationName string <...> (get),
read-only
SupportedServiceNames []string (get),
read-only
Locale struct (get,set)
Document object attribute
Objective struct attribute
Variables []struct attribute
Constraints []struct attribute
Maximize boolean False attribute
Success boolean False attribute,
read-only
ResultValue double 0 attribute,
read-only
Solution []double attribute,
read-only
ComponentDescription string "DEPS Evolutionary Algorithm" attribute,
read-only
StatusDescription string "" attribute,
read-only
PropertySetInfo object (get),
read-only
Properties []struct (get),
read-only
Types []type (get),
read-only
ImplementationId []byte <empty> (get),
read-only</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>