|
<< Click to Display Table of Contents >> Navigation: Reference Manual > Windows and dialog boxes > CSV tables options > CSV tables options |
This is reached from Tables overall to set the options for the CSV tables output which is converted to a formatted Excel file.
These settings are stored with the tables QTF file.
This option causes an information line (IN is column A) to be output at the top of each table with the formats used.
This information is used to control formatting of the Excel output and can be used by macros to alter the output.
For significance testing between columns each column is allocated a column identifying letter at the end of the label. This option removes the identifier from the label and places it in a separate row below the last line of the column labels.
Honour formats CAZ, CNZ and CZP in the CSV tables.
This option may cause problems producing graphs from the tables.
The significance markers are normally put in a separate row below each row of the table. This option causes the markers to be put in a separate column alongside each column of figures.
Empty marker columns will be output as a text containing a single blank.
This is the default and means that all figures written to the CSV/OpenXML spreadsheet file are the real calculated figures. The format settings for decimal places will be used in the Excel/OpenXML output but clicking on cells will show the real values above.
Figures in the spreadsheet output are normally the "real" figures. A figure in the table showing as 23% may actually be 22.78367%. This option causes the figures in the spreadsheet to be rounded as specified by the format settings which state the number of decimal places to be used.
You can specify the decimal places to be used for the three types of values (figures, percentages, statistics).
The value for each must be in the range 1-14, or 0 which means no rounding for this type of value.
These do not affect the display which will remain as specified by formats. It only affects the actual values stored and shown when a cell is clicked.
These options reduce the size of the tables CSV file and can make values easier to read when clicked but be aware of the double rounding problem this can cause:
WARNING: Because the decimal places for display (format setting) are less than the specified decimal places here, values displayed can be rounded twice. For example if you have a real value of 16.45% and you specify 1 decimal place for it here, then the value stored in the cell will be 16.5%. If your format setting is whole numbers, then this will be shown as 17% because Excel will round up the 16.5 value stored. If the real value (16.45) was stored instead then Excel will correctly round it down to 16%. The more decimal places that you specify, the less of a problem this double rounding is. For this reason, we do not recommend using less than 4 decimal places here.