Posted 8 September 2017, 1:38 pm EST
I have a spread with cell types that vary by row.
For example, the first row is text, the next several rows are numeric, there are three rows of combos (that display text with numeric values "behind" them), more numeric rows, and so on.
The behavior I'd like is:
- Ctrl-c, ctrl-v and ctrl-x should work whether or not cell is in edit mode
- A context menu should allow cut/copy/paste/delete whether or not cell is in edit mode
- Cut should not clear the combos
- Paste should honor the cell types so that if I copy a range of cells that contain numbers and paste them into a range that contains combos, the combos don't change.
If possible, I'd like to acheive this without writing lots of code to search through the clipboard data and the destination cells and decide on a cell-by-cell basis what to do.
Can someone suggest an approach to take that makes the most use of built-in Spread features?