...
(ORG-8554)
Select Multiple contiguous columns and choose Set Multiple Column Values context menu.
Use
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 selected columns, e.g.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.