Redlineo

Understanding the outputs

Understanding the outputs

The report page (Word outputs)

With Report on, the redline's first page is the comparison report:

  • Every change, numbered — grouped by sheet (Excel pairs) or under the nearest heading (Word pairs). Nothing is truncated away: the numbers are citable ("see item 37" in an objection response).
  • Click-to-jump: each change line is a link — Ctrl+Click jumps to that change in the document. This matters most for the baked output, which has no tracked changes for Word's Review navigation to walk.
  • Summary statistics (added / removed / changed / moved / formatting) and, for rate workbooks, the rate impact line ("6 cells changed — average +13.8 %, range +0.1 % to +25 %").
  • Color key (baked output only): the effective insertion/deletion colors shown as real colored samples. Tracked output gets no key — Word colors revisions with each viewer's own palette.
  • ✔ Verified stamp: this specific output was checked — accepting all changes reproduces the revised document's text, rejecting all the original's.
  • Certificate: SHA-256 fingerprints of the exact input files. Anyone can recompute them (sha256sum) and confirm which inputs produced this output.
  • Filing metadata block: the extracted properties (found / not found, with sources), the selected profile, drift between versions, and each assertion's ✔/✖.
  • Moved text is recognized: identical content deleted in one place and inserted in another reads as "moved (content identical)", not as a false delete + insert.
Comparison report — top of page

✔ VERIFIED

6 cells changed — average +13.8 %, range +0.1 % to +25 %.

37. Sheet 'BOP' · G12   1.0001.138  (+13.8 %)

The same information is embedded machine-readably inside the file as pleodox/change-set.json — a .docx/.xlsx is a zip, so unzip -p redline.docx pleodox/change-set.json reads it directly.

The Excel colored review copy

The real revised workbook, annotated:

  • green — inserted cells
  • amber — changed (previous value on a was: … comment)
  • red + strikethrough — deleted rows
  • Green fill = inserted cells, amber = changed (the previous value rides a was: … cell comment — merged into any comment the cell already had, never lost), red + strikethrough = deleted rows, spliced back at their aligned position. A wholly removed sheet is recreated struck-through with a red tab; a wholly added sheet shows all green.
  • The prepended Legend sheet is the report: the color key, the numbered change list (each line links to its cell), rate impact, warnings, the ✔ verification stamp and the certificate.
  • Formulas stay live, exactly as in the revised workbook — except on a sheet where a deleted row was spliced back (shifting rows would corrupt references), where they are frozen to their last shown values; the Legend names any such sheet.
  • Verification is kept: replaying every recorded change must reconstruct both the original and the revised values.

This is a review view — the Word redline remains what you file.

Changed content only

One checkbox, honest excerpts everywhere. The unit follows the output:

OutputWhat you get
Excel pair → Word redlineOnly the print pages containing changes; each gap says "— print pages i–j of N unchanged — not shown —". A wholly unchanged sheet contributes no page at all. Sheets too large for a full Word render (over 2,000 print-area rows) use this automatically, with a warning.
Word pair → Word redlineOnly the changed paragraphs/tables, plus one context block each side; gaps say "— N unchanged paragraphs omitted —". A wholly unchanged section disappears entirely (noted at the next kept section).
Excel colored copyUnchanged sheets are hidden — never deleted (formulas keep their references); right-click a tab to unhide. The Legend states the count.
— 32 unchanged paragraphs omitted —

In every case the report still lists all changes with working links, and the omissions are declared both on the report and in the body. The full redline remains the filing artifact — regulators expect complete documents; the excerpt is for reading, sharing and objection-response drafting.

Verification, in one paragraph

After producing an output, the tool independently simulates accept-all and reject-all on it and compares the resulting text against the actual input documents (Excel copy: replays the change stream against both grids). Pass → ✔ badge, stamp, X-Compare-Verified: true. Fail → the output is still delivered, loudly, with a warning naming where the texts diverge. The claim covers text content; formatting-only differences are outside it.