# Spreadsheet Editor

The Spreadsheet Editor is used to configure and program an In-Sight® vision system. The spreadsheet is analogous to other spreadsheet applications in terms of its standard operations and functionality, such as manipulating blocks of cells, editing cells, referencing cells and inserting functions. It consists of the following parts:

Number | Description
--- | ---
1 | The main Spreadsheet toolbar, providing access to the Recipe Manager and the various buttons used to manipulate the spreadsheet and the acquired 2D images. See the Spreadsheet Toolbars topic for more information on the tools located in the Spreadsheet toolbar.
2 | The spreadsheet, where functions are added and logic is created for the application.
3 | The 3D viewer of the spreadsheet, showing the acquired 3D point cloud. You can reveal or hide this viewer with the expander button at the top right corner of the viewer. Click to close the viewer, or click to reveal it, if hidden. See the 3D Toolbar topic for more information on the tools located in the 3D viewer.
4 | The Job Browser, providing access to the In-Sight Toolbox, allowing you to drag-and-drop spreadsheet functions to the spreadsheet. The In-Sight Toolbox, allowing you to drag-and-drop spreadsheet functions to the spreadsheet. The Properties tab of the spreadsheet cells.
5 | The Properties tab, providing a quick access to the spreadsheet cells containing the acquired 2D and 3D images.

Organized into a table of cells arranged in 400 rows (numbered 0 to 399) and 26 columns (labeled A to Z), each cell is identified by its column letter and row number; for example, cell A2 is located at the intersection of column A and row 2.

The spreadsheet is configured one cell at a time. The contents of each cell are defined as a formula, and any piece of information inserted into a cell (whether a single numeric value or a complex vision processing function) is considered a part of the formula.

When you highlight a cell, it becomes outlined in black and the information in the cell is displayed in the Formula Bar of the Job Edit toolbar. Clicking on a cell automatically makes it the active cell.

Note: Right-clicking within the spreadsheet displays a shortcut menu that allows you to perform various spreadsheet operations.