View Single Post
Old 09-24-2018, 06:38 PM   #8
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,789
Karma: 30237628
Join Date: Mar 2012
Location: Sydney Australia
Device: none
The Ctrl+C/V in cell edit are distinct from the Ctrl+C/V in the book list. So assigning them to metadata edit copy cells and paste cells does no harm.

Doing cell by cell copy and paste would require 12 steps for each cell.
  1. go to the copy from book
  2. go to the cell (Tab, Tab, Tab...)
  3. open the cell (F2),
  4. select the value (Ctrl/A)
  5. copy the cell (Ctrl+C)
  6. close the cell (Enter)
  7. go to the copy to book (Ctrl+Home - assuming it's at top of list)
  8. go to the cell (Tab, Tab, Tab...)
  9. open the cell (F2},
  10. if cell is not empty - clear the cell (Ctrl+A, Del)
  11. paste the copied value (Ctrl+V)
  12. close the cell (Enter)

I copy 11 columns in one fell swoop with 4 steps
  1. go to the copy from book
  2. copy the non-excluded cells (Ctrl+C)
  3. go to the copy to book (Ctrl+Home - assuming it's at top of list)
  4. paste the copied cells (Ctrl+V)

Unlike some I'm not inclined to count key-presses or clicks, but 4 fairly safe key-presses versus ~200 error prone key-presses, is a saving worth having - IMO.

- there's probably a use case for a single cell copy and paste feature.

BR
BetterRed is offline   Reply With Quote