Interacting with spreadsheets

The spreadsheet format option is offered to assist in the interaction between output views and spreadsheets. Spreadsheet format is selected in the Output wizard: Further options.

Spreadsheet format arranges tables with the output for a given entity on a single line.

When copying data to paste into a spreadsheet, it is advisable to copy from a grid Output view if you want to target specific columns. Copying from a standard Output view would also work. See Output view table format for details.

The export option in the Output settings dialog box writes the output as currently specified (but not necessarily currently displayed) to file in either tab or comma delimited text format. It is possible to use this option without displaying the output in an Output view. Do this by giving the New output view command, then, in the Output settings dialog box, select the required output and exporting, then cancel from the dialog box.

The Output > Export output menu command writes the output as currently displayed to file in either a tab or comma delimited text format.

Copying a selection from the Output view, using Edit > Copy (Ctrl+C), copies the selected data onto the clipboard in a format that is acceptable by most spreadsheet programs.