I am using 'Column --> Set column values...' to set the values in column B using the values in column A and a variable which has previously been defined in the command window. When I select 'recalculate: auto', column B is only updated if column A changes but not if I change the variable. The same is the case if use 'recalculate: manual' and click the 'recalculate' button.
Is there a way to make a change of the value of the variable trigger a recalculation?
Thanks in advance.
Origin Ver. and Service Release (Select Help-->About Origin): OriginPro 8.5.0 SR1 Operating System: Win 7 (64 bit)
Currently there is no such support, only cell values are registered to trigger recalculate. You can put that variable into a cell in another column, for example iif data in column 1 and variable in column 2 cell 1, then formula
col(1)+col(2)[1]
will allow value in that cell changing to trigger.
Recalculate 'Set column values' with a variable
Posted - 12/16/2011 : 11:40:44 PM
