[Libreoffice-bugs] [Bug 127974] New: Solver Macro cannot solve to a target because there is not suitable API object

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 127974
           Summary: Solver Macro cannot solve to a target because there is
                    not suitable API object
           Product: LibreOffice
           Version: 6.3.1.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: BASIC
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: bsobey at gmail.com

Created attachment 154768
  --> https://bugs.documentfoundation.org/attachment.cgi?id=154768&action=edit
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

-- 
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/20191005/8a19ae7c/attachment-0001.html>