xlLens 使用手冊

差異類型與篩選

Understand value, formula, format, structure, VBA, connection, name, comment, and protection changes.

In short: Understand value, formula, format, structure, VBA, connection, name, comment, and protection 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

Workbook semantics

Sheet order and visibility, rows, columns, merged cells, names, protection, notes, VBA source, and connection package metadata appear as dedicated change types.

Next step

下載試用版