| Author |
 Topic  |
|
|
AKazak
Russia
1205 Posts |
 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 |
|
|
AmandaLu
439 Posts |
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
|
 |
|
|
AKazak
Russia
1205 Posts |
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
439 Posts |
Posted - 06/06/2022 : 06:21:31 AM
|
Hi,
Please right click on the graph object and select Properteis
 |
|
|
|
AKazak
Russia
1205 Posts |
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
439 Posts |
Posted - 06/06/2022 : 06:49:36 AM
|
Hi,
Please remove “\” at the beginning.
 |
|
|
|
AKazak
Russia
1205 Posts |
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 |
Edited by - AKazak on 06/06/2022 06:55:54 AM |
|
|
|
AmandaLu
439 Posts |
Posted - 06/06/2022 : 07:05:00 AM
|
Hi,
What’s the content in [Data4Graph]Summary!G[1]? Value? Graph? Image? Arrow?
|
|
|
|
AKazak
Russia
1205 Posts |
|
|
AKazak
Russia
1205 Posts |
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 |
|
|
|
AmandaLu
439 Posts |
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
|
Edited by - AmandaLu on 06/06/2022 10:51:27 PM |
|
|
|
AKazak
Russia
1205 Posts |
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 |
|
|
|
minimax
348 Posts |
|
|
AKazak
Russia
1205 Posts |
|
| |
Topic |
|
Show contents from other cells in graph text/table