News for hackers. Stuff that matters.
Re:Scientists rename human genes to stop MS Excel from misre... by ivalm on Thursday August 06, 2020 @12:18PM (#24072388)
LibreOffice also explodes (or at least did a few years ago) if you try to open a few hundred mb csv file. Definitely can’t do fast filtering on columns in large files.

Should those things be done in sql? Yes... could this data be sent as SQLite files? Yes... were they endemically sent as csv and nothing could change this? Yes...

Excel is by far the best of “spreadsheet” apps I’ve seen at munging through multi-hundred-mb csv files.

Re:Scientists rename human genes to stop MS Excel from misre... by ellis-bell on Thursday August 06, 2020 @02:00PM (#24073653)
makes sense!

fwiw, i have not tried to use libreoffice for any heavy lifting, unfortunately (fortunately?). i tend to use bash utils for that, and i 100% do not think telling people to "just use grep / awk / perl and csvcut" is by any means a solution.