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.