News for hackers. Stuff that matters.

A comment on An alarming number of scientific papers contain Excel errors. Parent comment

Re:An alarming number of scientific papers contain Excel errors by 7952 on Saturday August 27, 2016 @04:57AM (#12371624)
It is damning that you cannot use a basic computer tool for anything that is large, complex, or important. Isn't that exactly what computers are for? Call me idealistic but I want a spreadhseet that can handle milions of rows. Maybe add a "strict" mode to keep people out of trouble.
[ Parent | on HN ]
Re:An alarming number of scientific papers contain Excel errors by cm2187 on Saturday August 27, 2016 @05:00AM (#12371628)
You could have an option to disable any formatting in a tab, and then Excel should be able to handle a billion rows in that tab. But you can't have all the flexibility of Excel on a massive scale. Even a laptop today is insanely fast and has an insane amount of memory.
[ Parent | on HN ]
Re:An alarming number of scientific papers contain Excel errors by arethuza on Saturday August 27, 2016 @06:14AM (#12371766)
PowerPivot in Excel does allow you to have millions of rows in tables - mind you that isn't in the standard spreadsheet functionality, but it is there.
[ Parent | on HN ]