Summary

<< Click to Display Table of Contents >>

Navigation:  Results Tab >

Summary

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.

 

results_form_overview

 

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

0

 

 

The following difference types are reported in this list box:

 

results_sum_columns

Missing columns. These columns exist only in one worksheet.
 

results_sum_records

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

 

results_sum_keys

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

 

results_sum_rows

Missing rows. These rows exist only in one worksheet.
 

results_sum_entered_values

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

results_sum_calculated_values

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

 

results_sum_formats

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

results_sum_comments

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

results_sum_names

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:

 

select_form_overview_detail