Add Cell Editing to TRC

[tnrich]

• powers the upload wizard Add wizard helper to upload CSV/xlsx file uploads #293
• add smart increment on cell drag handle (cases described below) (for string and number fields only!!!)

Dragging just 1 cell with nothing before it (same as normal):

becomes

Dragging more than one cell incrementing:

becomes

Dragging more than one cell incrementing with text and 0 before:

becomes

Dragging just one cell with increment before:

becomes

• make sure comma seperated vals can be pasted in (copied direct from CSV) need to allow for commas in quotes

• support addition of rows when pasting in data that overflows the bottom of the table

• validation needs to be rerun for affected rows on paste (not sure why it's not already?) (seems like it is in certain cases --> repro - upload affinity tags csv and copy sequence from type row to another row)

• make sure download of files from file list is working

• make sure remove rows works on the last row if it is the only row selected

• add an Add 10 Rows button to the bottom of the table

  • make sure it still shows up when there is no data
  • make sure it doesn't show up when Show only rows with errors is enabled

• when deleting rows, validation needs to be removed for those rows

• add cell selection abilities

• add click to edit cell

• add dropdown editable cells

  • dropdown cell should have a little click to edit icon:

• add bottom right drag to copy cell to cells below functionality

• make sure bottom right drag works with boolean column

• add numeric input

• support paste functionality

• add column auto validation/formatting

  • drop-down/boolean/numeric column should auto format malformed incoming data

  • malformed data that can't be auto formatted should display as a red cell

  • allow passing additional validation/formatting functions on the column schema

• dragging the cell drag handle should allow the table to scroll if necessary

• take out the padding on the dropdown cell when it is in edit mode

• add a tiny margin right on the table when in cell editing mode to prevent unnecessary horizontal scrollbar when selected (caused by cell dropdown dragger)

• Support selection of multiple cells

• support copy of multiple cells

• support addition of rows

• start single cell edit on hitting enter

• do NOT send edit action if no edit was actually made to the cells

• fix dropdown styling(?) weirdness:
  https://user-images.githubusercontent.com/2730609/199064687-9739bfc4-9769-4a46-8624-fde46d4e1286.mov

• add cell delete + cell cut functionality

• add tests for all the above bullet points (where applicable)
  Stretch Goals:

• allow cell drag to occur across multiple columns if multiple columns are selected in a contiguous group

[tgreen7]

pasting logic:

1. If there is a single thing in clipboard (no newlines and no tabs), paste that into every selected cell
2. try to paste in the same layout that the copy was in should match cell to cell where possible in selections. extra cells from copy that are not in new selection will be ignored.
3. if only a single cell is selected when pasting then the copied format should try to paste all cells in same format until it runs of edge

[tnrich]

Closing this as it has been completed!