https://bugs.documentfoundation.org/show_bug.cgi?id=164054
--- Comment #1 from ash <[email protected]> --- Sorry I just realized that I said create a button but in fact it is just a cell that contains a hyperlink not a button (buttons I think are limited to macros). Create the named range and assign it to a hyperlink in a cell. eg Excel steps are. Select multiple groups of cells in a sheet. Give it a name using formula > define name functions. (In Excel the Refers to: field when defining the name lists all the groups of cells select in the sheet separated by commas like below.) ie =Sheet1!$A$5:$B$5,Sheet1!$C$7:$C$10,Sheet1!$D$4:$F$4 (Libre only lists the cells last clicked on in the sheet even though multiple are selected.) Select another cell in the sheet to become a function to select the chosen cells. Next add a hyperlink using Insert > hyperlink > Place in this document > defined Name above. When the cell with the hyperlink is selected the groups of cells are highlighted giving the user the chance to delete the contents of the highlighted cell. This is a quick and easy to selectively delete cells in a sheet ready for new data. I hope this explains better what I was doing with Excel I cannot do with Libre. Lib -- You are receiving this mail because: You are the assignee for the bug.
