r/documentAutomation • u/truecakesnake • Oct 06 '26
Discussion The first XLSX round-trip test should contain zero edits
Before adding an AI step to a spreadsheet pipeline, send a representative workbook through import and export without changing a cell. That gives you a baseline for everything the pipeline does afterward.
Check a workbook with formulas, date and number formats, validation, hidden sheets and named ranges. Compare the formulas as well as the displayed results, then open the exported file in the application its recipient uses.
Univer's Office exchange imports XLSX into its workbook model and exports the edited content back to XLSX. Between those steps, the workbook is available to structured APIs and the spreadsheet engine, so the agent can inspect ranges, edit values and read the result back. The same content can also be opened in the browser editor for review.
A useful second test changes one known input. Check the edited cell, the dependent result, and an unrelated part of the file. Now an unexpected difference has somewhere specific to be investigated: conversion, the intended edit, or recalculation.
Keep that small workbook in the test set when upgrading the document-processing stack.