Revision as of 12:36, 20 December 2013

HYPERLINK(link_loc, name)

where Failed to parse (syntax error): {\displaystyle link _loc} is the path of the document or file
$name$ is the name of the document or file to open.

HYPERLINK() creates a shortcut that opens a document stored on a network server.

A hyperlink is a reference that points to data or a document. By clicking on the cell that contains HYPERLINK function, Calci opens the specified document.
Failed to parse (syntax error): {\displaystyle link _loc} can be a text string enclosed in quotation marks or a cell that contains the link as a text string.
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle link _loc} can be a reference to a word document, a spreadsheet, any image on server or internet etc.

If the jump location specified in the argument does not exist or cannot be navigated, Calci displays an error.

$name$ is the text or a numeric value. If $name$ is omitted, the link location is displayed as jump text.

Click Here		C:\Profile\My_Profile My_Profile

HYPERLINK can be used in following ways -

1)To open a Google website from Calci spreadsheet, following command can be used -

=HYPERLINK("http://www.google.com","Click here")

2)To open a Microsoft word document "My_Profile" stored on C drive of computer, following command can be used -

=HYPERLINK("C:\Profile\My_profile.doc","My_Profile")

@@ Line 1: / Line 1: @@
 =HYPERLINK(link_loc, name)=
-*where <math>link&#95;loc</math> is the path of the document or file
+*where <math>link &#95;loc</math> is the path of the document or file
 *<math>name</math> is the name of the document or file to open.
@@ Line 9: / Line 9: @@
 *A hyperlink is a reference that points to data or a document. By clicking on the cell that contains HYPERLINK function, Calci opens the specified document.
-*<math>link&#95;location</math> can be a text string enclosed in quotation marks or a cell that contains the link as a text string.
+*<math>link &#95;loc</math> can be a text string enclosed in quotation marks or a cell that contains the link as a text string.
-*<math>link&#95;location</math> can be a reference to a word document, a spreadsheet, any image on server or internet etc.
+*<math>link &#95;loc</math> can be a reference to a word document, a spreadsheet, any image on server or internet etc.
 *If the jump location specified in the argument does not exist or cannot be navigated, Calci displays an error.