Unexpected cell behavior during plating

[charles-cowart]

• A copy/paste operation on a cell blows away everything in the cell, not just any highlighted text in the cell, this is not normal behavior.
• Users can't multi select cells and clear contents using the delete key. This is also expected behavior.
• If you copy/paste a specimen_id (be it sample_id, tube_id, etc.) into a cell, you will not get a drop-down menu with the study_id.specimen_id listed, even if a match should have been found.
• If you type in a specimen_id, the drop-down will appear, but if it goes away for whatever reason, it can't be made to reappear unless the user retypes the id.
• Note that in spite of the cell not turning red because a match with a study_id.specimen_id pair was found, the contents of the cell itself will not be changed to the fully-qualified version.

Likely, the list of specimen_ids for each attached study should be pulled down locally, the cell values can be matched to fully qualified study_id.specimen_id pairs locally, and the cells updated with fully qualified values. In the rare cases where a specimen_id can resolve to more than one study (more than one fully qualified pair exists), the cells can change into a new color representing ambiguity, and a pull-down menu with all pairs can be presented when the user clicks on the cell (because we can't have multiple drop-down menus appear for the case of multiple ambiguities).

[charles-cowart]

Overlap with #553