<< Click to Display Table of Contents >>

Navigation:  Results Tab >


Previous pageReturn to chapter overviewNext page


The upper part of the Results form displays the worksheets and their differences. You can see the number of differences that were found between the worksheets at a glance.




In the columns of the list box, the various differences are displayed. In this screenshot, for example, the following differences were found in the worksheet "Customer List":


Missing columns

0|1; (no different column in source worksheet, one different column in target worksheet)

Missing rows

3|2; (three different rows in source worksheet, two different rows in target worksheet)

Differences in entered values/formulas

9 differences in entered values/formulas

Differences in calculated formulas




The following difference types are reported in this list box:



Missing columns. These columns exist only in one worksheet.


Duplicate records (redundant rows). These records are completely identical. These records should be deleted. (Appears only in the database comparison mode.)



Duplicate keys. These records have the same primary key. (Appears only in the database comparison mode.)



Missing rows. These rows exist only in one worksheet.


Differences in entered cell values ​​and/or formulas. The entered cell values and/or formulas are different in the underlying worksheets.


Differences in calculated cell formulas. The results of the cell formulas are different (the entered cell formulas are identical).



Different cell formats. (Appears only when formats are compared.)


Different comments. (Appears only when comments are compared.)


Different names. (Appears only when names are compared.)



For each difference, the detailed information can be displayed in the lower part of the form. Just click with the mouse on the desired type of difference and you will find further details below.



In the following example, the difference type "Entered values & formulas" is selected. Nine differences were found in total (in the upper part of the form). The detailed information of each difference is displayed in the lower part of the form: