Results > Differences

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

Toolbar for Missing Rows

Toolbar for Duplicate Database Records

Toolbar for Duplicate Database Keys

Toolbar for Different Cells

Toolbar for Different Comments

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

Select difference

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

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.

Transfer different columns/rows from target to source worksheet

As above, but in the other direction.

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.

Delete different columns/rows in the target worksheet

As above

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.

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.

Settings

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

•

Updating options
This option is only applicable for missing columns and rows.
Here you can specify which data and formats should be transferred. The following options are available:

basic: only cell values and the cell alignment (left, right, centered) are transferred
Medium: additionally the background color is transferred
full: all data and cell formats are transferred

This setting is especially important for large Excel files, because the data transfer can be very slow for large data.

•

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.

•	Show details of cell differences Here you can determine whether the detailed information of the cell differences is to be displayed inline in the grid or as popup. By default, the differences are displayed inline in the grid.

•	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.

Detail view of text difference

In the case of text differences (yellow symbol, "Differences in entered cell values and/or formulas"), you can move the mouse over the desired difference (do not click), whereupon the detailed view of the text difference is displayed as a tooltip.

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".