Compare - Filters

<< Click to Display Table of Contents >>

Navigation:  Select Tab > Ribbon >

Compare - Filters

Previous pageReturn to chapter overviewNext page

The filtering function enables you to reduce the number of differences that will be found and displayed. Just click "Enable filters" and choose the filter(s) which you want to apply.



Ignore case
If this box is checked, differences in upper and lower case writing are ignored (e.g. "John Wayne" equals to "JOHN WAYNE" ).


Ignore whitespace
If this box is checked, spaces are ignored at the beginning and end of words, e.g. the values ​​"John Wayne" and " John  Wayne  " (additional spaces at the beginning and at the end) are considered as equal.


Ignore data type
IIt is possible that some numbers are formatted as number and others as text. This will logically be evaluated as a difference, although the numbers are identical. With this option, these differences are ignored.


Ignore formulas with same results
Supposed you have two different formulas which contain the same results. See the following example:
Cell source file
Formula: =D50
Result: 100
Cell target file
Formula: =$D$50
Result: 100
These types of differences are filtered out by activating this option.


Ignore calculated values
All cells that contain identical formulas, are ignored.


Ignore constants
If this option is active, all cells with constants (entered values​​) are ignored.


Ignore formulas
All formula fields are filtered out .


Ignore hidden columns
All columns that are hidden in the source file, are ignored. Hidden columns of the target file are compared.


Ignore hidden rows
Works like "hidden columns", but with rows.


Numeric tolerance (#) / Relative tolerance (%)
For numeric fields, you can instruct Synkronizer how to deal with deviations. Supposed only deviations greater than 0.10  need to be shown, then enter 0.10. Deviations up to and including 0.10 will then be ignored. You can distinguish between numeric and relative tolerances. Just click on the label 'Numeric tolerance' to switch the tolerance type.
Equivalent values
Chances are, that in some worksheets the same difference shows up en masse. Suppose you need to compare checklists that have a column called "Completed". In the first checklist, the values in this column ​​are represented by "yes / no", but in the other checklist by "ja / nein" or "1/0". This would cause a large number of false positives to be reported in a normal comparison. You can now filter out these differences by defining the corresponding equivalents, e.g. 1=yes, 1=ja, yes=ja, 0=no, 0=nein, no=nein etc.




Proceed as follows to activate one or more filters :


1. Click Filters.


2. Select "Enable filters". (The filter icon changes from gray to black).


3. Select the filter(s) that you want to activate.


4. Close the filter window .