4 ms·

Which stuff exactly?

• lenkite 4y ago
  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.
  • lostlogin 4y ago
    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 https://www.bbc.com/news/technology-54423988.amp
    • Closi 4y ago
      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.
      • lostlogin 4y ago
        That’s completely alarming and much worse.
      • lenkite 4y ago
        Excel limits haven't gone away: https://support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3 https://support.microsoft.com/en-us/office/excel-specificati...
        • Closi 4y ago
          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