3 ms·
Spreadsheets are fine. Excel is not. Excel conflates the ideas of data and presentation. This leads to an entire class of headaches that just aren't necessar
by mulmen 7y ago
Spreadsheets are fine. Excel is not.
Excel conflates the ideas of data and presentation. This leads to an entire class of headaches that just aren't necessary. It's the desktop application equivalent of the string 'null'.
If the spreadsheet layer (calculations and formatting) was separate from the data layer (types and values) then we could all be happy.
Wrap that up with a UI that wasn't designed at an office in Redmond (or for a web browser) and you'd really have a winner.
- t0astbread 7y agoThis sounds interesting but I don't quite understand. Is this idea documented somewhere more detailed?
- mulmen 7y agoNot really, maybe I should write something. It's a thought I frequently have in the depths of Excel Hell. I thought for a long time about why Excel is so frustrating to me. I think fundamentally it comes down to Excel putting the spreadsheet ahead of the data. If the data was clearly separated from the spreadsheet itself then the logic becomes much easier to reason about and test and the data is no longer susceptible to the Excel data loss. The display layer really needs to be logically separate from the data. For example if I change a column format from text to number and back I should not lose the leading zeros in the actual data. Spreadsheet tools are great visual programming environments but they are lousy databases. The data layer in Excel leaves a lot to be desired but there's really no reason a spreadsheet has to be so limited. Basically I'd like to see some kind of hybrid SQL(database) client/Spreadsheet UI/Pivot Table builder where all three concepts are first class.