Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

 (ORG-8554)(star)

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

  1. From the menu, choose Column: Set Multiple Column Values

or

  1. Select multiple contiguous columns
  2. 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.

Image Modified

Image Modified

 

Example 2: Set Whole Sheet2 to be all Values in Sheet1 times 10.

Image Modified