Spreadsheet visuals

<< Click to Display Table of Contents >>

Navigation:  Reference Manual > Windows and dialog boxes > Spreadsheet visuals >

Spreadsheet visuals

This is reached from Spreadsheet options using the "Colours and font sizes" button for the spreadsheet tables output.

These can be set globally as the default house style or for this project only using [Analysis] [Default spreadsheet options].

Each row here controls a different part of the output.

[Default] restores the default setting for this row.

[Cell] is used to set background colour for the cell(s) that contains this text.

[Font] is used to set the colour for text.

[Border] is used to set the colour for the borders affected.

[Point size] is used to set the size of the text.  Must be set between 5 and 16.

[Bold] if set the text will be bold.

[Italic] if set the text will be italic.

[Right align] only available for column identifiers.

The effect of the settings is shown on the right.

Not all rows have all the settings above.

You can set these for:

Title describing the rows used in the table (vertical title).

Table number.

Title describing who is included in the table (base title).

Row and column header texts including describing the columns used (column title).

Row and column texts.

Column identifiers used for significance testing shown below the columns labels.

Significance markers shown below or alongside the relevant cell.

Unweighted is used for unweighted rows and columns (format UNC) on weighted tables.

Vertical percentages.

Horizontal percentages.

Main border set the colour for the lines used around the table and separating blocks.

Between rows border used between all rows of the table to make scanning rows easier.

Note that the settings for significance markers will be used when merging markers with the data cells.

Note also that when significance testing is done against the total column, cells within the table will have background colours to show "significant" differences using formats SLA, SLB and SLC.

Sig colours