(ORG-8554)
Sample OPJ to download to try: Set Multiple Columns Values.opj
Origin 9.1 allow user to set value of multiple selected columns or columns of whole worksheet, using wcol(j) or cell(i,j) to refer to the columns
To open the Set Multiple Columns dialog, you can
- From the menu, choose
or
- Select multiple contiguous columns
- Right-click on the worksheet column and chooseSet Multiple Column Values from the shortcut menu
Example 1: Set Column B, C and D to be log10 of their original values.
Example 2: Set Whole Sheet2 to be all Values in Sheet1 times 10.