This menu can be used to compare a column within the current spreadsheet with
another column in the same or another spreadsheet.
If any differences are found, you will be prompted with a warning
message and the discrepancies are displayed in the Output window.
This menu is useful for comparing two columns to see what differences
there are between them. For example, you could compare a newly calculated
column with a column obtained from Excel to detect any discrepancies
in the formulae used within Excel.
Compare Column
A drop down list of columns in the current spreadsheet. The selected
column will be compared with the values in the With Column.
With Column from Spreadsheet
A drop down list of other currently open spreadsheets.
With Column
A drop down list of columns in the currently selected spreadsheet from
the list above.
Tolerance on numerical comparisons
Specifies a tolerance to be used for numerical comparisons. When comparing two
numerical items, if thee absolute difference is less than this amount then this
indicates a match between the items.
Text Comparisons Ignore Case
When selected, comparisons between text in the two spreadsheets will
be made ignoring the case of the characters. For example, 'GENSTAT' and 'GenStat' would not be
highlighted as different.
Abort comparison after finding N differences
This limits the number of differences that are found to a maximum of the
number specified in the edit box.
OK
Compare the two columns.
Cancel
Close dialog.
See Also