https://bugs.documentfoundation.org/show_bug.cgi?id=160064
Bug ID: 160064
Summary: Named ranges created by the Solver should be hidden by
default
Product: LibreOffice
Version: 24.8.0.0 alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 192995
--> https://bugs.documentfoundation.org/attachment.cgi?id=192995&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the bug.
