Table Wizard
The Table Wizard helps you create new tables and offers a host of pre-configured table layouts for you to choose from.
Before you call up the wizard, you should select the data to be displayed. You can select complete data sets in the Object List or in the name row of the open folder's data view. Alternatively, you can select cell ranges in the Data View, in an Excel workbook or in a data set window. Another option is to use the section between the active cursors in a diagram as the data selection.
If you select the data objects in the Object List, the series of curves or cells in the table corresponds to the series of data objects in the Object List. If applicable, you should re-sort them before launching the wizard.
Step 1 - Table Type and Style
First click on the relevant tab below to choose whether you want to add a standard table or use a table template (style sheet): Standard or From Template .
Standard Table
Choose a table type and the preferred table style . The table will immediately appear in the preview window. For large data sets, FlexPro automatically enables the option Preview with decimated data. If you want to view all of the data, uncheck this option. Click Edit Style Sheet to change the style sheet for the selected table style. The settings will then apply for all subsequent tables that you create.
Use the Colors field to select the color palette that you want to use to color the table. You can use the first grayed out palette to customize in the style sheet.
The Table Color field determines the table color, which is taken from the selected palette.
If you like the table as it is now, you can click on Finish. Otherwise, click Next to move on to the next step.
Table from Template
Select the desired template type and template database from which you want to use a template. All existing templates are listed from which you can choose.
If you like the table as it is now, you can click on Finish. Otherwise, click Next to move on to the next step.
The Dynamic Columns option controls the layout of column tables for displaying lists. If you deselect this option, lists will be split into several columns—one per list element. The advantage of this is that you can style the columns separately later. The disadvantage is that the number of list elements cannot be changed if you update the table later. If you select this option, only one column is created for the entire list. When the table is displayed, this column is then used as a template for displaying all list elements. The advantage of this is that the number of displayed columns dynamically adjusts to the particular number of list elements. The disadvantage is that the same settings are used for all columns. In particular, no individual format settings can be set for the individual columns.
Step 2 - Table Columns
This step is displayed for standard column tables and column tables from dynamic templates.
You can change the column layout by selecting a column in the Columns list and using the Far Left or Far Right buttons. Use the Add button to add another column to the table. The settings of the column selected in the list are copied to the new column.
You can edit the column selected in the list as follows:
Use the Style list box to specify how the column will be formatted. It will only appear for tables that you create from a template. The number of style sheets shown will be based on the number of columns with different style in the table template. You can thus assign one of the styles to the column.
Use the Data set field to change the assigned data set or enter any FPScript expression that calculates the data you want to display.
Use the Format field to specify an optional formatter, which controls how the data is formatted.
Enter the text that you want to appear in the column title in the Title text box. You can insert fields in the text to display data set attributes.
If the data set has an X component and possibly a Z component, the following checkboxes appear: X Data and Z Data. Select the boxes to display the relevant component in addition to the Y data. Use the Format field to specify a formatter for each component.
Step 2 - Table Size
This step appears for standard cell tables and cell tables from dynamic templates.
Here you can increase the number of rows in the cell table. The extra cells are then added and are empty. You can then enter text or drag in links to data sets that contain data you want to display.
Step 2 - Assignments
This step is displayed for column tables and cell tables from static templates.
Static table templates refer to a fixed number of columns or cells. When using this type of template, you assign an object to every object link in the template. To do this, the object type has to match the data structure, including in the case of data sets. You can also specify formulas or analysis objects with the data set object type.
The Used as column of the list displays the object references present in the template, and the Data column displays the data sets currently assigned or other objects. Use the Up and Down buttons to change the assignments and the Insert Object Reference to select and assign a different object from the project database. Use the Select Data button if you only want to display a range of data from a data set. Use the Update button to update the preview after making your changes.
Step 3 - Table Options
This step appears for standard tables and tables from dynamic templates.
Select the option Add Table Title to add a title to the table. You can add fields to the text to display the table attributes.
In the Position list box, specify whether the label should appear above or below the table.
You can add a title row or column to a cell table using one of these options: Add title row or Add title column.
You can add a title row and add an index column to a column table. This is a column that shows numbers in ascending order. Select the option Format the first column as title column to format the first column separately depending on the table style.
Step 3 or 4 - Table Positioning
Here you can finally specify whether you want to create the table as an independent object or as an object embedded in a document. You can create a blank document or select a document template for this.
You can still edit the table after you click Finish to create it. You can also insert additional columns into a column table later, for instance, by using your mouse to drag data sets from the Object List into the table.