Ask Your Question

Spreadsheet hyperlink to tab

asked 2015-03-16 21:51:52 +0200

Toon gravatar image

Hello! I have a huge spreadsheet with many tabs. Jn the first tab there is table of contents with hyperlinks formulas for each tab:

=HYPERLINK("#"&"'Tab Name'!A1"; "Tab Title")

On click it redirects me to the certain tab in the same document. It works fine in MS Excel 2013, but LibreOffice send me alert:

LibreOffice could not find a web browser on your system. Please check your Desktop Preferences or install a web browser (for example, Firefox) in the default location requested during the browser installation.

What's wrong? How to fix this problem?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-03-16 22:43:42 +0200

m.a.riosv gravatar image

I think the issue is the separator between sheet name and address "!",

First option)
Change Menu/Tools/Options/LibreOffice/Formula/Formula options/Formula syntax -> Excel A1.

Or with formulas like:

a) =HYPERLINK("#"&MID(CELL("address";'Tab Title'.A1);2;99);"Tab Title")

b) =HYPERLINK("#"&ADDRESS(1;1;1;1;"'Tab Title'");"Tab Title")

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-03-16 21:51:52 +0200

Seen: 1,735 times

Last updated: Mar 16 '15