Graph IDE ► Data Graphics ► Spreadsheet

A spreadsheet is a Table with textual cell entries that are stored with the table. The following figure shows some examples of spreadsheets.

Spreadsheet are Tables, derived from the Group graphic, implement many type of cell editing and generation features and coordinate associated representations which are Pie Chart, Bar And Column Chart, Scatter Graph and Line Graph.

Some standard operations are itemized below.

- To create a spreadsheet bring forward the Graphic Selector, click the spreadsheet factory cell and then drag one from the spreadsheet Factory Inspector.
- Tables are set to resize by adding rows and columns as needed per the Alignment settings.
- When a spreadsheet is used to make an associated representation of Pie Chart, Bar And Column Chart, Scatter Graph and Line Graph then those representations are connected to the spreadsheet data. Altering the spreadsheet data alters the associated representation and visa versa. If a spreadsheet is deleted then the connection to the associated representations are broken but the associated representations still exist, and visa versa. If a spreadsheet is copied with the associated representations then the connections are maintained.
- If the associated representation requires a graph then the graph nearest to the spreadsheet will be used. To use multiple graphs first move a graph close to the spreadsheet and make the representation then move the graph away from the spreadsheet and move a different graph near the spreadsheet and make another representation.
- Once an associated representation is made then that representation will be reused when the data in the spreadsheet is updated. That means any alterations to the representation such as colors, stroke widths, markers and other graphical effects will be permanent even though the data is changing.
- For more information on editing see Standard Editing.

A spreadsheet does not translate its cell textual values, rather it simply stores them. Spreadsheets may be a convenient way to store tabulated textual values in a document which can then be used for other purposes such as general viewing of textual data or copy and paste to other tables found in various inspector editors. Spreadsheets may simply be used to compute column values for placement into other tables.

Spreadsheets (and Tables) can be used right away by dragging one from the factory palette. If you wish to customize a spreadsheet then follow this general guideline: First, resize the spreadsheet so that it only has one column and one row. Then in the Navigator expand the table and select the row, column or data cell Label or Rectangle graphic and alter those graphics. Once the graphics are altered then resize the spreadsheet to the desired number of rows and columns. Cells are duplicated from the last cell (the cells you just altered) so new cells take on graphic attributes that were previously set.

Spreadsheet Editor

The Spreadsheet Editor for the spreadsheet is shown below.

Table Data Parameters

Data Type : Either Spreadsheet or None. When Spreadsheet then the table has a spreadsheet data type store. When None then the spreadsheet is a Tables and has no data backstore.

Preconfigured Data : One of Empty, Reference or Function. Empty clears all cells (deletes all the data), Reference places Cell descriptions in each cell and Function places various discrete values of a function into each column. Preconfigured data is mostly to give examples of the use of a spreadsheet.

Table Title : Shows and defines the title of the table.

Table Controls

Component : Shows the currently selected table component (a row, column or cell) and has a drop down menu of common commands such as copy, paste and delete.

Event Qualifier : While Inactive spreadsheet acts like a general graphic, while Active the spreadsheet implements Table interaction so that mouse events operate on it like described in the Tables section, e.g.: The table values can be directly selected and edited. In addition, the associated graphics are also made active so that the Information Selector and Data Selector are enabled, see the Pie Chart section as an example of that.

Cell Controls : Used to edit a cell in the table.

Vertical Slider : Specifies the row offset of the table.

Horizontal Slider : Specifies the column offset of the table.

Column Generation

Column entries can be generated using a formula as specified by the column generation fields.

Column Number : The column for which entries are to be generated.

Header Title : The title of the column.

Number Of Rows To Compute : The number of row values to be generated.

Formula : A formula where i represents the independent variable (sequence index) and is the row number.

Prefix : Text to apply as a prefix to the formula value.

Suffix : Text to apply as a suffix to the formula value.

Compute : Select this button to compute the formula and enter the resulting sequence of values into the column cells.

Graphs (Associated Representations)

X/Label : Specifies the column to associate with the independent variable (x axis) or label entries. If None then the independent variable is unitized or specifies no labels to be used.

Y/Amplitude : Specifies the column to associate with the dependent variable (y axis) or amplitude values (in the case of a pie chart).

Operation : Select an entry in the drop down menu to make a Pie Chart, Bar And Column Chart, Scatter Graph or Line Graph or to delete the associated representations. If the associated representation requires a graph then the operation will choose the graph nearest to the spreadsheet to place the representation in. If a graph does not exist in the Layer of the table then the operations that require a graph are disabled.

Graphics Editor

The Graphics Editor for the spreadsheet is the same as the Group editor.