https://bugs.documentfoundation.org/show_bug.cgi?id=165391
Bug ID: 165391
Summary: Named columns or named cell ranges references in
formulas do not get colored border highlights in
formula and spreadsheet canvas
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 199388
--> https://bugs.documentfoundation.org/attachment.cgi?id=199388&action=edit
Sample spreadsheet for easy testing
Please use the attached sample document I created to easily reproduce the
problem.
Using named ranges of cells or whole columns (such as "amounts_column" and
"taxes_column" or "amounts_cells" and "taxes_cells"), if you reference them in
a formula, LibreOffice 25.2.0.3 and older cannot highlight those ranges with a
color code in the formula and in the spreadsheet, unlike if you were manually
referencing the cells (ex: $A:$A, or $A2:$A5).
Demonstration video also included for your convenience to see exactly how to
test it, showing which parts work and which parts don't work.
----------
Tested on:
Version: 25.2.0.3 (X86_64) / LibreOffice Community
Build ID: e1cf4a87eb02d755bce1a01209907ea5ddc8f069
CPU threads: 8; OS: Linux 6.12; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Flatpak
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
