in viz both have their own advantages. but generally the UI itself should have an option to change from one mode to the other.

i like the interface in Google spreadsheets for this.