| T O P I C R E V I E W |
| AKazak |
Posted - 06/06/2022 : 05:31:59 AM
OriginPro 2022b (64-bit) SR1 9.9.5.167
Windows 7 Pro SP1 x64
Greetings!
I follow https://www.originlab.com/doc/Origin-Help/InsLink-to-WksCell and find that the following syntax does not work in graph text objects and text tables:
cell://col(A)[1]
cell://A[1]
How do I effectively show contents from other cells in graph text/table along with my custom text?
Thank you.
---
Andrey |
| 13 L A T E S T R E P L I E S (Newest First) |
| AKazak |
Posted - 06/07/2022 : 02:24:24 AM
quote:
Originally posted by minimax
see link below for details:
https://www.originlab.com/doc/Origin-Help/LinkVar-TextLabel
Got it.
Thanks.
---
Andrey |
| minimax |
Posted - 06/07/2022 : 02:01:55 AM
see link below for details:
https://www.originlab.com/doc/Origin-Help/LinkVar-TextLabel |
| AKazak |
Posted - 06/07/2022 : 12:41:54 AM
quote:
Originally posted by AmandaLu
Hi,
\Cell notation is only used for embedded graph or image. For numeric, please use %, something like
%([Book2]SheetB,@WL,A[1], W)
Thanks,
Amanda
OriginLab Technical Service
Nice trick!
Thanks.
It is worth adding the tip to Origin help.
---
Andrey |
| AmandaLu |
Posted - 06/06/2022 : 10:10:04 PM
Hi,
\Cell notation is only used for embedded graph or image. For numeric, please use %, something like
%([Book2]SheetB,@WL,A[1], W)
Thanks,
Amanda
OriginLab Technical Service
|
| AKazak |
Posted - 06/06/2022 : 07:10:26 AM
quote:
Originally posted by AmandaLu
Hi,
What’s the content in [Data4Graph]Summary!G[1]? Value? Graph? Image? Arrow?
Numeric value is in in [Data4Graph]Summary!G[1].
---
Andrey |
| AKazak |
Posted - 06/06/2022 : 07:06:02 AM
Some useful references on the topic:
https://www.originlab.com/doc/Origin-Help/InsLink-to-WksCell
https://www.originlab.com/doc/en/Origin-Help/Ob-Prop-Program-tab#The_Link_to_.28.25.2C.24.29.2C_Substitution_Level_Drop-down_List
https://www.originlab.com/doc/en/LabTalk/guide/Substitution-Notation
---
Andrey |
| AmandaLu |
Posted - 06/06/2022 : 07:05:00 AM
Hi,
What’s the content in [Data4Graph]Summary!G[1]? Value? Graph? Image? Arrow?
|
| AKazak |
Posted - 06/06/2022 : 06:55:38 AM
quote:
Originally posted by AmandaLu
Hi,
Please remove “\” at the beginning.
Done, but see a blank square:
---
Andrey |
| AmandaLu |
Posted - 06/06/2022 : 06:49:36 AM
Hi,
Please remove “\” at the beginning.
 |
| AKazak |
Posted - 06/06/2022 : 06:26:55 AM
quote:
Originally posted by AmandaLu
Hi,
Please right click on the graph object and select Properteis
I set the substitution level 1, but the following syntax still doesn't work in the text object:
cell://[Data4Graph]Summary!G[1]
---
Andrey |
| AmandaLu |
Posted - 06/06/2022 : 06:21:31 AM
Hi,
Please right click on the graph object and select Properteis
|
| AKazak |
Posted - 06/06/2022 : 05:49:28 AM
quote:
Originally posted by AmandaLu
Hi,
If you copy col(A)[1] and paste link to the graph text object (in the in-place edit mode, right click and select Paste Link), you can see the syntax.
Thanks,
Amanda
OriginLab Technical Service
Dear Amanda,
I did as you suggested but got a table with the following syntax:
cell://[Data4Graph]Summary!G[1]
However this is not as was promised in https://www.originlab.com/doc/Origin-Help/InsLink-to-WksCell.
Besides if I paste the line above in a text object, then the substitution does not work.
How do I show cell values in a text object?
I ask since graph tables support almost no formatting (bold, italic, etc.).
---
Andrey |
| AmandaLu |
Posted - 06/06/2022 : 05:43:13 AM
Hi,
If you copy col(A)[1] and paste link to the graph text object (in the in-place edit mode, right click and select Paste Link), you can see the syntax.
Thanks,
Amanda
OriginLab Technical Service
|
