0001. Refuse numeric IBAN cells¶
Status: Accepted
Date: 2026-09-18 (practised since the first release; written down today)
Deciders: maintainer
Context¶
Excel converts anything that looks like a number into a number. An
IBAN pasted into a General cell loses its structure before any
export, and a corrupted debtor account is the failure a bank cannot
detect.
Options considered¶
Coerce: turn the number back into text and carry on. Fast, and silently wrong whenever the coercion is lossy.
Refuse: stop the load with an error naming the row when any IBAN column cell arrives as a numeric type.
Decision¶
Option 2. The type guard at load time and the mod-97 checksum in the core afterwards are two independent layers; the first exists because the second cannot see what Excel already destroyed.
Consequences¶
load and load_streaming raise before any record is produced. The
guard is tested with workbooks whose IBAN cells are numeric, and the
README states the behaviour in its first section.