3 ms·
The issue for the spreadsheet is always around data-integrity, people start typing random things in their Excel and then it's a mess to try to make sense of the
by realusername 9y ago
The issue for the spreadsheet is always around data-integrity, people start typing random things in their Excel and then it's a mess to try to make sense of the data. I would not mind Excel much if it was strongly typed instead.
- ModernMech 9y agoBut being strongly typed would remove a lot of the usability that makes Excel the most widely used programming language among non programmers.
- beefield 9y agoI think there would be space for a middle ground solution where you could define a sheet "type" to something like "datatable" that would enforce data types on columns, only allow data entered a row at a time and if calculated columns were there, would enforce same formula in each row.
- paulryanrogers 9y agoIsn't that what Microsoft Access was?
- fiatjaf 9y agoPerhaps there's something to try in that space.