Would love any advice on UX practices / UI ideas for allowing users to quickly enter lists of values in a single spreadsheet cell that represent something related to a specific line and can be picked from a finite set of admissible values. So far the best I can conceive is a textInput with autocomplete functionality - similar to this one but with the autocomplete functionality working for each of the values being entered in the cell. I'm very open to suggestions though...
thanks
f
What about how gmail does autocomplete per name when addressing email? Apple Mail does something similar, but has a better UI IMO. Check out jQuery Email Address Input for some more info.