2.5.1.16 From Worksheet Cell

From-Worksheet-Cell

Run Script from Worksheet Cellscript, from worksheet cell

Executable LabTalk script can be inserted into worksheet cells, including cells in column label rows with the following syntax. The DisplayedText is optional. Without it, the script itself will show.

labtalk://Script DisplayedText

Note: If the script opens a dialog, please prefix the script with ;. Otherwise after closing the dialog, the cell with end up in edit mode.

To edit it again:

• Single click it on the cell and hold the mouse for more than 2 seconds before releasing.
• Alt + double click
• Choose Edit: Edit Mode (Ctrl+Alt+B) menu. After editing, please make sure select the menu again to exit the edit mode.

Examples

1. Add a single line script without space. Click on it will add a new column in current sheet.

   labtalk://wks.ncols+=1

2. Add a single line text with space. Click it will open x-function based smooth dialog. ; is added at the beginning to avoid entering edit mode after closing the dialog.

   labtalk://";smooth -d" Open Smooth Dialog

3. Run [open] section of file.ogs file. Click it will open File: Open dialog

   labtalk://;run.section(file.ogs, open) Open File...

Please visit Inserting Executable LabTalk Script for more information.