- Select the first column by clicking on its title label
- Right click and invoke the "Set Values" dialog box
- Click on the little arrow to the bottom right (called "Show Scripts")
- In the "Before Formula Scripts" text box, type in the following
// Get index of current column

const nn = _ThisColNum;

// Perform numerical operations on this column

wcol(nn) /= 10; - Click apply
- Select the formula and copy it (Ctrl + c)
- Now go to the next column by clicking on the Next Column button (or simply selecting another column)
- Paste the formula (Ctrl + v) and click apply

I do this for all the columns. This process is very fast if you have a good handle on using the keyboard.

Cite as:

Saad, T. "Set Column Values in Origin".
Weblog entry from
Please Make A Note.
http://pleasemakeanote.blogspot.com/2008/05/set-column-values-in-origin.html

Excellent thanks for this, I really enjoyed this lesson.

ReplyDeleteThis is perfect but I want to know what happens if in that formula I get something related to Cheap Viagra Online, because a friend of mine told me that and I was so confused.

ReplyDelete