Bug 130332 - SAVE a SOLVER model in Calc
Summary: SAVE a SOLVER model in Calc
Status: RESOLVED DUPLICATE of bug 38948
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: contrib (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2020-01-31 17:27 UTC by gpgrego
Modified: 2020-02-04 07:46 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

example sheet table to optimize with names of cells for solver (18.00 KB, application/x-ole-storage)
2020-01-31 17:27 UTC, gpgrego

Note You need to log in before you can comment on or make changes to this bug.
Description gpgrego 2020-01-31 17:27:50 UTC
Created attachment 157565 [details]
example sheet table to optimize with names of cells for solver


I know that it is not possible to save a solver model in Calc.

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 file that I have produced, with an example sheet table to optimize. 
You can see names of cells when press CTRL-F3. 
I think it is not difficult for developers to understand.

Hope this proposal can help make this program better.

Comment 1 gpgrego 2020-02-02 12:35:18 UTC
I apologize, I moved my question here:


Comment 2 raal 2020-02-04 07:46:51 UTC

*** This bug has been marked as a duplicate of bug 38948 ***