News for hackers. Stuff that matters.
Re:Excel is pretty dang cool by lenkite on Friday August 12, 2022 @04:43PM (#32443664)
If your data is <10k rows, Excel is great. After that lots of stuff stops working. Stick to R or Python data science libraries for real work.
Re:Excel is pretty dang cool by gytdev on Sunday August 14, 2022 @09:44AM (#32459184)
i'm using a 35k row excel daily without any hiccups. Sorting, Vlookup, running formulas for all rows
Re:Excel is pretty dang cool by MikusR on Friday August 12, 2022 @05:02PM (#32443870)
Which stuff exactly?
Re:Excel is pretty dang cool by lenkite on Friday August 12, 2022 @05:10PM (#32443958)
filtering drop-down 10k list limit is the most obvious one. There is also the hard traditional 1,048,576 limit which many hobbyist Covid tracking folks ran into.
Re:Excel is pretty dang cool by lostlogin on Friday August 12, 2022 @06:34PM (#32444769)
Hobbyists and the UK government.

They somehow cooked up a spreadsheet that make them hit the limits much earlier.

https://www.bbc.com/news/technology-54423988.amp

Re:Excel is pretty dang cool by Closi on Saturday August 13, 2022 @03:07AM (#32447585)
This was a massively outdated version of the software - it’s not entirely surprising that if you use c10-year old software there are more limits.

Excel has grown hugely since then.

Re:Excel is pretty dang cool by lenkite on Saturday August 13, 2022 @08:01AM (#32449090)
Re:Excel is pretty dang cool by Closi on Monday August 15, 2022 @02:56AM (#32466639)
Of course there are still limits, the article was talking about the 2003 limit of 64k lines which has now been increased to 1m.

You can’t exceed these limits without being heavily alerted/warned by the application too.

Every spreadsheet application and database has these sort of limits anyway, eg:

* Google Sheets limits total cells, although can only handle a tiny fraction of what excel can.

* Postgres limits columns to 1600 (much less than excel)

* Mongo limits document size

Re:Excel is pretty dang cool by lostlogin on Saturday August 13, 2022 @04:45AM (#32448027)
That’s completely alarming and much worse.