Although it is too late to reply to this, I am posting the script I have written to move columns in the worksheet, together with the labels and values. Maybe it will be useful for people searching the archives like I have done.
The script is manipulating the columns to arrange them in the reverse order into worksheet i.e. columns A to Z will be re-arranged Z to A. Additionally, one can keep the first column fixed as this is in general storing the independent variable. It goes like this:
aa=wks.ncols; // read the total number od columns in the active woks
//type $(aa); // check how many columns u have in the worksheet
for(ii=aa-1; ii>1; ii--) // make the variable to decrease
{
wks.colsel($(ii),1); // select columns one by one starting with the aa-1 (if aa-th column should be in front,
//all the others will have to move relative to this one)
// ii==2 or ii>1 is the condition to stop before applying the script to the first column in the wks
menu -e 38773 ; // this is the menu command to move a selected column to the end of wks
wks.colsel($(aa),0); // unselect the column that was just moved to be able to select a new one at the next iteration
}
// apply the script twice to undo the operation
Labtalk and Columns moving
Posted - 01/30/2005 : 1:12:45 PM
