4.8.3.6 The (Worksheet Properties) Script tab

Note: Worksheet Script is provided for backward compatibility with older versions of Origin that did not support recalculation of Set Values and/or did not have import filters where scripts could be set to run after import (e.g. Scripts in ASCII 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 such as when using a Data Connector to import data.


To open the Script tab of Worksheet Properties dialog:

  1. Select Worksheet: Worksheet Script when the desired worksheet is active.

or

  1. Select Format: Worksheet from the menu or pressing F4. And then go to the Script tab.


The LabTalk script that is entered in the script box is associated with the active worksheet. The method of script execution is controlled within the tab. Save the worksheet as a template and the associated worksheet script is saved as well.

Workbook script.png

Run Script

After Import

Select this check box to execute the worksheet script each time you import data into the worksheet.

Upon Changes in Range(s) (space separated)

Select this check box to run the script in the Script Box whenever a change is made in the dataset specified in the associated text box. Following dataset range notations are supported in the associated text box. Note that both space and comma are supported here as separator(s).

A,C,E    // Column A, Column C and Column E
A C E        // Column A, Column C and Column E
A:E        // Column A to Column E
A:B, D:E   // Column A to Column B and Column D to Column E
A:B D:E   // Column A to Column B and Column D to Column E
1:end      // All Columns
1:2, 4:end // All Columns except the third column
1:2 4:end // All Columns except the third column

Support single line statements without ";" termination.

Select this check box to execute a single statement script in the Script Box without ending with a semicolon.

The Script Box

Type the desired LabTalk script in this text box. The script should follow the same syntax conventions as a LabTalk script file. For more information, see the LabTalk Section of the Programming Help file (Help:Programming).

Click Run button Button Run.png to execute the script immediately. Additionally, clicking Button Run.png, Button wextract OK.png or Button wextract Apply.png button will save the script and execution method to the worksheet and set them as the default settings.