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: libreoffice-bugs@lists.freedesktop.org Reporter: eei...@inbox.ru 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.