Origin Ver. and Service Release (Select Help-->About Origin): 2018b Operating System: Windows 10
Hello,
Is there any way to sort dataplots? Sort command only works with workshets, but I would need to sort dataplots which were created in the wrong order.
I have between 2 and 5 dataplots I need to order alphabetically, all of them pertaining to a group. There are other dataplots outside that group which do not need sorting.
The discrepancy between the creation order and desired sorting lies in a number inside the dataset names; i.e. names have numbers like 235, 56, 766, 98... creation order follows the first digit only (235-56-766-98), while desired order would be 26-98-235-766. The numbers are only part of the names, although they share the same prefix.
Is there any solution for this, either changing dataplot sorting order or changing creation order?
You can use a piece of Labtalk Script to control the plotting order. The script reads and sorts the column longnames by value, then plot columns with sorted order.
string bkname$ = %H;
dataset dsln, dslnsorted;
for (i = 2; i <= wks.ncols; i++)
{
wks.col=i;
dsln[i-1] = numbervalue(wks.col.lname$);
}
dslnsorted = sort(dsln);
for ( i = 1; i <= dslnsorted.GetSize(); i++)
{
ln = dslnsorted[i];
//type $(ln);
range r1 = [bkname$]1!"$(ln)";
plotxy iy:=r1 plot:=200 ogl:=1;
}
layer -g;
The thing is, I'm plotting the same worksheet from different workbooks. I mean, what I should change is the workbook reading order. I could perhaps isolate the numbers within the workbook name in a string, so that I could type a command to sort them using that string, but I don't know how to actually order Origin to read workbooks in that order.
Sort dataplots in a group inside a graph layer
Posted - 08/26/2020 : 09:09:51 AM
