I have an app that presents as its interface a "spreadsheet" consisting of 8 data columns by N rows
The user has basically 3 operations
- Add a new row
- Delete existing row
- Edit existing row
I have a few ideas, but not really sure which one would "feel" best.
- Use SINGLE click to select row, and display a data entry form... If the row was blank, add it, otherwise update it. an option on the data form would be to "delete"
- Same as above but with DOUBLE Click, or Right-Click?
I thought about cell level edit for existing records, but there are a few attributes that don't appear on the spreadsheet, and apply to the entire row, not any specific cell...
I don't want to use menus, as this is supposed to end up as a custom control, so any menus would be up to the app developer at that point to call the appropirate class functions