# Entering Information into the Spreadsheet

Vision inspections are configured by assembling formulas and inserting them into the cells of the spreadsheet. A formula can contain four types of data: a number; text; a reference to another cell, either absolute or relative; or a function, with specific parameters.

Note: An In-Sight spreadsheet can contain a maximum of 4,096 active cells. Inserting a function (such as DetectBlobs) that, in turn, inserts multiple Vision Data Access Functions into the spreadsheet can cause the spreadsheet to attempt to exceed the limit. In this case, no warning dialog is issued; the cells over the 4,096 limit are simply not inserted.

### Inserting numbers into a cell

Select a blank cell and enter the numeric value (for example, 26).

### Inserting text into a cell

Select a blank cell and press the apostrophe ( ' ) key. Any text following the apostrophe is inserted into the active cell as a text label rather than a formula.

### Inserting a cell reference into a cell

There are four main methods for inserting cell references into cells:

- Double-click on a blank cell, and then click on the cell you want to reference (this creates a relative reference; to create an absolute reference, hold down the SHIFT key).

- Select a blank cell, and then manually type the cell name to reference creating a relative reference (for example A11.) An absolute reference can be made to either the column, row or both by typing the $ symbol before the letter, number or both (for example $A$11.)

- Select a blank cell, and then click the Absolute Reference or Relative Reference button on the Job Edit toolbar and enter cell selection mode. This causes the spreadsheet to enter cell selection mode where a cell or group of cells can be selected visually. Cell selection mode highlights the selected cell(s) with a red outline, the original or destination cell will have a pink fill color. Press enter to commit or the Esc key to exit.
- Select a blank cell, and use the keyboard shortcut for Absolute Reference CTRL+SHIFT+A or Relative Reference CTRL+SHIFT+R and enter the cell selection mode.

### Inserting a function into a cell

There are six main methods for inserting functions into cells:

- Drag a function from the Toolbox panel to a blank cell. If the function has an associated property sheet, it is automatically displayed.
- Select a blank cell, and double-click on a function in the Palette. If the function has an associated property sheet, it is automatically displayed.
- Select a blank cell, and then press the Function button on the Job Edit toolbar. This launches the Insert Function dialog.

- Select a blank cell, and then press either the ENTER or EQUALS key. Next, press either the UP or DOWN ARROW key. This displays a function box, where you can type or select a function. Press either the TAB or ENTER key to close the function box.

- Select a blank cell, manually type the name of the function and then either press the ENTER key or manually type an open parenthesis. If the function has an associated property sheet, it is automatically displayed.

- Select a blank cell, manually type the name of the function into the formula bar and then either press the ENTER key or manually type an open parenthesis. If the function has an associated property sheet, it is automatically displayed.

#### Accepting or rejecting the formula

To accept the new formula/ value, do one of the following:

- Press the ENTER key.
- Click the OK button on the Job Edit toolbar.

To cancel the new formula/value and restore the previous expression, do one of the following:

- Press the ESC key.
- Click the Cancel button on the Job Edit toolbar.

Any text highlighted in red indicates an error in your formula that must be corrected before the formula can be accepted.

#### Tooltips and help information

Tooltips are available in both the spreadsheet and the formula bar. Click inside the function's parentheses to see the syntax.

Tip: When the cursor is positioned inside a function's parentheses, you can press F1 to load the help topic for the function.

#### Using the formula bar

The formula bar is located on the Job Edit toolbar. It contains three pieces of information:

- The active cell (D3)
- Any formula or value contained in the active cell (37)
- Edit Cell State information for the active cell (if $A$3)

You can directly edit the formula, value or label in the active cell by simply clicking inside the formula bar and making any desired changes. Click inside a function's parentheses to display a tool-tip that assists with syntax.

Clicking on the Edit Cell State link opens the Cell State Dialog.