Origin Ver. 8.5 and Service Release 1(Select Help-->About Origin): Operating System: windows XP
Hi, I have a data plot(s) containing some dataset ... for example
%c=; filtered_U2@2
this tells me the dataset is contained within the worksheet called filtered on the second sheet and in a column headed U2.
All very well however I wish to add a comment to the column's comment field eg "data is filtered"
Is there a simple way to do this using the fact that the dataset is contained within %C and this points to an actual dataset located within a worksheet.
Of course I can strip out all the relevant information and create code to determine the sheet name and relevant column number from the dataset name.. which leads to something like the following code
[filtered]e1u1!col(3)[c]$= "data is filtered";
but I thought there might be a simple way of adding the comment to the column, simply by knowing %c = filtered_U2@2.
I mean filtered_U2@2[c]$= "data is filtered";
for example.. does work but how do I enter the correct substitution using only %c to make it work?
Also.
I can also use a string variable so that activefilterset$=%c; such that activefilterset$=; returns filtered_U2@2
this is in fact my preferred way of dealing with datasets so that I don't loose or confuse which dataset I am manipulating.
You know I tried that before I posted the question and it failed, but now it works... the reason I posted the question is because I thought it should work. Maybe just a temporary bug, it was running a little slow. Perhaps next time I will exit and come back in a try when it is a simple thing.