| T O P I C R E V I E W |
| nmack536 |
Posted - 05/17/2013 : 09:38:38 AM
Origin Ver. and Service Release (Select Help-->About Origin): 8.6
Operating System: Windows
Hello, I am new to using Origin and I am trying to figure out something that seemed simple enough at first. I have data that import several curves where each curve is in its own sheet. I then import another file that has the long names for each of the curves i previously imported saved in a column.
I want to set the long name of each curve to the corresponding value in the sheet that contains them. I can't seem to get it to work. I know how to set a variable to equal the value in a cell, and i know how to change the long name of a column using wks.col2.label$ but when i set it to equal the variable it sets the long name to the variable name not the variable value.
Hope this makes sense. Any help would be appreciated.
Thank you. |
| 2 L A T E S T R E P L I E S (Newest First) |
| snowli |
Posted - 05/17/2013 : 6:04:40 PM
Hello,
If you copy the long name cell and then go to the long name cell of the curve sheet. Right click and choose Paste Link.
It works too.
And you can see cell://Sheet2!A[2] syntax is used.
So u can also do
col(2)[L]$="cell://Sheet2!A[2]" in Script window.
Thanks, Snow |
| Drbobshepherd |
Posted - 05/17/2013 : 10:36:22 AM
The wks.colX.label$ structure is legacy; it was developed before the column labels were expanded.
Try
col(2)[L]$=col(1)[3]$; // Set Longname of col(2) to string in col(1), row(3).
This newer way to assign values to column labels is similar to the command for assigning values to cells,
col(2)[1]=col(1)[4]; // Set col(2), row(1) to value in col(1), row(4).
DrBobShepherd |
|
|
