quote:
Originally posted by dominik.mierzwa
Origin Ver. and Service Release (Select Help-->About Origin):
Operating System:
Hi,
Is it possible to use cell value (for example A1) as a worksheet name in the link? For example, I have the link:
cell://[CV]FitNL1!Summary.R1.Stats_AdjRSquare
But the worksheet names are (in this case CV given in column A. Can I rewrite this link it this way that it will take the worksheet name from the cells of column A?
Kind regards,
Dominik
Cell formula works: https://www.originlab.com/doc/Origin-Help/Using-Formulae-to-Set-Cell-Values
Say, you have
1) Book2 in [Book1]Sheet1!A1
2) qwert in [Book2]Sheet1!A1
3) 3.14 in [Book2]Sheet1!A2
To link the cell [Book1]Sheet1!B1 to [Book2]Sheet1!A1 =[%(col(A)[1]$)]Sheet1!A1$
To link the cell [Book1]Sheet1!B2 to [Book2]Sheet1!A2 =[%(col(A)[1]$)]Sheet1!A2
However, the following do not work as expected (quite confusing, may be a bug/drawback):
=[%(col(A)[1]$)]Sheet1!col(A)[1]$
=[%(A1$)]Sheet1!A1$
=[%(A1$)]Sheet1!col(A)[1]$
=[%(col(A)[1]$)]Sheet1!col(A)[2]
=[%(A1$)]Sheet1!A2
=[%(A1$)]Sheet1!col(A)[2]
░░▄▀░░░░░░░░░░░░░░░▀▀▄▄░░░░░
░░▄▀░░░░░░░░░░░░░░░░░░░░▀▄░░░
░▄▀░░░░░░░░░░░░░░░░░░░░░░░█░░
░█░░░░░░░░░░░░░░░░░░░░░░░░░█░
▐░░░░░░░░░░░░░░░░░░░░░░░░░░░█
█░░░░▀▀▄▄▄▄░░░▄▌░░░░░░░░░░░░▐
▌░░░░░▌░░▀▀█▀▀░░░▄▄░░░░░░░▌░▐
▌░░░░░░▀▀▀▀░░░░░░▌░▀██▄▄▄▀░░▐
▌░░░░░░░░░░░░░░░░░▀▄▄▄▄▀░░░▄▌
▐░░░░▐░░░░░░░░░░░░░░░░░░░░▄▀░
░█░░░▌░░▌▀▀▀▄▄▄▄░░░░░░░░░▄▀░░
░░█░░▀░░░░░░░░░░▀▌░░▌░░░█░░░░
░░░▀▄░░░░░░░░░░░░░▄▀░░▄▀░░░░░
░░░░░▀▄▄▄░░░░░░░░░▄▄▀▀░░░░░░░
░░░░░░░░▐▌▀▀▀▀▀▀▀▀░░░░░░░░░░░
░░░░░░░░█░░░░░░░░░░░░░░░░░░░░
░░╔═╗╔═╗╔═╗░░░░░║░║╔═╗║░║░░░░
░░╠═╣╠╦╝╠╣░░░░░░╚╦╝║░║║░║░░░░
░░║░║║╚═╚═╝░░░░░░║░╚═╝╚═╝░░░░
║╔═░╦░╦═╗╦═╗╦╔╗║╔═╗░░╔╦╗╔═╗╔╗
╠╩╗░║░║░║║░║║║║║║═╗░░║║║╠╣░╔╝
║░╚░╩░╩═╝╩═╝╩║╚╝╚═╝░░║║║╚═╝▄░
