> I know of some that are left in for backwards compatibility, but otherwise its clearly working well enough to be the dominant tool for so many industries.

Some sort of a strict mode or a way to designate data types on table columns would solve probably 90% of the issues people have with Excel.