Origin Ver. OriginPro 2018 (64bit) and Service Release 1 Operating System: Windows 10.
Good morning,
I have a worksheet with 2 columns (respectively X and Y). I want to do the integral of the function and memorize the value of the area. In the first cell of another column, I want to report the value of the area.
This is my code:
double integ_area; integ1 iy:=[Book1]1!(A,B) area:=integ_area -r 1; // output in col(C) wks.addcol(); // col D csetvalue col:=col(D)[1] formula:="integ_area" recalculate:=1;
The problem is when I change a value of column B (and therefore the value of the area), because the value of column D is not updated. And indeed, in column D there is no green lock at the top left.
I would have another small question. I have to copy a column to another workbook. In the column there are some masked values and I do not want to copy them.
I used the function colcopy -r 1 irng:= [Book1]1!1 orng:= [Book2]2!1 mask:= 0;
But I get the following error: Error: can not find a (unique) variable corresponding to mask.
Copy Mask control is a new feature of Origin 2018b. It seems that you are still using an older version, right? Please upgrade your Origin to the latest version Origin 2019, then it should works fine.
Set cell value automatically
Posted - 12/04/2018 : 06:11:01 AM
