Difference between revisions of "Manuals/calci/HYPERLINK"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''HYPERLINK'''</font></font></font><font color="#4...") |
|||
| (14 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''HYPERLINK (URL,Name)'''</div><br/> |
| − | + | *where '''URL''' is the path of the document or file | |
| + | *'''Name''' is the name of the document or file to open. | ||
| + | **HYPERLINK(), creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet. | ||
| − | + | == 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. |
| + | *'''URL''' can be a text string enclosed in quotation marks or a cell that contains the link as a text string. | ||
| + | *'''URL''' 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 == | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
<div id="4SpaceContent" class="zcontent" align="left"> | <div id="4SpaceContent" class="zcontent" align="left"> | ||
| − | {| id=" | + | {| id="TABLE2" class="SpreadSheet blue" |
|- class="even" | |- class="even" | ||
| + | | class="sshl_f" | [http://www.google.com/ Click Here] | ||
| class=" " | | | class=" " | | ||
| − | + | | class=" " | | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | class=" " | | ||
| class=" " | | | class=" " | | ||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f" | | |
| − | |||
| − | | class=" " | | ||
| class=" " | | | class=" " | | ||
| + | | class=" " | | ||
| class=" " | | | class=" " | | ||
|- class="even" | |- class="even" | ||
| − | + | | class="sshl_f" | C:\Profile\My_Profile.doc | |
| − | |||
| − | | class=" " | | ||
| class=" " | | | class=" " | | ||
| + | | class=" " | | ||
| class=" " | | | class=" " | | ||
|- class="odd" | |- class="odd" | ||
| − | | class=" " | | + | | class="sshl_f" | |
| class=" " | | | class=" " | | ||
| + | | class=" " | | ||
| class=" " | | | class=" " | | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
| − | + | 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") | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|ZLelEYv6yPE|280|center|HYPERLINK}} | ||
| + | |||
| + | == See Also == | ||
| + | |||
| + | *[[Manuals/calci/ADDRESS |ADDRESS ]] | ||
| + | |||
| + | == Reference == | ||
| + | |||
| + | *[http://en.wikipedia.org/wiki/Hyperlink Hyperlink] | ||
| + | |||
| + | |||
| + | |||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 12:47, 23 August 2018
HYPERLINK (URL,Name)
- where URL is the path of the document or file
- Name is the name of the document or file to open.
- HYPERLINK(), creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet.
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.
- URL can be a text string enclosed in quotation marks or a cell that contains the link as a text string.
- URL 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.doc | |||
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")
Related Videos
See Also
Reference