Copy / Paste behaves differently depending on the method used

Copy / Paste behaves differently depending on the method used

Posted by: kwallace on 9 June 2021, 12:55 am EST

• 

  kwallace

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 9 June 2021, 12:55 am EST

  Hello,
  
  If I have two different values in two different cells and copy one cell with CTRL+C, and then copy the other cell with right click → Copy. If I then go to paste the values, using CTRL+V pastes the value that was copied with CTRL+C and right click-> paste pastes the value that was copied with right click-> copy.
  
  This should behave instead where the last thing copied is always the thing that is pasted.
  
  Is this able to be fixed?
  
  Thanks.
  
  Keith

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 10 June 2021, 12:09 am EST

  Hi Kieth,

  This is the technical limitation of being a Web application. Copying the range using the context menu and copying the range using ctrl+c both uses different clipboards.

  performing copy with context menu uses the internal clipboard and by ctrl+c it uses the global clipboard and the web APP can not access the global clipboard that is why you are seeing the different result.

  Also, note that Excel has the access to the system clipboard that is why it may work in Excel.

  Currently, a new CLipboard API is being developed that you use but as of now, that has status as draft. You may read more about the new Clipboard API here: https://developer.mozilla.org/en-US/docs/Web/API/Clipboard_API

  Hope this clarifies the issue.

  Regards
  
  Avinash