[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 #34 from Rafael Lima <rafael.palma.lima at gmail.com> ---
(In reply to Hossein from comment #33)
> I would be happy to help implementing this feature. :-) Let me check and
> then write about it.

Hi Hossein! I'll take another look at the code too, to recap everything.

In order to implement this new feature I believe we're gonna need many separate
patches. One possible course of action would be:

1) Implement the ability to save solver configuration on a "per-sheet" basis at
runtime (still not saving to the file). This part might not be so difficult.

2) Save solver settings to an embedded XML file into the ODS file.

3) Make Calc load solver settings when the ODS file is opened and the user
selects a new sheet.

4) Implement XLSX export so that solver settings are compatible with MS Excel
(it seems Excel saves solver info to 'xl/workbook.xml'.

5) Implement XLSX import to be able to load solver settings from Excel files.

I have no idea how to implement steps 2 to 5.

-- 
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/20210930/15ee4437/attachment-0001.htm>