To set up table general parameters, use the Parameters group of parameters on the parameters panel:
To open the Parameters group of parameters
To open the Parameters group of parameters on the parameters panel:
Select a cell or a cell range in the table.
Click the Parameters button on the toolbar.
Select the Table area type in the drop-down menu of the parameters panel title.
Set the parameters:
To determine behavior of columns and rows during placement on a sheet, select a mode in the parameters drop-down list:
Columns. The parameter determines how table columns and columns located to the right of the table change on table resize. The following options are available:
Fixed. The number of table columns will be fixed and will not change.
Overwrite Columns to the Right. If the number of table columns increases, information located in column to the right of the table will be overlapped with table data.
Insert. When the number of table columns increases, the necessary number of columns will be added to the report sheet. Information located in columns to the right of the table will be shifted to the right.
Rows. The parameter determines how table rows and rows located below the table will change on table resize. The following options are available:
Fixed. The number of table rows will be fixed and will not change.
Overwrite Rows Below. If the number of table rows increases, the information located in rows below the table will be overlapped with table data.
Insert. If the number of table rows increases, the necessary number of rows will be added to the report sheet. The information located in the rows below moves will be shifted downward.
Selecting the checkbox enables the user to save changed table data to data source. If the checkbox is deselected, saved data cannot be saved to the data source. The checkbox is selected by default.
To use formatting used on a table sheet to the table, select the Use Sheet Formatting checkbox. If the checkbox is deselected, changes in table sheet formatting do not affect the table formatting. Use the Use Sheet Formatting checkbox only if the table will not be dynamically rebuilt and resized at the same time.
See also: