Reading the result

These pages describe Calamo Pro 0.1 for Windows, Linux and macOS (beta). Download it and try it free for 14 days.

Result with changed rows, old values struck through next to new ones, and the row details on the right
Changed rows: each changed cell shows the old value struck through and the new one. The row details are on the right.

Changed, added, removed, duplicates

The tabs above the table switch between the lists (Ctrl+1 to Ctrl+4). Changed shows rows whose key is in both files with at least one different cell, Added rows only in B, Removed rows only in A, and Duplicates the rows that repeat a key. Row numbers are the rows as Excel shows them.

Rows or cells

Rows shows whole rows with the changed cells marked. Cells shows one line per changed cell: the key, the column, the value in A, the value in B and, for numbers, the difference.

Cells view sorted by the difference, largest first
Cells, sorted by Difference: the largest changes first.

Sorting

Click a column header to sort ascending, again for descending, and a third time for the file order. Numbers sort by their value, so 9 comes before 10. Sorting runs on the whole list, not only the rows on screen.

Search rows (Ctrl+F) keeps the rows that contain the text in any value, upper or lower case alike, and marks the text in the table. Esc or ✕ clears it. Click a column in the Columns list to see only the rows changed in that column.

Moving between changes and copying

A click picks a cell, and ← → move along the row. F8 jumps to the next changed cell and Shift+F8 to the previous one, row after row; on a Mac, where F8 plays music, use ⌥⌘↓ and ⌥⌘↑ (or Fn+F8). Ctrl+C copies the value under the cursor; a right click also copies the old value from A or the whole row, ready to paste into Excel.

The cell cursor on a changed status cell, the row details on the right
F8 moved the cell cursor to the next changed cell; the row details follow it.

Columns shown

Show columns above the table hides columns you do not need to see. Only columns with changes leaves the key and the columns where something changed, which helps in a wide file, and Keep the key in view holds the key at the left while the table scrolls sideways. This changes only the table: the comparison and the report keep every column. Drag the right edge of a header to make a column wider or narrower; a double click fits it to the values.

Result showing only the key and the columns with changes
Only columns with changes: the key, price and status.

Row details

Click a row, or move with the arrow keys, to see all its values on the right, with the old and new value of every changed cell.