OriginLab Corporation - Data Analysis and Graphing Software - 2D graphs, 3D graphs, Contour Plots, Statistical Charts, Data Exploration, Statistics, Curve Fitting, Signal Processing, and Peak Analysis                     
 

2.67 FAQ-692 How to set values of a cell or a subrange?


Last Update: 12/7/2018

Origin 2018 and on supports cell formula. You can define cell formula like Excel and then drag to fill similar formula for a subrange.This is also supported in user-defined parameter rows.

Set subrange formula.gif


In older versions, to set values for a subrange of a column or multiple columns, you can select the subrange, right-click and select Set Column Values or Set Multiple Column Values. Use the range/column controls at the top of the dialog box to specify the subrange and for calculating the formula entered in the column formula edit box.

Set Values subrange.png

Please refer to the Set Values dialog documentation for details.

Minimum Origin Version Required: 9.1 SR0


Keywords:Set Values dialog, Column Browser,

 

© OriginLab Corporation. All rights reserved.