Store Solver's metadata in OpenOffice's SpreadSheet

Question

How can you save the metadata of OpenOffice 3.0's Solver?

I do not want to add the conditions each time I open a file in OO's SpreadSheet. Excel by contrast saves the Solver's Limiting conditions.

Answer 1

I fear that OO's native solver doesn't save the model's meta data at all. However, there is (was?) a promising extension that could save the relevant information: scsolver

Unfortunately, it doesn't seem possible to download the extension at the moment. It was included in the Go-oo variant of OpenOffice.org as the default Solver, but as of today, it's not possible to download Go-oo b/c it is being merged with Libreoffice which doesn't include the enhanced solver.

There are still two other options you could go for: Gnumeric offers a nice solver and saves the relevant meta data and the freeware version of the OpenOffice extension EuroOffice Solver does so as well. Hopefully, Libreoffice will do so in the future as well (but not in the recently release version 3.3).

hth

Edit: there is a fairly old bug/ feature request for this: http://openoffice.org/bugzilla/show_bug.cgi?id=93613 - and I just filed the same bug for LibreOffice.