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

[bugzilla-daemon]

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

Rafael Lima  changed:

   What|Removed |Added

 Status|NEW |ASSIGNED
   Assignee|libreoffice-b...@lists.free |rafael.palma.l...@gmail.com
   |desktop.org |

--- Comment #42 from Rafael Lima  ---
Proposed patch in Gerrit:
https://gerrit.libreoffice.org/c/core/+/148112

This patch implements the solver config save/load feature:
- Solver configurations are now saved per tab (as in MS Excel)
- Solver settings are saved into the ODS file
- The mechanism to save/load solver configurations is compatible to MS Excel,
so XLSX files with solver configurations should be loaded in Calc; and ODS
files exported as XLSX are also expected to work in MS Excel (except a few
solver settings that do not exist in LO)

-- 
You are receiving this mail because:
You are the assignee for the bug.

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

[bugzilla-daemon]

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

--- Comment #41 from magoscuro  ---
Hello all,
this is curently the only piece of software I miss to stop using MS Office and
then windows.
I work as a Logistics Engineering Manager, and I use the libreoffice solver to
optimise network models, it is also used on MItx Supply Chaine Micromasters,
wich encourage the use of Libreoffice giving .odf file model to teach.

Please add the funcionatlity to save, or export the solver model, save on the
.odf file is not necesary if we can export the model and prevent the loss of
time modeling.

-- 
You are receiving this mail because:
You are the assignee for the bug.

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

[bugzilla-daemon]

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

--- Comment #40 from Commit Notification 
 ---
Rafael Lima committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/help/commit/40ee3181de08d372b5a25bb691644a94d3ffe9bd

Related tdf#38948 Warn that Calc Solver does not save model to file

-- 
You are receiving this mail because:
You are the assignee for the bug.

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

[bugzilla-daemon]

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

Commit Notification  changed:

   What|Removed |Added

 Whiteboard||target:7.4.0

-- 
You are receiving this mail because:
You are the assignee for the bug.

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

[bugzilla-daemon]

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

--- Comment #39 from Wolfgang Jäger  ---
Anyway the "current settings" are only  kept foe the ONE dialog as long as the
file is open. 
In fact I would think of cases where more than one set of parameters for a
solver should be recallable in different sheets e.g. or for working on a set of
data with different solver algorithms or changing constraints experimentally.  
See my comment here
https://bugs.documentfoundation.org/show_bug.cgi?id=70399#c3. 
The shortcoming insofar is neither handled by a note nor by a prompt.

-- 
You are receiving this mail because:
You are the assignee for the bug.

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

[bugzilla-daemon]

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

--- Comment #38 from Matías Benzo  ---
Hi Rafael, thank you very much for your reply.
Evidently I misunderstood that note or overlooked it. Anyway, it is surely
better as a warning than as a note.
Too bad this remains unresolved, it takes a lot of potential away from Calc.
Do you know if anyone is working on this?

-- 
You are receiving this mail because:
You are the assignee for the bug.

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

[bugzilla-daemon]

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

