14.2 Creating and entering values into a new Table

Before entering values into a table, you must first create a table.

To create a new table:

  • Open the Tables View.

  • Click the "add" toolbar button. This will open the Add/Change Table Dialog.

  • Enter the table name and properties into the dialog (see below). The specific property options will be describer later in this chapter.

  • Click OK to save the table and close the dialog.

After the table is created, it will appear in the tables list within the Tables View. You can then edit the properties of the new table.

To change the properties of a table:

  • Select a table in the list.

  • Click the "edit" button in the toolbar (the pencil).

  • Change the table properties in the Add/Change Table Dialog.

Entering values in a table

To populate a simple table, use the table entries toolbar and table data grid.

To enter table data:

  • Select the table in the tables list.

  • Click the "Add Row" button (green plus) in the table entries toolbar. A new table row will appear in the table data grid.

  • Change the values for the data row as needed, both the index and value entries.

  • Repeat prior two steps to add more data rows.

This method of entering data can be time consuming. There are other methods available for loading table data. Those methods are described below.

Loading/copying tab-delimited table data

To modify the values in an existing TreeAge Pro table, it may be more efficient to copy the table of data into a spreadsheet or text file for editing. Or, if you have a new, empty TreeAge Pro table, you can create the table in a spreadsheet, and then copy and paste into the table directly.

To edit table data in Excel or a text editor:

  • Select the table in the Tables view.

  • Click the Copy button in the Table Rows editor, as shown below.

  • Paste the rows into a spreadsheet or text document.

  • Edit the data as tab-delimited text.

  • Copy the table data, including headers, into the clipboard.

  • Click the Paste button in the table editor to paste the table back into original table.

Take note of the following requirements:

  • A column title row is not required. If one is not included, they will read: Index, Value1, Value 2 etc. Otherwise you can select any column heading (Index or Value columns) and rename them.

  • The selected range of cells in Excel should use either General, Text, or Number formatting (avoid accounting formats using parentheses for negatives numbers).

  • The copied range should not include empty columns or rows.

  • Note that the Paste Table command first removes existing rows from the table. However, the command is Undo-able.

  • If the Paste command is not available, or does not work, see the bulleted list of suggestions above on proper cell formatting in the source document. If all else fails, try first pasting the spreadsheet data into a plain text file to remove formatting, and then copy the text file data into TreeAge.

Editing index and value column headers

You can enter custom column headers for the index and value columns by clicking on the header. You can then enter the custom column header into an input dialog.

Editing table data in Excel

You can export table data to Excel, edit the data in Excel, then import the edited data back into TreeAge Pro.