One simple thing I think missing from Excel is 1st class table/data sheets. A datasheet can have only well-defined manual/computed columns. They are independent

One simple thing I think missing from Excel is 1st class table/data sheets. A datasheet can have only well-defined manual/computed columns. They are independent of worksheets so won't hurt existing use-cases / backward compatibility. I am not sure of forward compatibility. We can add validations and type to sheet so that the data consistency is not an issue. A good UI of scratch sheet/worksheet will allow for adhoc work on it. Also, we can label formulas in a worksheet (aka variable) that should simplify the code.