Ask Your Question
1

opensolver.org port

asked 2018-10-02 18:47:01 +0100

geisler gravatar image

I am considering having my CS Seniors port the opensolver.org add-on for Excel to LibreOffice. Roughly speaking, it is a more polished and unrestricted interface to the COIN-OR solver that I believe already comes installed with LibreOffice. Does anyone have a feel for how much time and energy it takes to learn the UNO API well enough to take an existing Microsoft extension and to make it available for LibreOffice?

The extension should add two menu items: make model and solve. The make model item should bring up a form that allows users to enter cell ranges that describe a linear program. The solve item should pass the data provided in the form to the COIN-OR solver and modify the spreadsheet to reflect the solution to the model.

edit retag flag offensive close merge delete

Comments

This has been on our OpenSolver ToDo list for some years. Very keen to help this happen. Andrew (OpenSolver Team). PS: To answer question below, VBA source code is in the spreadsheet; this is how Excel does it

Andrew - OpenSolver Team gravatar imageAndrew - OpenSolver Team ( 2018-10-08 03:29:25 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2018-10-03 19:58:42 +0100

hjek gravatar image

The solve item should pass the data provided in the form to the COIN-OR solver and modify the spreadsheet to reflect the solution to the model.

You could look at Capitalize.py from the PyUNO examples for an example of how to modify document content. There is a lot of boilerplate there, but I guess it could be abstracted away? From the documentation about development of extensions it looks like extensions are really just macros.

I'm confused about this OpenSolver though. It says it's GPL, but all the downloads are just binaries (even including a LICENSE.txt with the GPL) so where's the source?

edit flag offensive delete link more

Comments

@hjek Just an FYI. Extensions can be more than just the macros. It can include other items such as additional menu or toolbar items, help files and more.

Ratslinger gravatar imageRatslinger ( 2018-10-03 20:27:36 +0100 )edit
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2018-10-02 18:47:01 +0100

Seen: 214 times

Last updated: Oct 03 '18