Bugs about the Calc feature available with Sheet > Named Ranges and Expressions > Define.
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
(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!