This bug is a bit technical, so let's go. ScSolverUtil::GetDefaults is used to get the default values of solver engines. However, it only accepts values of types LONG, DOUBLE and BOOLEAN [1]. The problem arises when you're implementing a new solver engine via Python extension... if you set one of the solver parameters to 100, it will be understood as a BYTE type and won't be shown in the Solver Options dialog. Note that this is forced in Runtime::pyObject2Any (see [2]). I propose ScSolverUtil::GetDefaults should also accept BYTE and SHORT types as well. [1] /core/sc/source/ui/miscdlgs/solverutil.cxx [2] /core/pyuno/source/module/pyuno_runtime.cxx
This patch implements the proposed solution: https://gerrit.libreoffice.org/c/core/+/173093
Rafael Lima committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/2c5718353658fce9f40157ee49c1f0af1f5cc0df tdf#162899 Accept BYTE and SHORT types in the Solver Options dialog It will be available in 25.2.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-8": https://git.libreoffice.org/core/commit/4dc25ebbee7f4ff7c8eb561f5bfb03779e944f35 tdf#162899 Accept BYTE and SHORT types in the Solver Options dialog It will be available in 24.8.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.