Worksheet size limit

[michaelk]

This has never been something I ever worried about before now…

 

But is there a hard limit to the number of rows in a worksheet?

 

And is that number 4094?  

[Pat Stanford]

It certainly appears to be true.

[Sam Jones]

Fascinating, 2 short of 8 universes

[michaelk]

21 minutes ago, Sam Jones said:

Fascinating, 2 short of 8 universes

That's exactly what I thought!  There must be 2 bits for something else.  Number of columns?  Display headers?

[line-weight]

So, we can add Vectorworks to the list of applications unsuitable for managing large scale public health crises.

 

https://www.theguardian.com/politics/2020/oct/05/how-excel-may-have-caused-loss-of-16000-covid-tests-in-england

[Jeff Prince]

3 hours ago, line-weight said:

So, we can add Vectorworks to the list of applications unsuitable for managing large scale public health crises.

 

https://www.theguardian.com/politics/2020/oct/05/how-excel-may-have-caused-loss-of-16000-covid-tests-in-england

 

Thanks for sharing that.

From the article:

Quote

Errors from the spreadsheet software have even changed the very foundations of human genetics. The names of 27 genes have been changed over the past year by the Human Gene Nomenclature Committee, after Microsoft’s program continually misformatted them. The genes SEPT1 and MARCH1, for instance, have been changed to SEPTIN1 and MARCHF1 after they were repeatedly turned into dates, while symbols that were common words have been altered so that grammar tools didn’t autocorrect them: WARS is now WARS1, for instance.

 

It's amazing the people doing this kind of work don't know how to use their tools properly or how they should specify better tools for the job.

[line-weight]

I bet you could find some architectural features in real life buildings that have become less or more popular as a result of how easy or difficult they are to model in CAD/BIM software.