Table Of Contents
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.
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.
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.
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 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.
The Graphics Editor for the spreadsheet is the same as the Group editor.