### [Solved] SAVE a SOLVER model in Calc

Posted:

**Fri Jan 31, 2020 4:54 pm**I know that it is not possible to save a solver model in Calc.

https://ask.libreoffice.org/en/question ... l-in-calc/

https://bugs.documentfoundation.org/sho ... i?id=38948

So I try to propose a possible solution: I used WPS Office 2016 free, and I noticed that it stores the Solver data in the Definition of cells names.

This technique seems simple enough to implement, so can satisfy the requests of many users.

I attach 2 files that I have produced, with examples of two sheets to optimize, and documentation. I think it is not difficult for developers to understand.

Hope this proposal can help make this program better.

Regards.

https://ask.libreoffice.org/en/question ... l-in-calc/

https://bugs.documentfoundation.org/sho ... i?id=38948

So I try to propose a possible solution: I used WPS Office 2016 free, and I noticed that it stores the Solver data in the Definition of cells names.

This technique seems simple enough to implement, so can satisfy the requests of many users.

I attach 2 files that I have produced, with examples of two sheets to optimize, and documentation. I think it is not difficult for developers to understand.

Hope this proposal can help make this program better.

Regards.