https://bugs.documentfoundation.org/show_bug.cgi?id=150307
Bug ID: 150307
Summary: Calc Name Box field not updated after deleting a named
range
Product: LibreOffice
Version: 7.3.5.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
The Name Box drop-down list is not updated immediately after deleting a named
range.
Steps to Reproduce:
1. Create a Calc document.
2. Entere data and named the range. The name is global (in the document).
3. Create a copy of the sheet. Calc added the same name, but local (on the
sheet).
4. Deleted the copy of the sheet.
Actual Results:
In the Manage Names dialog, one global name remains. However, both names are
still present in the drop-down list of the Name Box field. The field is not
updated.
Expected Results:
The Name Box drop-down list must be updated immediately after deleting a named
range and must match the Manage Names dialog box for named ranges (because it
does not display named formulas).
Reproducible: Always
User Profile Reset: No
Additional Info:
The Name Box sorts names case-sensitive, while the Manage Names dialog is not
case-sensitive. Order is broken.
--
You are receiving this mail because:
You are the assignee for the bug.