Look for the duct tape

Re:Look for the duct tape by realusername on Saturday March 24, 2018 @12:07PM (#16667292)

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.

[ Parent | on HN ]

Re:Look for the duct tape by ModernMech on Saturday March 24, 2018 @12:17PM (#16667357)

But being strongly typed would remove a lot of the usability that makes Excel the most widely used programming language among non programmers.

[ Parent | on HN ]

Re:Look for the duct tape by beefield on Sunday March 25, 2018 @06:39AM (#16671597)

I 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.

[ Parent | on HN ]

Re:Look for the duct tape by fiatjaf on Saturday March 24, 2018 @09:50PM (#16670199)

Perhaps there's something to try in that space.

[ Parent | on HN ]

Re:Look for the duct tape by paulryanrogers on Saturday March 24, 2018 @04:22PM (#16668696)

Isn't that what Microsoft Access was?

[ Parent | on HN ]