3.9.8 Link Notations

Origin provides several cell linking syntax for adding links into worksheet cell, so to easily access or display the linked resource. Available cell linking syntax are included in the following table.

Note that there is also a GUI syntax for linking to worksheet cells (discussed here) but it is not supported in LabTalk script and is not included in the following table.

Syntax Description Example
cell://CellName Insert a link to another cell, given by CellName, so to display its contents in the current worksheet cell. cell://[Book2]Sheet2!Col(B)[3]
range://RangeName [DisplayedText] Insert a link to a range, given by RangeName, which can be book, sheet, column, etc. The contents in the current worksheet cell will show as a link, if clicked, the corresponding range will be activated. If the option DisplayedText is included, the displayed text in the cell is this text, but not the range. range://[Book2]Sheet2!Col(B)[3]
graph://GraphName Insert a link to a graph, given by GraphName, so the graph will be displayed in the current worksheet cell. If double-click on this cell, the corresponding graph window will be activated. graph://Graph1
matrix://MatrixObjectName Insert a link to a matrix object, given by MatrixObjectName, so the matrix object will be displayed in the current worksheet cell, as an image. If double-click on this cell, the corresponding matrix window will be activated. matrix://[MBook1]MSheet1!2
notes://NotesWindowName [DisplayedText] Insert a link to a Notes window, given by NotesWindowName. The contents in this cell will show as a link, if clicked, the corresponding Notes window will be activated. notes://Notes
var://LabTalkVariableName Insert a link to a LabTalk variable, and the value of this variable will show in this cell. var://MyVar
str://LabTalkStringVariable Insert a link to a LabTalk string variable, and this string will show in this cell. str://MyBook$
http://URL [DisplayedText] Insert a live URL into worksheet cells. The link will become active when finishing editing, and the corresponding page will be opened in a web browser if clicked. If the option DisplayedText is included, the displayed text in the cell is this text, but not the URL. http://www.originlab.com
help://HelpPage [DisplayedText] If the option DisplayedText is included, the displayed text in the cell is this text, but not the help link. help://TUTORIAL.CHM/Tutorial/Import_Wizard.html
file://FilePath Insert a link to an image file, given by FilePath. And the linked image will display in the current cell. file://D:\Flower.jpg

Use the cell() function to return information about the type of link (e.g. cell link, variable link, etc.) that is stored in the worksheet cell.