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. If clicked, sheet 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] range://[%H]1! %([%H]1!wks.name$)
graph://GraphName Insert a link to a graph, given by GraphName, so the graph will be displayed in the current worksheet cell. If double-clicked, the corresponding graph window will be activated. graph://Graph1
matrix://[MatrixBookName]MatrixSheetName!
MatrixObjectNumber
Insert a link to a matrixbook, a matrixsheet or a matrix object so the matrix object will be displayed in the current worksheet cell, as an image. If double-clicked , the corresponding matrix window, sheet or object 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, or combined literal and string variable. The string will show in this cell. str://MyBook$, str://%G, or combined literal and strings by str://Summary on %([%H]1!wks.name$) of %(MyBook$) in %G
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 Homepage
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
  1. To edit the link, press and hold down the mouse button for more than 1 sec. and then release the mouse.
  2. Substitution notation applies to all displayed text. For example, if a string variable str$ is set to "TEXT", using %(str$) will show the content of str$. http://www.originlab.com %(str$) displays as a hyperlink named TEXT in cell.
  3. 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.

Related Topics