Differences

<< Click to Display Table of Contents >>

Navigation:  Results Tab >

Differences

Previous pageReturn to chapter overviewNext page

 

In the lower part of the form, the details of the difference selected in the upper part are displayed.

result_form_overview_detail

Toolbar for Missing Columns

result_det_columns

Toolbar for Missing Rows

result_det_rows

Toolbar for Duplicate Database Records

result_det_records

Toolbar for Duplicate Database Keys

result_det_keys

Toolbar for Different Cells

result_det_cells

Toolbar for Different Comments

result_det_comments

 

 

 

All differences can be processed, transferred or deleted with the following keys:

 

results_det_goto_buttons

Select difference

 

With these buttons you can navigate to the next or previous difference.

 

results_det_update_cols1
 
results_det_update_rows1
 
 

Transfer different columns/rows from source to target worksheet

 

With these buttons, the columns/rows are copied from the source to the target worksheet (from left to right). It is possible to copy just the selected column/row or all columns/rows. Once the columns/rows have been copied, they are displayed in red.

 

These commands are also available in columns that contain at least one difference.

 

results_det_update_cols2
 
results_det_update_rows2
 
 

Transfer different columns/rows from target to source worksheet

 

As above, but in the other direction.

 

results_det_delete_cols1
 
results_det_delete_rows1

Delete different columns/rows in the source worksheet

 

With these buttons, the columns/rows in the source worksheet (left) will be deleted. It is either possible to delete all or only the selected column/row.

 

results_det_delete_cols2
 
results_det_delete_rows2

Delete different columns/rows in the target worksheet

 

As above

 

results_det_update_cells1
 
results_det_update_comm1

Transfer cell differences/comments from source to target worksheet

 

With these buttons, the different cell values ​​or comments are copied from the source to the target worksheet (from left to right). It is either possible to copy all or only the marked difference. Once the difference has been copied, it is shown in red.

 

results_det_update_cells2
 
results_det_update_comm2

Transfer cell differences/comments from target to source worksheet

 

As above.

 

Sort by row

With this button, the sorting of cell differences can be changed. As required, the cell differences can be sorted or grouped differently. The cell differences are by default sorted by rows and within the rows by columns.

 

 

Sort by column

The cell differences are sorted first by columns and within columns to rows.

 

 

Group by row

If you choose this option, the differences are grouped by rows. The differences can be transferred individually per line or in groups.

 
group_by_row

 

Group by column

If you choose this option, the differences are grouped by columns. The differences can be transferred individually per line or in groups.

 

group_by_column

 

This option is extremely useful when you are working with databases and need to update cell differences of a column. With just one click, all the differences of a column can be transferred.

 

results_det_settings

Settings

 

Depending on the difference type, different options can be set, which are described below.

 

Insert entire row or column
This option is only important if you are working with cell ranges. Normally, when you insert a row, the row will be also inserted outside the cell range. By disabling this option, the rows are inserted only within the cell range.
 
This option is only applicable for missing columns and rows.

 

Empty cells may overwrite data
If this box is checked, cells holding a value will be overwritten by empty cells, so that the previous value is lost. If this is not desired, you can disable the check box.
 

 

 

Differences displayed with an "at" sign (@)

If a number, date or Boolean value (true/false) is formatted as text, the corresponding differences will be displayed with an "at" sign (@). E.g., the number 123 formatted as text will be displayed as "@:123".