Navigation:  Forms > Navigator >

Navigator • Overview

 Previous pageReturn to chapter overviewNext page

 

In the upper part of the Navigator, the worksheets and their differences are displayed.  At one glance you can see how many differences exist

 

navigator1_en

 

For example in that screenshot you can see that the following differences were detected in worksheet "FDM":

 

Missing columns

1/1; (one missing column in Master and one missing column in Update)

Missing rows

23/31; (23 missing rows in Master and 31 missing rows in Update)

Different values/formulas

79 different formulas/values

 

In the columns of the list box various differences are shown.  The difference types are as follows

 

navigator_symbol_cols

Missing columns

navigator_symbol_rows

Missing rows

navigator_symbol_keys

Duplicate keys (only database mode)

navigator_symbol_dups

Duplicate records (redundant records, only database mode)

navigator_symbol_diffs

Different cell values/formulas

navigator_symbol_fmts

Different cell formats (only displayed by formatting comparison)

 

 

You can view the detailed information for each difference by clicking on the difference your interested in.  The detailed information will appear in the lower part of the form

 

 

Description of the icons in the toolbar

 

navigator1_recompare

Re-compare worksheets

With these buttons you can repeat the comparison the worksheets without closing the Navigator.  This comes very handy when wanting to update differences and to know whether or not there are still differences.  If all worksheets are to be compared, the left icon must be locked.  If this symbol is not locked, however, only the selected worksheet will be compared.  With the right icon, a new comparison is started

navigator1_highlight

Highlight / remove differences

With the left symbol differences are highlighted.  With the right icon, the Synkronizer high-lighting's are removed, with the original background colors restored

 

navigator1_showhide

Show/hide differences

With these two symbols the differences can be shown or hidden.  To view specific differences, proceed as follows:

1.Press the arrow of the left icon and select the differences you want to be shown/hidden
2.Click the plus sign of the left of the symbol; the differences will be shown/hidden
3.When all differences are to be shown again, click the right button again

 

navigator1_arrange

Arrange windows

With these two button you can change between a horizontal and a vertical view

 

navigator1_docking

Dock Navigator form

Normally, the navigator form is shown above the Excel worksheets.  With these buttons you can dock the Navigator form at the left or right of the Excel worksheets