Set Multiple Column Values

Owned by Echo Chu
Last updated: Nov 07, 2017 by Wall-E
1 min read

 (ORG-8554)(star)

 

Origin 9.1 allows you to set value of multiple selected columns or columns. Support has also been added for use of column index "j", allowing notation such as wcol(j) or cell(i,j) to refer to 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 choose Set 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.