User Experience Stack Exchange is a question and answer site for user experience researchers and experts. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

A Win32 Application has a spread sheet. Spreadsheet has some columns. What columns and what type of data in each column? that's determined when we load the spreadsheet application, it reads the data from a database.

Now I am thinking of some good UI such that users will be able to enter new information to this spreadsheet, like a "Manual Entry" button. But how? should I just add a blank row at the bottom of the spreadsheet? should it brig a new dialog form to enter info?

What do you suggest?

enter image description here

share|improve this question

Some timesheet applications I've seen appear to address this problem in a clean way. Essentially, the spreadsheet consists only of rows the information already entered and one empty row at the bottom. The first cell in that empty row has a highlight that suggests input. Once information is entered in this cell, the others in the row (dependent on that cell's information) become active. Each cell is formatted to have data entered in its appropriate, required way (free text, dropdown, etc.). Once you've completed entering information in that row, the row is now an active part of the overall sheet and a new empty row appears at the bottom of the sheet. Based on what you've described, I think this would work for you.

It does not, however, allow you to move the position of the row within the sheet or allow you to insert a row. With a sorting mechanism in place this wouldn't matter but I don't know if sequence is important for your data.

share|improve this answer

It's depends on the use scenario of your spreadsheet.
A spreadsheat with a empty row is the right one, for entering many individual data (e.g. Excel). Entering data in a separate dialog should be used, if entered data have dependencies among each other or special conditions.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.