Copy/Paste not working

Copy/Paste not working

Posted by: tosch on 16 November 2018, 3:23 am EST

• 

  tosch

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 16 November 2018, 3:23 am EST

  Attached is a small sample app that I use in my app which runs fine with spread version 7.x but not anymore with 11.x

  Just start the app and it will load a file. Then click on the ‘copy column’ button. This will copy the column to the left of the current column to the current column.

  Thomas

  SpreadCopyColumn.zip

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 19 November 2018, 5:29 am EST

  Hello,

  We are able to replicate the issue and hence we are escalating the same to the concerned team for the fix.

  Tracking id for your issue is #267416

  We will update you as soon as we hear anything from them.

  Thanks,
  
  Reeva

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 19 November 2018, 11:59 pm EST

  Hello,

  According to our developer, since you are using clipboard copy & paste to column but there’s locked cells in copied range so it can’t be pasted.

  In our older version, we missed many implementation to check for locked cells during pasting so this case can still work.

  For this sample to work, you need to unprotect sheetView first before perform pasting as given in code below:-

   fpSalary.ActiveSheet.Protect = False
   fpSalary.ActiveSheet.ClipboardPaste()
  

  Hope it helps.

  Thanks,
  
  Reeva

• 

  tosch

  • Post Options:
  • Link
    Copy

  Posted 21 November 2018, 4:08 am EST

  Reeva,
  
  setting Protect=false solved my problem. Thanks.

  Thomas

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 26 November 2018, 12:24 am EST

  Hello,

  We are glad to know that your issue has been resolved.

  Thanks,
  
  Reeva