4 ms·
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 intera
by rahimnathwani 6y ago
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.
- NelsonMinar 6y agoThe 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?
- sterkekoffie 6y agoYes, you get a warning that explicitly says "Data beyond 256 (IV) columns by 65,536 rows will not be saved."
- piqufoh 6y ago... 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).