IronFuentesEspañol
P07 · 14 rules · 14 package cases

Data diff between two sheets

Paste two versions of a sheet and it tells you which row and which cell changed.

Verified calculationThe result depends only on your data and on formulas covered by the tests.

The interface is in English, but what the engine writes is not: rule messages, error messages, audit-log entries and the catalogue of nodes and patterns come from the specification packages, which are written in Spanish and are the source of truth. Their codes are always visible.

Paste two versions of the same table and it tells you exactly what changed: which row was born, which disappeared and which cell differs, with its old value and the new one.

Previous version

New version

Detected separator: comma

Result

Nacieron 1 filas, desaparecieron 1, cambiaron 3 filas y 3 celdas.

Born
1
Gone
1
Rows changed
3
Cells changed
3

Every difference

Every difference between the two versions of the sheet, with the row, the column and the before and after values.
KindRowColumnBeforeAfter
row added1005——1005
row removed1004—1004—
cell changed1001seats3028
cell changed1002nameAlgebraLinear Algebra
cell changed1003statusopenclosed

Audit log

3 decisions
  1. P07-R-001

    La identidad de fila la declara quien compara. Sin clave única no hay diff confiable, y no se empareja por parecido.

  2. P07-R-012

    Reordenar filas no es cambio de datos: no se reporta salvo que se pida.

  3. P07-R-013

    Orden por tipo de cambio, clave y columna, para que dos ejecuciones se puedan comparar.

engine 1.0.0 · rule pack 0533e01987f42460…