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.
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 |