Language Asturianu (ast) Català (ca) Čeština (cs) Dansk (da) Deutsch (de) English [US] (en-US) Español (es) Esperanto (eo) Eesti keel (et) Euskara (eu) Français (fr) Gàidhlig (gd) Galego (gl) Italiano (it) Lietuvių (lt) Magyar (hu) Nederlands (nl) Norsk (no) Polski (pl) Português [do Brasil] (pt-BR) Português [Europeu] (pt) Română (ro) Slovenčina (sk) Slovenščina (sl) Suomi (fi) Svenska (sv) Yкраїнська (uk) Tiếng Việt (vi) Türkçe (tr) ኦሮሚኛ (om) Հայերեն (hy) Ελληνικά (el) български език (bg) Русский (ru) Cрпски [ћирилицом] (sr) עברית (he) हिन्दी (hi) ភាសាខ្មែរ (km) தமிழ் (ta) ภาษาไทย (th) 简体中文 (zh-CN) 正體中文 (zh-TW) 日本語 (ja) 한국어 (ko)

The Free and Open Productivity Suite

• Product
• Download
• Support
• Blog
• Extensions & Templates
• Get Involved
• Focus Areas
• Native Languages

home » api » docs » common » ref » com » sun » star » sheet

Overview

Module

Use

Devguide

Index

Methods' Summary

Attributes' Summary

Methods' Details

Attributes' Details

---

:: 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

---

Copyright © 2013, The Apache Software Foundation, Licensed under the Apache License, Version 2.0. Apache, the Apache feather logo, Apache OpenOffice and OpenOffice.org are trademarks of The Apache Software Foundation. Other names may be trademarks of their respective owners.

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.