View source for Documentation/How Tos/Calc: HYPERLINK function

From Apache OpenOffice Wiki

← Documentation/How Tos/Calc: HYPERLINK function

You do not have permission to edit this page, for the following reasons:

• The action you have requested is limited to users in the group: Users.
• You must confirm your email address before editing pages. Please set and validate your email address through your user preferences.

---

You can view and copy the source of this page:

{{DISPLAYTITLE:HYPERLINK function}} {{Documentation/CalcFunc SpreadsheetTOC |ShowPrevNext=block |PrevPage=Documentation/How_Tos/Calc:_DDE_function |NextPage=Documentation/How_Tos/Calc:_STYLE_function }}__NOTOC__ == HYPERLINK == Sets a cell to open a hyperlink (in another application) when clicked. === Syntax: === <tt>'''HYPERLINK(linkaddress; celltext)'''</tt> : A cell containing a <tt>'''HYPERLINK'''</tt> function will open a hyperlink when the cell is clicked. : <tt>'''linkaddress'''</tt> is the address (as text) that is opened. <tt>'''celltext'''</tt> is the text displayed in the cell. If <tt>'''celltext'''</tt> is omitted, <tt>'''linkaddress'''</tt> is displayed in the cell. : To edit a hyperlinked cell, select a nearby cell, and navigate to the hyperlinked cell using the keyboard arrows (if you click directly, it will open the hyperlink). : For common, straightforward usage of <tt>'''HYPERLINK'''</tt>, see the [[#Example:|Example section]]. : If you need a fuller explanation of the unique way in which <tt>'''HYPERLINK'''</tt> works, it follows now: :: If a cell contains a <tt>'''HYPERLINK'''</tt> function (even if the <tt>'''HYPERLINK'''</tt> function is not evaluated): :: 1. that cell becomes a hyperlinked cell; that is, if you click on it, it will attempt to open a page in a browser window. ::: For example, in a cell with <br /><tt>'''=IF(TRUE(); "some text"; HYPERLINK("<nowiki>http://www.example.com</nowiki>"))'''</tt> <br />the <tt>'''HYPERLINK'''</tt> function is never evaluated - but nevertheless the cell becomes a hyperlinked cell (although the link will fail - see 2. below). :: 2. the <u>formula</u> in the cell is evaluated '''twice'''. ::: i) The first time, any <tt>'''HYPERLINK'''</tt> function returns <tt>'''linkaddress'''</tt>, and the result of the formula becomes the address to link to. ::: ii) The second time, any <tt>'''HYPERLINK'''</tt> function returns <tt>'''celltext'''</tt> (or <tt>'''linkaddress'''</tt> if no <tt>'''celltext'''</tt> is given), and the result of the formula is displayed in the cell. ::: For example, <br /><tt>'''= "h" & HYPERLINK("ttps://"; "ot ") & HYPERLINK("<nowiki>www.example.com</nowiki>"; "link")'''</tt> evaluates twice. The first time <tt>'''"h"'''</tt> & <tt>'''"ttps://"'''</tt> & <tt>'''"<nowiki>www.example.com</nowiki>"'''</tt> are concatenated to form <tt>'''"<nowiki>http://www.example.com</nowiki>"'''</tt> - the address to link to. The second time <tt>'''"h"'''</tt> & <tt>'''"ot "'''</tt> & <tt>'''"link"'''</tt> are concatenated to form <tt>'''"hot link"'''</tt> - the text that appears in the cell. ::: For example, <br /> <tt>'''= "h" & HYPERLINK("ttps://"; "ere is ") & HYPERLINK("www.example.com")'''</tt> evaluates firstly to concatenate <tt>'''"h"'''</tt> & <tt>'''"ttps://"'''</tt> & <tt>'''"www.example.com"'''</tt>, forming <tt>'''"<nowiki>http://www.example.com</nowiki>"'''</tt> - the address to link to, and secondly to concatenate <tt>'''"h"'''</tt> & <tt>'''"ere is "'''</tt> & <tt>'''"www.example.com"'''</tt>, forming <tt>'''"here is <nowiki>www.example.com</nowiki>"'''</tt> - the text that appears in the cell. :: 3. If any error is returned, the cell ceases to be a hyperlinked cell. : The examples above illustrate how <tt>'''HYPERLINK'''</tt> works - but '''not''' how it should be used. === Example: === <tt>'''=HYPERLINK("<nowiki>https://www.example.org</nowiki>")'''</tt> : displays <tt>'''<nowiki>https://www.example.org</nowiki>'''</tt> in the cell and opens the hyperlink <tt>'''<nowiki>https://www.example.org</nowiki>'''</tt> when clicked. <tt>'''=HYPERLINK("<nowiki>https://www.example.org</nowiki>"; "Click here")'''</tt> : displays <tt>'''Click here'''</tt> in the cell and opens the hyperlink <tt>'''<nowiki>https://www.example.org</nowiki>'''</tt> when clicked. <tt>'''=HYPERLINK("<nowiki>https://www.</nowiki>"; "Click ") & "example.org"'''</tt> : displays <tt>'''Click example.org'''</tt> in the cell and opens the hyperlink <tt>'''<nowiki>https://www.example.org</nowiki>'''</tt> when clicked. === Issues: === * Text rotated through 90 degrees may not be clickable ({{bug|74471}}). * The mouse pointer may not revert after leaving the "Format Cells" dialog ({{bug|74490}}). {{SeeAlso|EN| * [[Documentation/How_Tos/Calc: Spreadsheet functions|Spreadsheet functions]] * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} [[Category: Documentation/Reference/Calc/Spreadsheet functions]]

Return to Documentation/How Tos/Calc: HYPERLINK function.