Bug 109178 (Cell-Name) - [META] Named Cell Ranges and Formula Expressions bugs and enhancements
Summary: [META] Named Cell Ranges and Formula Expressions bugs and enhancements
Status: NEW
Alias: Cell-Name
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on: 41915 72594 87058 94627 97967 99052 103711 104990 108516 113680 Excel-Default-Names 131938 134485 137577 145185 145994 156673 160255 163192 165377 165378 40378 64086 64595 64885 66250 67007 67492 75372 81295 81435 94423 108989 109240 113237 113991 114487 123724 148072 157318 160064 162087 164054 164843 164870 164895 165391
Blocks: Calc-Cells Cell-Formula
  Show dependency treegraph
 
Reported: 2017-07-17 20:21 UTC by Thomas Lendo
Modified: 2025-03-19 09:29 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Thomas Lendo 2017-07-17 20:21:06 UTC
Bugs about the Calc feature available with Sheet > Named Ranges and Expressions > Define.
Comment 1 Stéphane Guillou (stragu) 2023-05-02 10:10:32 UTC
Named ranges can also be set and accessed via the Name Box in the Calc formula bar.
https://help.libreoffice.org/7.5/en-US/text/scalc/02/06010000.html
Comment 2 ash 2025-01-15 11:58:26 UTC
(In reply to Stéphane Guillou (stragu) from comment #1)
> Named ranges can also be set and accessed via the Name Box in the Calc
> formula bar.
> https://help.libreoffice.org/7.5/en-US/text/scalc/02/06010000.html

Accessing the Named Range is not the problem.
The problem is defining the Named Range to be multiple cells or groups of cells.
Libre lets you select a Single group of Cells like A3-A9 and assign a hyperlink to that, but will not seem to allow multiple Groups or non consecutive cells to be assigned to a hyperlink. 
Let say you want A2-A5 and B5 and D1 to me assigned to a named range.
When you try to do this the valid formula only seems to allow one cell or consecutive range of cells to be defined.
As I said earlier Excel allows for groups of cells and/or ranges to be defined by the one Named Range. In Excel the formula is something like Sheet1!$A$2:$A$5 ,Sheet1!$B$5,Sheet1!$D$1
Each Cell or group of cells is added to the same Named Range by the formula, by separating them with a comma. The latest Libre update (10,0 build 19045) I just received now excepts the Named Range in the list (where it didn't before) and the replaces the ! with . but the formulas are defined as invalid range I think because Libre does not like more that one range in the formula.
 
In Excel When the Named Ranges is then assigned to a cell using a hyperlink if that cell is clicked on, the Cells Defined i.e A2-A5, B5, and D1 in the sheet1 are all selected (high lighted) if you them press delete those cell locations only are cleared from the sheet.

thanks mate!