Edit Table Dialog

The Edit Table dialog enables you to alter tables that you have inserted into your report. It is accessed when you add or edit tables via the Report View.

In addition to the on-screen advice, you should note the following:

Columns

Either right-click or hover the mouse over the column headings and click the Menu button to access the column menu.

Insert Column: Select to insert a column in the table either Before or After the current column.

Delete Column: Select to delete the column.

Move Column: Select to move a column either Left or Right.

Edit: Select to edit the Width via the Edit Column Width dialog, or Style via the Edit Style Set dialog.

Clear Styles: Select to delete all Styles.

Rows

Either right-click or hover the mouse over the row headings and click the Menu button to access the row menu.

Insert Row: Select to insert a row in the table, either Before or After the current row.

Delete Row: Select to delete the row.

Move Row: Select to move a row either Up or Down.

Edit Style: Select to edit the Style via the Edit Style Set dialog.

Clear Styles: Select to delete all Styles.

Cells

Enter hard coded values into cells by clicking and typing.

You can use arithmetic operators ('+','-','/','*') to define cell values in relation to other cells by starting the cell value with an '=' character. For example, if cell A1 is '10' and B1 is '25', then '=a1+b1' returns '35'.

Either right-click or hover the mouse over the cell and click the Menu button to access the cell menu.

Style: Select Bold, Italic, Single or Double Underline for the current cell. Select Edit Style to specify the style via the Edit Style Set dialog.

Use the style to specify the number of decimal places required in a particular cell.

Select Clear Styles to delete all styles.

Insert: You can also insert rows and columns via this menu, as described above.

Merge: Specify whether to merge the current cell to the right or down. This is particularly useful for sub-headings in your table that need to span multiple columns. You can remove the merge by selecting De-Merge.

If you are inserting columns for the purpose of creating spanning cells, ensure that the columns are inserted to the right of the cells that contain the content to be merged. This then enables you to select merge right on these cells, to achieve the desired effect.

Clear Contents: Select to delete all contents from the cell.

New/Edit Expression: An expression enables you to include particular period data in the table. Select New/Edit Expression to add or edit an expression for the cell, via the Edit Expression dialog.

Contents: This is usually automatically detected for you from the text entered in the cell. There may be occasions where you wish to override this. For example, you may wish to start a cell with the text '=', to do this you need to specify that the cell is text rather than a formula.

Specify the type of contents for the cell from the Contents submenu, as follows:

• Auto Detect: Select this option to let the type of data be defined by what you have typed into the cell.
• Manual Selection: Select this option to enable you to specify the type of data held in the cell, by the following options:
  • Empty: The cell doesn't contain any values.
  • Text: The cell contains just text.
  • Currency: The cell contains just currency values.
  • Expression: The cell contains an expression.
  • Formula: The cell contains a formula to calculate its value from other cells.
  • Mixed: The cell contains a variety of content.