Formula Row in Worksheet and Set Multiple Column Values

 (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

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.

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