https://bugs.documentfoundation.org/show_bug.cgi?id=159432
Bug ID: 159432
Summary: Sort and/or filter Named Ranges And Expressions from
Manager
Product: LibreOffice
Version: 7.3.7.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: topicUI
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Sometimes it is necessary to create many Named Ranges and Expressions, such as
when creating spreadsheets that will be parsed by software that uses the Named
Range data to perform functions. When there are many worksheets in a workbook,
and many ranges within each worksheet, the Named Ranges and Expressions Manager
display is difficult to navigate. The list is only scrollable, and I may
eventually have to scroll through hundreds of entries.
Because of this, I request an enhancement where Named Ranges and Expressions
Manager display as sortability by name, and preferably should have
filterability by range name as well as by sheet name .
Example:
There are several regions in a worksheet that contain similar types of data,
but is intended to have some variation in fields and placement. A software that
relies on the data must be able to identify the regions in the spreadsheet to
parse it. Because of this a naming convention is adopted where the type is
combined with a serial number:
MOD_0
MOD_1
...
MOD_100
When continuously editing the spreadsheet across different work sessions, it is
not possible for me to remember the last index number, so I have to scroll to
find it. I may also forget the current index number I am on DURING a work
session and rely on the scrollbar to discover the last index used in a name.
Furthermore, I want to capture two "subranges" within existing ranges. To do
this I adapt the naming convention for compatibility with the existing range
names:
MOD_0
MOD_0_SUP
MOD_0_SUB
MOD_1
MOD_1_SUP
MOD_1_SUB
...
MOD_100
MOD_100_SUP
MOD_100_SUB
As I am adding two subranges to correspond with each existing range, I
occasionally need to view the existing range area highlighted in the
spreadsheet while inspecting it in the Named Ranges and Expressions Manager
display so I can accurately select and name the subranges. This process would
be more efficient if I could filter the list of Named Ranges and Expressions.
--
You are receiving this mail because:
You are the assignee for the bug.
