Bug 160064 - Named ranges created by the Solver should be hidden by default
Summary: Named ranges created by the Solver should be hidden by default
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.0.0 alpha0+
Hardware: All All
: medium enhancement
Assignee: Rafael Lima
URL:
Whiteboard: target:24.8.0
Keywords:
Depends on:
Blocks: Cell-Name Solver
  Show dependency treegraph
 
Reported: 2024-03-06 14:35 UTC by Rafael Lima
Modified: 2024-04-09 12:24 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Solver models created in Excel (27.31 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-03-06 14:35 UTC, Rafael Lima
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Rafael Lima 2024-03-06 14:35:24 UTC
Created attachment 192995 [details]
Solver models created in Excel

When we create Solver models in a Calc file, they're save to the sheet using Named Ranges. However, these named ranges become visible in the "Manage Names" dialog, which clutters the dialog and may make users confused about why so many named ranges exist in their file.

To test this, simply create a blank Calc file, go to Tools - Solver, then close the Solver dialog and open the Manage Names dialog. You'll see a lot of named ranges there. They should be hidden by default.

In MS Excel (which also saves solver settings using named ranges), all named ranges created for the solver are hidden from the user by default. For instance, open the attached XLSX file that contains various models. If you go to Tools - Solver, you'll be able to see the solver model. But the Manage Names dialog will be empty, because all named ranges are set to "hidden".

So, I propose we also hide solver-related named ranges by default.

Note: hidden named ranges support was added after bug 154449 was fixed.
Comment 1 Stéphane Guillou (stragu) 2024-03-21 07:54:17 UTC
Thanks Rafael.
Makes perfect sense to me, for UX and consistency with MSO.
Comment 2 Rafael Lima 2024-04-01 13:58:17 UTC
Proposed patch here
https://gerrit.libreoffice.org/c/core/+/165621
Comment 3 Commit Notification 2024-04-08 14:03:15 UTC
Rafael Lima committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/2533960315607bf3e86ad014d2daa4bfa7e3fa59

tdf#160064 Hide named ranges/expressions of solver models

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.