Difference between revisions of "Manuals/calci/HYPERLINK"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
=HYPERLINK(link_loc, name)= | =HYPERLINK(link_loc, name)= | ||
| − | *where | + | *where '''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. | HYPERLINK() creates a shortcut that opens a document stored on a network server. | ||
| 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. | *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. | ||
| − | * | + | *'''link_loc''' can be a text string enclosed in quotation marks or a cell that contains the link as a text string. |
| − | * | + | *'''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. | *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. | |
| − | * | ||
== Examples == | == Examples == | ||
| Line 26: | Line 24: | ||
| class="sshl_f" |C:\Profile\My_Profile My_Profile | | class="sshl_f" |C:\Profile\My_Profile My_Profile | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | + | ||
|- class="odd" | |- class="odd" | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | | class=" | + | | class=" " | |
| − | | class=" | + | | class=" " | |
| − | + | ||
|- class="even" | |- class="even" | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| + | | class=" " | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | | class=" | + | | class=" " | |
| − | + | ||
| − | |||
|- class="odd" | |- class="odd" | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | | class=" | + | | class=" " | |
| − | | class=" | + | | class=" " | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| class="sshl_f" | | | class="sshl_f" | | ||
|} | |} | ||
Revision as of 12:54, 20 December 2013
HYPERLINK(link_loc, name)
- where 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.
Description
- 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.
- link_loc can be a text string enclosed in quotation marks or a cell that contains the link as a text string.
- 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.
Examples
| 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")