Re:Missing Covid-19 test data was caused by the ill-thought-...
by piqufoh on Monday October 05, 2020 @04:15PM
(#24691518)
... Yeah, but if you have an automated script compiling the reports into one file, and you forget to add correct error handling .... you end up with this mess :-(
I suspect that wherever this foul up happened there wasn't someone sitting and clicking through sheets ignoring errors (I hope).
Re:Missing Covid-19 test data was caused by the ill-thought-...
by NelsonMinar on Monday October 05, 2020 @04:12PM
(#24691498)
The BBC reports the problem was saving spreadsheets with more than 65536 rows as XLS. Can you verify Excel also throws an error for that case?
Re:Missing Covid-19 test data was caused by the ill-thought-...
by sterkekoffie on Monday October 05, 2020 @04:36PM
(#24691743)
Yes, you get a warning that explicitly says "Data beyond 256 (IV) columns by 65,536 rows will not be saved."
So Excel isn't silently discarding data.