When you create a solver model in Excel and import it into Calc, the sheet names are used to display the addresses even when the model belongs to the shame sheet. For instance, see the attached image. The solver model belongs to a sheet named "Transporte" and the imported model in Tools - Solver dialog shows range addresses as $Transporte.$J$18 i.e. starting with the sheet name. This is not necessary since the model is in a sheet with the same name. Moreover, models created within LO Calc won't add this unnecessary sheet name. So in summary, for a sheet containing a solver model, all addresses referring to the same sheet should not display the sheet name as prefix. This happens in LO 7.6+
Created attachment 189032 [details] Screenshot showing the problem
Created attachment 189033 [details] XLSX file with the solver models This file has 4 tabs, each with its own solver model. The screenshot was taken from the "Transporte" sheet, but it happens in any sheet.
Confirmed Arch Linux 64-bit, X11 Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 43df1237a091e2b0f4495d5a7e959f7beaab025d CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Built on 13 September 2023
Fun fact: while fixing this bug I found out that in MS Excel, the solver dialog does not allow to use ranges from other sheets. Calc does allow that, which is totally fine.
Proposed patch: https://gerrit.libreoffice.org/c/core/+/164610
Rafael Lima committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/d3049ab4786005c6bd17c66f8edcb98210bf511c tdf#156814 Remove sheet name if range belongs to the same sheet (Solver) 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.