2.5.1.4 From Worksheet Script

The Worksheet Script dialog is provided for backward compatibility with older versions of Origin that did not have the Auto Update feature in the Set Values dialog and/or did not have import filters where scripts could be set to run after import. Given that it predates many newer batch features such as Analysis Templates and recalculation, it should only be used for post processing of imported data (e.g. when importing data via Data Connector).

Scripts can be saved in a Worksheet (so workbooks have separate Worksheet Scripts for each sheet) and set to run after either importing into this Worksheet and/or changes in a particular dataset (including datasets not in this Worksheet).

Here is a script that is attached to Sheet3 which is set to run on Import (into Sheet3) or when the A column of Sheet2 changes.

range ra1 = Sheet1!1;
range ra2 = Sheet1!2;
range ra3 = Sheet2!A; // Our 'Change in Range' column
range ra4 = 3!2;      // Import could change the sheet name ..
range ra5 = 3!3;      // .. so we use numeric sheet references
ra5 = ra3 * ra2 / ra1 * ra4;