News for hackers. Stuff that matters.
Re:Missing Covid-19 test data was caused by the ill-thought-... by rahimnathwani on Monday October 05, 2020 @03:51PM (#24691334)
When I use Excel to open a CSV with too many rows, I get an alert saying 'File not loaded completely'. I have to dismiss it by clicking 'OK' before I can interact with the spreadsheet.

So Excel isn't silently discarding data.

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."