4.6.8.2 Menu Options and Dialog Controls

Formula Menu

The menu options under Formula are used to operate expressions, such as saving and loading expressions.

Load Sample

Load a sample expression.

Load

Load a saved expression.

Save

Save the current expression.

Save As

Save the expression using another name.

wcol(1) Menu

Origin lists all the columns of the current worksheet in the form of WCol(N): Short Name"Long Name", where N is the index of a column. You can select one of them to add to Column Formula or Before Formula Scripts so that you can use the column in your expression. Whether to add the selected column to the Column Formula edit box or the Before Formula Scripts edit box depends on where the cursor is.

WCol(N): Short Name"Long Name"

You can select this menu option to add wcol(N) to Column Formula or Before Formula Scripts. N is the index of a column.

Column Browser

Select this to open the Column Browser dialog which helps you to choose the column to add.

Col(A) Menu

Origin lists all the columns of the current worksheet in the form of Col(Short Name): Long Name, such as Col(A): Time. You can select one of them to add to Column Formula or Before Formula Scripts so that you can use the column in your expression. Whether to add the selected column to the Column Formula edit box or the Before Formula Scripts edit box depends on where the cursor is.

Prefer Long Name

Prefer using the long name to specify the colomn name, Col(Lone Name): short Name

Col(Short Name): Long Name

You can select this menu option to add Col(Long Name) to Column Formula or Before Formula Scripts.

Column Browser

Select this to open the Column Browser dialog which helps you to choose the column to add.

Function Menu

This menu can be used to add functions for building the expression. You can select a function and insert it in either the Column Formula or the Before Formula Scripts edit box. Functions are inserted at the cursor.

Recent Used

Functions which have been used are automatically added to this menu.

Search and Insert...

Open the Search and Insert Functions dialog to search for built-in functions.

Functions in different categories

Select a function to add to Column Formula or Before Formula Scripts. For more on these functions, refer to LabTalk supported functions.

Variables Menu

The options in this menu have been supported since Origin 8.1 SR0. Use menu commands to insert variables into the Before Formula Script edit box.

Predefined Variables

Add a variable or a constant to Column Formula or Before Formula Scripts. Available variables and constants include:

  • This
    Use to denote the current column. Use Thisn to refer to nth cell in the current column
    Note: this variable is only available when Spreadsheet Cell Notation is turned on. And it cannot be used in the Before Formula Script edit box.
  • [i]
    Use to denote the row index.
  • pi
    This is the PI constant.
  • j
    Use to denote the column index.
  • wcol(j)
    This is the Current column(s).
Project Variables Add project variables to Column Formula or Before Formula Scripts. Up to 10 project variables (and their values) are listed in the sub-menu. View and select all project variables from the Project Variables dialog opened by clicking More... sub-item.
Add Range Variable

Opens the Range Browser and helps you to define range variables.

Add Info Variable

Opens the Insert Variable dialog Info tab, to help you insert variable values and file metadata stored in the page object.

One of the more useful options here is to store key variable values in System Variables v1 - v4. This allows you to store a limited number of numeric values (type = double) in the workbook. For guidance, see the Example at the end of this section.

Add Column Label Cell

Opens the Insert Variable dialog Label tab, to help you insert variables associated with column label cells. Hint: Use the panel to the right side to choose the book, sheet and column that contains the label cell data that you wish to insert.

Add Range Variable by Selection... It minimizes the Set Column Values dialog to select the range variable from Worksheet to insert.
Add Column Label Cell by Selection... It minimizes the Set Column Values dialog to insert variables that point to column label cells by selection.

When a range variable has been added through Add Range Variable by Selection menu for the first time, an Insert Mode dialog pops up and you could select different syntax referring to a range. Available options are Column Notation: Col(A), Long Name : A, Short Name : A and Index : wcol(1).

Example: Inserting SYSTEM variables into your column formula

