3 ms·
> This is indeed user incompetence, but so far every news source quoted the official PR and said it was an "Excel Problem". It's been quoted/reported as "an i
by danudey 6y ago
> This is indeed user incompetence, but so far every news source quoted the official PR and said it was an "Excel Problem".
It's been quoted/reported as "an ill-thought-out use of Excel", when in reality it's "poor use of an older file format".
There's also a lesson to be had here about validating your data conversions. Especially for critical things like this, it's always a good idea to perform the conversion from the old file format to the new one, and then to go back and extract the data from the new one to compare to the source data.
This can also find issues like Excel cluelessly assuming a field is a date, PHP automatically converting a string which happens to only contain numbers into an integer, and so on.
From what I can tell, that sort of thing, assuming proper monitoring (which is a huge assumption), would have detected this immediately (plus however long until someone notices the error e-mail, etc.).