 |
GreatManuals.com |
|
|
Rows Comparision Rows comparison and 'Similarity Rate' value are used only within the "Line by Line" comparison method. In this case a second comparison pass will be made for separate changed blocks. Depending on the data structure, you should use various ways of rows comparison and various 'Similarity Rate' values.
The "similarity" percent of two rows is a calculation of the extent to which both rows have been modified. For example, two rows "0123456789" and "1123456700"are considered similar if a "similarity" percent is set to 70. Excel Compare will not print these rows as having been modified. Increasing the "similarity" setting to a higher number triggers Excel Compare to become more sensitive to modifications. A "similarity" setting of 85 will show both of these rows to have been modified. Ways "Cell-by-cell, for lists #1" and "Cell-by-cell, for lists #2" are used only for databases comparison or lists that have no deleted or moved columns. The "Cell-by-cell, for lists #1" way is used for the rows containing cells with long strings since takes into account a length of cells values. These two ways have the identical high speed of work. Example 1. Compare reports applying a different 'Similarity Rate'. We have two worksheets that do not contain absolutely identical rows:
Choose the "Cell-by-cell, for lists #2" way and set the 'Similarity Rate' value to 82%. The program will not find modified rows:
If you set the 'Similarity Rate' value to 80% the 'Differences Report' will look as follows and the most correct:
If you reduce the 'Similarity Rate' value up to 70% any of two rows can be considered as a modified row:
Ways "Letter-by-letter" and "Cell-by-cell" are used for comparison of lists that can have the deleted or moved columns. The "Letter-by-letter" way is used for rows containing cells with long strings since concatenates values of all row cells into a single string. The "Letter-by-letter" way the slowest. The "Cell-by-cell" way has average speed of work. Example 2. Compare reports of two ways: "Cell-by-Cell" and "Cell-by-cell, for lists #2". We have two worksheets:
After comparison the 'Differences Reports' looks as follows (please pay attention to lines 14 and 15):
|
