https://bugs.documentfoundation.org/show_bug.cgi?id=173364
Bug ID: 173364
Summary: UI: Unable to edit database range for xlsx document
Product: LibreOffice
Version: 26.8.0.3 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Existing database ranges in an .xlsx document can no longer be edited via Data
> Define Range.
Reproduction steps:
1. Create a new LibreOffice Calc worksheet and save it as a .xlsx document.
2. In the menu, go to Data > Define Range.
3. In the Define Database Range dialog box, enter abc in the Name field. Enter
$Sheet1.$A$1:$A$2 in the Range field. Click OK.
4. Save the document, close, and re-open.
5. Again, in the menu, go to Data > Define Range. Click "abc" in the list of
defined ranges. Note that the Range field cannot be edited.
Version 26.2.5.2 does not have this issue; the Range field is editable in step
5. This issue also does not appear in version 26.8.0.3 if I save the document
as .ods in step 1. I regularly edit database ranges as part of my workflow, and
this bug prevents me from doing so.
--
You are receiving this mail because:
You are the assignee for the bug.
