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.

...

 

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 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 choose Set Multiple Column Values from the shortcut menu


Example 1: Set Column B, C and D to be log10 of their original values.

Image Removed

...

Image Added    Image Added

 

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

Image Added