Yet it is the status quo expectation. If you offer up an alternative, do not be surprised if people expect it to be comparable in all features.

for the money your governments spend licensing MS products, they could develop libreOffice from scratch in better, faster and nicer looking.

Or just pay a few devs or a few hundred to make it better and still pay less in fees every year.

I doubt it's very uncommon for businesses to work with million+ row worksheets. Personal usage, I'd agree.