Skip to main content

Output view table format

Tables of output may be formatted by displaying the output in a standard Output view or a Grid output view. Outputs for inspection, presentation or printing are best formatted with a standard Output view, while the Grid output view facilitates the copying of output to spreadsheets.

New output views are opened in the standard Output view format. The default Output view table format is saved with the default view settings.

A Grid output view can be opened by going to Output > Grid window when a standard Output view is open. It is opened with the same output shown in the parent standard Output view and is updated to reflect this output while the parent view is open.

There are advantages and disadvantages with each Output view table format. These are summarised as follows.

Standard output views​

Generally standard output views are best for the presentation or printing of output.

Advantages:

  • Table header of the active table remains at the top of the window
  • Output options may be specified directly
  • Output format is optimised for printing / saving as PDF
  • Table formatting preserved well to spreadsheets if entire rows are selected and copied into a spreadsheet

Disadvantages:

  • Individual columns may not be selected and copied to a spreadsheet

Grid output view​

Generally grid output views are best for copying tables into spreadsheets.

Advantages:

  • Data is copied to the clipboard in tab separated format. This results in data being pasted in cells correctly when pasting to spreadsheet.
  • Data may be selected by blocks, columns or rows of cells.
  • Tables may be displayed in a grid. (Window > Settings > Grid)

Disadvantages:

  • Output format is optimised for regular tables of output but is not well suited to notes and other non-tabular output.
  • Output options may not be specified directly (though the view does reflect the settings of the parent standard Output view).

Note that the Output view table format is independent of, and should not be confused with the spreadsheet format option.