In short: Separate formula source, calculated value, relative-reference alignment, and array formula range changes.
Cell semantics
Input values, calculated values, formulas, and number formats are classified independently so the result explains why a cell changed.
- Value and calculated value
- Formula and array formula range
- Font, fill, border, alignment, and number format
Smart
Smart Alignment fingerprints sheets, rows, and columns, anchors unique content, and realigns insertions or deletions. Both original addresses remain attached to every difference.