Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

API

SDK

Tips ‘n’ Tricks

Miscellaneous


:: com :: sun :: star :: sheet ::

unpublished interface XSolver
Usage Restrictions
not published
Description
allows to call a solver for a model that is defined by spreadsheet cells.

Methods' Summary
solve executes the calculation and tries to find a solution. 
Attributes' Summary
Document The spreadsheet document that contains the cells. 
Objective The address of the cell that contains the objective value. 
Variables The addresses of the cells that contain the variables. 
Constraints The constraints of the model. 
Maximize selects if the objective value is maximized or minimized. 
Success contains true if a solution was found. 
ResultValue contains the objective value for the solution, if a solution was found. 
Solution contains the solution's value for each of the variables, if a solution was found.  
Methods' Details
solve
void
solve();

Description
executes the calculation and tries to find a solution.
Attributes' Details
Document
XSpreadsheetDocument Document;
Description
The spreadsheet document that contains the cells.
Objective
::com::sun::star::table::CellAddress Objective;
Description
The address of the cell that contains the objective value.
Variables
sequence< ::com::sun::star::table::CellAddress > Variables;
Description
The addresses of the cells that contain the variables.
Constraints
sequence< SolverConstraint > Constraints;
Description
The constraints of the model.
Maximize
boolean Maximize;
Description
selects if the objective value is maximized or minimized.
Success
[ readonly ] boolean Success;
Description
contains true if a solution was found.
ResultValue
[ readonly ] double ResultValue;
Description
contains the objective value for the solution, if a solution was found.
Solution
[ readonly ] sequence< double > Solution;
Description
contains the solution's value for each of the variables, if a solution was found.
Top of Page

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.