Building hyperlinks

using desktop spreadsheet editor on windows 10, xlsx format…
does OO allow me to ‘build’ a url for the hyperlink() function?

ex. (simplified)
=HYPERLINK(A1 & A2, “somename”)

Hello @a_c

I am taking closer look at HYPERLINK function in such cases, I’ll keep you posted.

By the way, you can build clickable link to specific range which is selected after pressing the hyperlink via context menu:

  1. Select a cell you’d like to insert hyperlink;
  2. Right-click it and choose Hyperlink;
  3. In the hyperlink settings switch to Internal data range;
  4. Select required sheet, define range and name;
  5. Press OK to add hyperlink.