https://bugs.documentfoundation.org/show_bug.cgi?id=164843
Bug ID: 164843
Summary: Relative reference in managed names dialog gives #REF
error, slow deleting of ranges on Windows
Product: LibreOffice
Version: 3.5.0 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 198735
--> https://bugs.documentfoundation.org/attachment.cgi?id=198735&action=edit
Example file from Calc
Attached document contains a relative reference to a named range. This is
according to the ODF standards
https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part3-schema/OpenDocument-v1.3-os-part3-schema.html#__RefHeading__1418280_253892949
"19.590 table:base-cell-address" part.
In the Navigator, clicking on the name gives "Invalid range" error.
When opened, in the Manage Names dialog the relative part gives a #REF! error.
Under Windows, deleting another named range in the Manage Names dialog gives a
wait time of 2-3 minutes after pressing OK.
1. Open attached document
2. In the Navigator under Range names click on the "testrange" name.
-> an information popup shows, telling you "Invalid range"
This seems to have been started between 7.2 and 7.3
3. Navigate to the AC2000 cell, click again in the Navigator under Range names
on the "testrange" name.
-> The range AC2:AC2000 is selected correctly
4. Open the Manage Names dialog (press Ctrl-F3)
-> the "Range or formula expression" of the testrange name is
"$Sheet1.$AC#REF!:$AC$2000"
This seems to have started between 3.4 and 3.5, likely not well bibisectable.
5. (Windows only) In the Manage Names dialog delete the "dummy_delete" range
and press OK
-> Calc does not respond for 2-3 minutes and uses 100% CPU.
This seems to have started between 4.4 and 5.0 with some seemingly unrelated
refactorings
Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 47e110fc66292e76152252a90a0e20580c33c13d
CPU threads: 14; OS: Windows 10 X86_64 (build 19045); UI render: default; VCL:
win
Locale: hu-HU (hu_HU); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