--- Comment #37 from Rafael Lima  ---
(In reply to Matías Benzo from comment #36)
> It should be clarified that the LibreOffice help does not mention such a
> limitation either.

Hi Matías, the current help page [1] has the following statement: "The dialog
settings are retained until you close the current document."

It's expressed as a "note". Maybe we could rephrase it to "Beware that solver
settings are not saved to the file by LibreOffice Calc. Closing and reopening
the file will reset the solver dialog to default settings." and use a warning
block instead of a note.

[1]
https://help.libreoffice.org/latest/en-US/text/scalc/01/solver.html?DbPAR=CALC#bm_id7654652

-- 
You are receiving this mail because:
You are the assignee for the bug.

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

[bugzilla-daemon]

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

--- Comment #36 from Matías Benzo  ---
Dear all, I arrived here after all the model I had loaded into the solver had
disappeared when I opened the file the next day.
In my humble opinion, if there are no developers interested in implementing
what is necessary to allow saving the models, there should at least be a
warning, when opening the solver, that the models are volatile.
It should be clarified that the LibreOffice help does not mention such a
limitation either.
It is not nice to lose all the work done.
>From my point of view this is not only a missing feature but it is a loss of
information and work, and forces to look for alternatives.
I hope I don't sound inconsiderate, it's just constructive criticism.

-- 
You are receiving this mail because:
You are the assignee for the bug.

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

[bugzilla-daemon]

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

Rafael Lima  changed:

   What|Removed |Added

   See Also||https://bz.apache.org/ooo/s
   ||how_bug.cgi?id=93613

-- 
You are receiving this mail because:
You are the assignee for the bug.

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

[bugzilla-daemon]

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

Rafael Lima  changed:

   What|Removed |Added

  Alias|escorts, Mumbai |
   See Also|https://bz.apache.org/ooo/s |
   |how_bug.cgi?id=93613|
URL|https://nightangelescort.in |
   Keywords|accessibility   |

-- 
You are receiving this mail because:
You are the assignee for the bug.

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

[bugzilla-daemon]

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

ritu pathak  changed:

   What|Removed |Added

  Alias||Mumbai, escorts
   Keywords||accessibility
URL||https://nightangelescort.in

-- 
You are receiving this mail because:
You are the assignee for the bug.

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

[bugzilla-daemon]

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

--- Comment #35 from Wolfgang Jäger  ---
Sorry, I won't b able to scan the cod, but...

Regarding the already mentioned complications, the problem where to store the
parameters, and how to do it per sheet or in a different way, then a probable
decision to implement an interim solution, I would suggest a simpler and
probably even more useful solution: 

Create a bit of code saving the parameters of a solver job (including the
algorithm designator) to a cell range the user may describe in a field of the
dialog. A button then can trigger the action. In the same way a job could be
read from a cell range and passed to the solver object. 
This would be rather simple. 
I will not rework the dialog, but surely I could write the needed code even in
Basic in a reasonable time.

-- 
You are receiving this mail because:
You are the assignee for the bug.

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

[bugzilla-daemon]

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

--- Comment #34 from Rafael Lima  ---
(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.

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

[bugzilla-daemon]

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

--- Comment #33 from Hossein  ---
(In reply to Michael Meeks from comment #32)
> Probably you'll need some help connecting that through the UNO madness into
> somewhere you can easily stream things in and out - Hossein should be able
> to help with that I imagine. I would use XML not JSON just for reasons of
> consistency in ODF really. If there is an existing standard for this from
> the MS side it would be good to be interoperable with that I think too. HTH!
I would be happy to help implementing this feature. :-) Let me check and then
write about it.

-- 
You are receiving this mail because:
You are the assignee for the bug.

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

[bugzilla-daemon]

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

--- Comment #32 from Michael Meeks  ---
Hi Rafael - great news that you've researched it =) Yes of course storing it in
a un-standardized stream in the ODF file for now is a good approach. Probably
you'll need some help connecting that through the UNO madness into somewhere
you can easily stream things in and out - Hossein should be able to help with
that I imagine. I would use XML not JSON just for reasons of consistency in ODF
really. If there is an existing standard for this from the MS side it would be
good to be interoperable with that I think too. HTH!

-- 
You are receiving this mail because:
You are the assignee for the bug.

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

[bugzilla-daemon]

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

--- Comment #31 from Rafael Lima  ---
(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.

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

[bugzilla-daemon]

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

Michael Meeks  changed:

   What|Removed |Added

 CC||hoss...@libreoffice.org

--- Comment #30 from Michael Meeks  ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.

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

[bugzilla-daemon]

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

Telesto  changed:

   What|Removed |Added

 CC||michael.me...@collabora.com
   ||, tele...@surfxs.nl

--- Comment #29 from Telesto  ---
@Michael,
No clue about need/demand for this at enterprise level. Only a poke

-- 
You are receiving this mail because:
You are the assignee for the bug.

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

[bugzilla-daemon]

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

raal  changed:

   What|Removed |Added

 CC||pszab...@gmail.com

--- Comment #28 from raal  ---
*** Bug 144776 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.

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

[bugzilla-daemon]

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

raal  changed:

   What|Removed |Added

 CC||rafael.palma.l...@gmail.com

--- Comment #27 from raal  ---
*** Bug 134529 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Julien Nabet  changed:

   What|Removed |Added

   See Also|http://openoffice.org/bugzi |https://bz.apache.org/ooo/s
   |lla/show_bug.cgi?id=93613   |how_bug.cgi?id=93613

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Jean-Baptiste Faure  changed:

   What|Removed |Added

 CC||jbfa...@libreoffice.org
Version|6.0.7.3 release |3.5.0 release

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #26 from Kanika Rajput  ---
We aware and see it is so tough to find Goa escorts who suits all of your
yearning. Between lack of time rather than understanding entirely where to find
these intriguing Goa escorts. It's anything but hard to end up frustrated. 
https://www.aadia-shah.com

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #23 from Kanika Rajput  ---
In the event that your good person, you need all of the flavour of Udaipur
escort service, we centre in providing you with the love experience you would.
Wish to receive a desire for 60 minutes or several to make you optimistic from
a painful moment.
https://www.callgirlsinudaipur.co.in

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #22 from Kanika Rajput  ---
In Ahmedabad escorts, many specialist escorts collaborate, but not all them are
escortsgirls. There are a few that provide a fantastic conversation, a
memorable sexual connection but also will willingly accompany the customer to
some occasion, dinner or social occasion. 
https://www.pinkykhanna.in

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #24 from Kanika Rajput  ---
The time contracted by a Goa call girls of business, includes sexual relations
with the woman. After the number of hours is higher than you can ask a
reduction of the cost per hour. The cost contracted for your escort service in
Goa are regular rather than exposed to discussions. 
http://www.jaclin.in

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #25 from Kanika Rajput  ---
First of all, if you would like to enjoy a fantastic experience with a call
girl in Jaipur of very good business, there's recourse to some place of
excellent standing and be quite clear that's exactly what you desire. 
https://www.arpitachowdhary.com

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #21 from Kanika Rajput  ---
Our female escorts can touch you and provide you the main unwinding rubs you've
ever dream off. Mumbai call girls are here in order to complete your fantasies
and desires and also to make you are staying in Mumbai really wonderful. 
http://www.piyali.in

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #19 from Kanika Rajput  ---
We'll send you a list of call girls in Dehradun that cansatisfy you. We know
your concerns and that is why goal to supply you with the ideal support. We
additionally provide finest Dehradun escorts for complete enjoyment.
https://www.simranroy.co.in/dehradun-escorts-services.html
https://www.simranroy.co.in/haridwar-escorts-services.html
https://www.simranroy.co.in/mussoorie-escorts-services.html
https://www.simranroy.co.in/rishikesh-escorts-services.html

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #18 from Kanika Rajput  ---
Our vip Nainital escorts service, with higher quality and dependability, can
direct you make a decision based on the customer's preferences. Escort agencies
frequently work with independent women who meet top quality standards.
https://www.juhioberoi.com/
https://www.juhioberoi.com/haldwani-escort-service-call-girls.html
https://www.juhioberoi.com/ramnagar-escort-service-call-girls.html
https://www.juhioberoi.com/rudrapur-escort-service-call-girls.html

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #20 from Kanika Rajput  ---
You can also reserve at any time of night or day we make it easy for you to
reserve the top escorts in Hyderabad together with our round the clock opening
hours; it does not create a difference once you settle a decision to meet our
escorts. 
https://www.pragyathakur.in

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

raal  changed:

   What|Removed |Added

 CC||gpgr...@libero.it

--- Comment #17 from raal  ---
*** Bug 130332 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Sean Porterfield  changed:

   What|Removed |Added

 CC||docf20191027@sf.porterfield
   ||.net

--- Comment #16 from Sean Porterfield  ---
Created attachment 155355
  --> https://bugs.documentfoundation.org/attachment.cgi?id=155355=edit
Example xl/workbook.xml from .xlsx showing solver values

Microsoft Excel .xlsx files have this information saved, per worksheet.  Even
without saving, we're stuck with the same solver info on every worksheet
instead of having each one remembered.

It would be great, at the very least, if Calc supported the .xlsx feature in
that file type, even if it can't be saved elsewhere.  (I'm not familiar with
.odf, but I suspect the same feature can be used there as in .xlsx.)

When I unzip the .xlsx file, I see xl/workbook.xml which contains all of the
solver information for the tabs.  Attaching example file.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Carlos Villegas  changed:

   What|Removed |Added

 CC||geometricalf...@gmail.com
   Severity|enhancement |normal
Version|3.5.0 Beta2 |6.0.7.3 release
   Hardware|All |x86-64 (AMD64)
 OS|All |Linux (All)

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #15 from Carlos Villegas  ---
As of Libre Office version 6.07.3 this bug has not been solved nor Assigned !
Importance URGENT  as it was reported more than 8 years ago !

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #14 from Marco  ---
Have lots of .xls sheets with solver settings. I think this is an important
issue that lowers the value of Libreoffice Calc.
Hope it wil be fixed/implemented soon.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #13 from Hector Perez  ---
This bug continues to be present in LO 6.2. This is the biggest stumbling block
for switching over to LO in my case.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #12 from Andrea Ferrari  ---
This bug is still present in Libreoffice 6.0.4.2 (x64)
Regards
Andrea

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Luke  changed:

   What|Removed |Added

   See Also||http://openoffice.org/bugzi
   ||lla/show_bug.cgi?id=93613

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #11 from Tim M  ---
This is still an issue in Version: 5.1.6.2.0+.

Is this still an issue in later versions?

Are there any comments from someone more familiar with the code as to this
bug's
status?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #10 from Dwight Walker  ---
OpenOffice 2.0 has save and load for solver but LibreOffice 5.0.2.2 does not.

The solver settings are basic maths language and could be saved or exported as
a text file.

I have written maths solutions using lp_solve in FreeBSD in a maths language -
objective function, decision variables, constraints.

See this for the language:

http://lpsolve.sourceforge.net/5.5/

I discovered this when OpenOffice 2.0 crashed and a maths language of
constraints etc was listed.

So the file does not have to be saved in ODF but plain text file. This is a
script not a data file.

If you won't change the GUI, have a text format that anyone can edit and view
or replace solver with a plugin where the plugin writer can export and import
settings.

Or the script could be serialized and stored in a blob and reloaded when the
file is loaded.

The apathy is staggering.

I tried to hack the binary file but could not find the solver data in there so
it is only in memory till the application closes.

Outsource the data file to the plugin if you won't be bothered fixing this.

So back to writing down the objective function, decision variables and
constraints on paper and re-entering whenever I run a LibreOffice solver
solution. So daggy.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #9 from Gerald Senarclens de Grancy o...@senarclens.eu ---
The issue of not being able to save solver models is still present in 4.2.7.2.
Also, it is still not possible to load models saved by Microsoft Excel. A
showstopper for using LibreOffice in operations research.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #8 from Fabio Fagundez fabio.fagun...@gmail.com ---
(In reply to comment #1)
 I vote for changing the importance of this bug to be at least normal for
 two reasons:
 - it would be critical if after entering a formula in a cell, instead of the
 formula, only the outcome (number) is saved to file - which is basically
 what happens with the solver objective and constraints.
 - this particular bug prevents (business) schools/ universities from
 teaching Libreoffice instead of Microsoft (and has been ignored by
 OpenOffice for about three years).

I second that vote. In order to be a viable option, Calc's Solver must be able
to save the model with its constraints, objective function and variables.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Gerald Senarclens de Grancy o...@senarclens.eu changed:

   What|Removed |Added

 CC||madfishthe...@gmail.com

--- Comment #5 from Gerald Senarclens de Grancy o...@senarclens.eu 2012-06-15 
01:42:54 PDT ---
*** Bug 32063 has been marked as a duplicate of this bug. ***

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #6 from Gerald Senarclens de Grancy o...@senarclens.eu 2012-06-15 
01:53:05 PDT ---
I have a question regarding the feasibility of this request. It has been argued
over and over that w/ the current version of the odf specification it is not
possible to store the solver's model. However, as of January 2012 OASIS has
released ODF 1.2 which includes the possibility of storing meta data:
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part3.html#__RefHeading__752819_826425813
Shouldn't it be possible to save/ load the model(s) to/from metadata files?

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #7 from roberto.tava...@gmail.com 2012-06-15 01:58:35 PDT ---
I have the same problem! I want to use L.O. for teaching, but this bug really
gets in the way, and I keep going back to MS Office...

(In reply to comment #2)
 (In reply to comment #1)
  I vote for changing the importance of this bug to be at least normal for 
  two
  reasons:
  - it would be critical if after entering a formula in a cell, instead of the
  formula, only the outcome (number) is saved to file - which is basically 
  what
  happens with the solver objective and constraints.
  - this particular bug prevents (business) schools/ universities from 
  teaching
  Libreoffice instead of Microsoft (and has been ignored by OpenOffice for 
  about
  three years).
 
 I second this vote. I'm a college student currently going through operations
 research subjects which require linear programming as part of its syllabus, 
 and
 so far LO Calc has been a big help in solving cases on integer programming
 we're being given in class. However, the lack of a save function shocked me
 when I discovered that my previously lengthy model in one particular problem
 all but disappeared when I reopened the file at a later time.
 
 This sounds like much more than a feature request. It's functionality that's
 missing, because no one in their right mind would create anything more than 
 the
 most basic of LP models using Calc knowing that they would have to rebuild it
 EVERY SINGLE SESSION.
 
 I read in a similar bug post (32063) that implementing it would require
 changing the ODF spec. I propose for the solver to simply not save the model 
 in
 the same *.ods file as the spreadsheet from which it is built, but rather in a
 separate file. I find this to be an elegant solution, since the implementer of
 the language solver would use to save the data is unconstrained to pick from
 any of the plentiful (and open) LP languages out there, with my own preference
 of GAMS. It would furthermore be highly portable, meaning it could be loaded
 onto any other spreadsheet and run independent of the original basis of the
 model.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Florian Reisinger reisi...@gmail.com changed:

   What|Removed |Added

Summary|FILESAFE - Calc does not|FILESAVE - Calc does not
   |save the solver's model to  |save the solver's model to
   |files   |files

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs