https://bugs.documentfoundation.org/show_bug.cgi?id=172782
Bug ID: 172782
Summary: Calc: Formula editor does not highlight cell ranges
referenced via named ranges or named expressions.
Product: LibreOffice
Version: 26.2.4.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When editing a formula in Calc, all directly referenced cells and ranges are
highlighted with coloured borders, making it easy to identify the referenced
cells.
However, if the formula refers only to named ranges (or named expressions that
evaluate to ranges), no highlighting is displayed, even though the underlying
cells are known to Calc.
This results in inconsistent behaviour between direct cell references and named
references.
Steps to Reproduce:
1. Open a new Calc spreadsheet.
2. Enter some values into cells A1.
3. Create a named range called MyRange referring to A1.
4. In another cell, enter the formula: =SUM(MyRange)
5. Click the cell containing the formula.
6. Click in the formula input line (or press F2) to edit the formula.
Actual Results:
No coloured outline is drawn around cells A1.
Expected Results:
The cells belonging to MyRange should be highlighted with the same coloured
outline that would appear if the formula were:
=SUM(A1:A10)
If multiple named ranges are used in the formula, each should receive its own
coloured outline, matching the existing behaviour for multiple direct
references.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Calc already knows how to determine the cells belonging to a named range. For
example:
Sheet → Named Ranges and Expressions → Manage...
selecting a named range displays coloured borders around the referenced cells.
This suggests that the necessary functionality already exists elsewhere in Calc
but is not invoked by the formula editor.
This report is therefore submitted as either:
a usability enhancement, or
a bug due to inconsistent behaviour between direct references and named
references.
Highlighting named ranges during formula editing would significantly improve
the readability and debugging of spreadsheets that make extensive use of named
ranges.
--
You are receiving this mail because:
You are the assignee for the bug.
