[Libreoffice-bugs] [Bug 38948] FILESAVE - Calc does not save the solver's model to files

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #31 from Rafael Lima <rafael.palma.lima at gmail.com> ---
(In reply to Michael Meeks from comment #30)
> So far no complaints. Of course - if this is useful for students it may be
> that we can find a student who would like to work on it, who can be
> supported by Hossain.

This is mostly useful for universities and research. Of course there are some
industry / organizational applications, but the number of companies using
solvers is significantly lower than the number of companies using more common
spreadsheet features.

I myself am a university professor teaching Operations Research (that relies on
solvers), so it would be awesome to switch to LibreOffice Calc for all my
lectures. However, the lack of (i) having separate solver configurations for
each sheet and (ii) the inability to save solver configuration into files are
issues that make it impossible to adopt LibreOffice Calc in my Operations
Research lectures.

I have already delved into the code to try to figure out how it works... I
could understand most of it, but I have no idea how settings could be saved
into the ODS file. It seems ODF doesn't have anything specific to Solver data.

What I was considering is creating some mechanism that saves Solver settings
into a JSON file and embed it in the ODS file. This is would be similar to the
"Automatic Redaction" feature that saves entries into a JSON file. Could anyone
tell me if this would be a valid approach?

Moreover, I'm not sure if I have enough C++ knowledge to carry this out. Maybe
@Hossain can give some input on how to solve this issue.

-- 
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/20210929/4854e955/attachment.htm>