<< Click to Display Table of Contents >> Compare - Filters |
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. If you want to filter empty cells, enter [empty] or leave the field blank. You can also filter partial equivalents. Pad the search string with two asterisks: *october* = *november* that would filter differences like =SUM('October 2019'!D10:D25) v =SUM('November 2019'!D10:D25). |
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 .