So say for example you placed a button on the worksheet, your associated script can follow this simple example (assuming the worksheet in question is the active worksheet):

col(5)=col(3)/col(4);

col(temp)=col(temp2)*col(temp3);

or including other worksheets...

col(4)=data1_b*col(1);

Here's another example using the document command:

doc -e D {%C/=100;};

Information on creating buttons can be found on page 714 of the Origin 6.0 User's manual. Information on User defined toolbar buttons can be found on page 722 of the Origin 6.0 User's Manual.

test=wks.ncols;

loop(ii,1,test){
%(%H,ii)=-8*%(%H,ii);
}

doc -e s {

if (%[%C,'_']=="Data1") {"%c"=2*%c;};

}

This will execute your doubling routine only over the datasets of the worksheet 'Data1'.

doc -e s { "%c"=2*%c; };

should double the value of every dataset in the current project (not only one worksheet). See the Origin Manual or help file to read about this 'document' command.

This is not exactly what you want, but can help.

j.

doc -e s {

if (%[%C,'_']=="Data1") {

sum(%c);
type Maximum of %c: $(sum.max);
"%c"=%c/sum.max;

}
}

you second script, doc -e D {%C*(-8);};, is what I was looking for; but the Origin Manual sais that that -e D option for the document command works for "data plot in the active layer", and I did not expect it to work with a worksheet. After your suggestion I tried it, and it does! So my previous ideas using -e S, restricting it to a worksheet with an if condition, are not really necessary.

j.

P.S. This is not the first time that I find something of this kind: a bad description of a command or an option in the Origin Manual/Help File. If this -e D option, for instance, makes the command act over both worksheets and plots, it should be specified. Otherwise the user begins to think on how to combine the other options to get what he/she wants, as it was my case...