Description: Prior to version 7.6 of Calc, solver options only had to be set one time for a single load of a spread sheet. Since version 7.6 the options have to be reset for each execution of solver on the same load of a spread sheet. I suspect that this has something to do with the resolution of bug 38948. Steps to Reproduce: 1.run a spread sheet 2.run solver and change one or more options 3.check the options before running solver again and observe that your previous options are back to their defaults. Actual Results: options only last for a single running of Solver on the same load of a spread sheet. Expected Results: Prior to version 7.6 of calc, the options did not go back to defaults after each solver run on a single load Reproducible: Always User Profile Reset: No Additional Info: For a single load of a spread sheet, the options should not change back to the defaults after each run.
*** This bug has been marked as a duplicate of bug 38948 ***
(In reply to m.a.riosv from comment #1) > > *** This bug has been marked as a duplicate of bug 38948 *** One of the following alternatives should be true: * Either the reporter of bug 158735 is confused about the versions in which the problem first showed up (and about the older versions in which there was no problem); * or bug 158735 is not really a duplicate of bug 38948. The versions for each of these 2 reports don't match, and actually they seem quite inverted / opposite to each other.
(In reply to jsleeth from comment #0) > Expected Results: > Prior to version 7.6 of calc, the options did not go back to defaults after > each solver run on a single load What solver are you using? I could reproduce the issue with DEPS and SCO. The model itself is saved, but the solver options are lost. (In reply to ady from comment #2) > * or bug 158735 is not really a duplicate of bug 38948. Indeed this is not a duplicate of bug 38948. This is a different bug, because when bug 38948 was fixed, the fix did not consider the specific options of the DEPS and SCO solvers. I am setting this to NEW. Reproduced in Version: 7.6.4.1 (X86_64) / LibreOffice Community Build ID: 60(Build:1) CPU threads: 12; OS: Linux 6.5; UI render: default; VCL: kf5 (cairo+wayland) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Ubuntu package version: 4:7.6.4-0ubuntu0.23.10.1 Calc: threaded
*** Bug 159584 has been marked as a duplicate of this bug. ***
Fix available for review here: https://gerrit.libreoffice.org/c/core/+/164376
Rafael Lima committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/04d884cc99eb66679fb254129b54488bd40e5abf tdf#158735 Save solver settings for DEPS and SCO as well It will be available in 24.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Rafael Lima committed a patch related to this issue. It has been pushed to "libreoffice-24-2": https://git.libreoffice.org/core/commit/fa8351c50bd8f14830a461c09805e43c6fdb065d tdf#158735 Save solver settings for DEPS and SCO as well It will be available in 24.2.2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Rafael Lima committed a patch related to this issue. It has been pushed to "libreoffice-7-6": https://git.libreoffice.org/core/commit/68b0c3a6ac189eea011d1809480e13f7d33652a6 tdf#158735 Save solver settings for DEPS and SCO as well It will be available in 7.6.7. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
*** Bug 160736 has been marked as a duplicate of this bug. ***