3 ms·

But they're pain in the ass to use, modify, and really feel as an afterthought which barely used by anyone. Compare this to "Numbers": you just enter any text i

But they're pain in the ass to use, modify, and really feel as an afterthought which barely used by anyone. Compare this to "Numbers": you just enter any text int row or column header and this text is immediately usable and visible as a range specifier in formulas. How intuitive is that? Also excel has (inner) tables inside of tables, with more restrictions that. Also excel even has SQL-dialect for querying columns. That's not important, important are defaults, and how your simple spreadsheet you can fit into a screen is going to evolve. Excel makes it VERY hard to not make a mess, even if you have time to learn it.

rvba 6y ago
You talk about SQL being great, yet you probably never had to download data from tables where the headers are German abbreviations, or gibberish due to 8 character limit in 1985.
- codesnik 6y ago
  SQL is greatER than excel's default mode of addressing data. As russian, I've worked with a very diverse data sources in different encodings during my career, fair amount of broken CSV's, xml's, etc, cleanups, joins, sqlite processing etc. And yes, many, many excel files used as a poor man's data entry software to cleanup. No german abbreviations, right, just poorly made russian transliterations.