https://bugs.documentfoundation.org/show_bug.cgi?id=145077
Bug ID: 145077
Summary: [Calc] Highlighting a named range does not work
correctly
Product: LibreOffice
Version: 7.2.0.4 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Selecting an appropriate range name in the “Name Box” that belongs to the
active sheet does not correctly highlight the range. Does not work. But it
should (works correctly in Excel). All ranges are configured using mixed
references, which must be calculated relative to the active cell. But when you
open the “Manage Names” dialog, all references are calculated correctly. And
why is it not selected when necessary? Try it yourself.
File attached
Select the ranges of the active sheet from the “Name Box”, for example: Players
(selects the first row correctly), Points (selects the wrong range, not the
current row but again the first row), Winners (selects the wrong range).
Steps to Reproduce:
1. As described
2.
3.
Actual Results:
When we use relative row numbers, there is no fixed range to jump to.
Expected Results:
It works in Excel, but in Calc it don't.
But it is calculated correctly in the “Manage Names” window. Jump!
Reproducible: Always
User Profile Reset: No
Additional Info:
Link to discussion on Ask:
https://ask.libreoffice.org/t/highlighting-a-named-range-does-not-work-correctly/69146
--
You are receiving this mail because:
You are the assignee for the bug.