The workbook can store four numeric (double) values and four string variable values. These pre-defined SYSTEM variables can be used, among other things, to store key workbook-specific values that you might use in column values calculations.

  1. Begin by opening a fresh workbook window. This would be workbook that you intend to use for your column values calculations.
  2. With this workbook window active, open the Script Window (Window: Script Window), type the following and press Enter.
    page.v1=1.117
  3. Right-click on the worksheet column you want to use in calculations and choose Set Column Values.
  4. Let's assume we want to multiply our column A values by our new "v1" variable value of 1.117. Begin by entering "A" in the top, column formula box.
  5. From the Set Values Variables menu, choose Add Info Variable...
  6. Expand the System Formula node, highlight your variable v1 (and its value of 1.117) and click Insert, then Close. Note that the Set Values dialog now displays the following expression in the Before Formula Scripts panel.
    double d1 = page.info.SYSTEM.FORMULA.V1;
  7. The value stored in v1 has now been assigned to a variable named d1 of type double. In order to use this to multiply our column A values by 1.117, we have to add it to the top panel expression:
    A * d1
  8. Click Apply or OK to perform your column calculation. Note that should you save the book as a separate window (apart from the project), the variable value will be saved in the book.

Note that another logical method for defining and saving variables for use in Set Values column formulas is to use the Before Formula Scripts panel in Set Values.

Options Menu

Direct Edit Formula Cell This option is enabled by default. Checking this option allows direct editing of the formula in the cell.
Formula Text... This option is available when Direct Edit Formula Cell is disabled. Selecting this option opens the Formula Text dialog box, prompting you to enter the text you want to be displayed in the formula cell in the F(x) label row. Note that if the Formula Text box is left empty, the column formula is displayed in the formula cell. Hint: If you want the formula cell to display nothing, you can type a space in the Formula Text box.
Keep Text When checked, text in destination columns will be kept instead of becoming missing values when doing calculations.

Range/Column controls

RowRangeControl.png

Define the range of the values whose values will be set with the expression.

If you have selected part of a column(multiple columns) before opening the Set Values dialog box, the starting and ending row indices will be automatically displayed in the Row (i): From and To boxes (selecting an entire column will set both boxes to <auto>). Please note that non-contiguous range selection is not supported. To change the range, you can overwrite the values in the From and To boxes.

ColumnControl.png

Specify the columns whose values will be set with the expression. This control is only available when set multiple columns values.

If you have selected multiple columns before opening the Set Values dialog box, the starting and ending columns indices will be automatically displayed in the Col (j): From and To boxes. Please note that non-contiguous columns are not supported. To change the columns, you can overwrite the values in the From and To boxes.

Target Column

This non-editable field identifies the column or columns to which the Column Formula and/or Before Formula Scripts expression(s) should apply.

Column First/Next/Prev/Last

NavagationButtons.png

You can use this group of buttons to switch from one column to another. This allows you to use the Set Values dialog on multiple columns without closing the dialog.

Column Formula

You can add a single line expression in this edit box for generating data. Functions, conditional operator and variables can be used here.

Recalculate

Recalculate

Controls recalculation of Set Values expressions:

  • None
  • Auto
  • Manual

For more information, see: Recalculating Analysis Results

Buttons

Search and Insert Functions dialog

Open the Search and Insert Functions dialog by clicking Search Insert Functions.png button.

Switch to Column Properties dialog

Switch to the column properties dialog by clicking Open properties dialog.png button.

Apply

Set values with the expression without closing the dialog box.

Cancel

Close the dialog box and do nothing.

OK

Set values with the expression and then close the dialog box.

Show/Hide Scripts
(Up Arrow button)

Show or hide the Before Formula Scripts panel.

Before Formula Scripts

You can enter multi-line LabTalk scripts in this edit box and the scripts will be executed before the expression in Column Formula edit box is executed. You can click the Show/Hide Scripts button ShowOrHideButton.png to show/hide this edit box.

Search and Insert Functions

Search and Insert Functions.png

To search for a function, first enter keywords in function search input box and all related functions will be listed with function names and descriptions. You can then navigate to desired function and add the function to Set Values dialog box by double clicking the function name. To view more details of that function, you can go the corresponding function page by click the description part of the function.