Spread V11: Pasting range of cells from excel is not working as expected

Spread V11: Pasting range of cells from excel is not working as expected

Posted by: viswanath.malepati on 19 February 2018, 6:13 am EST

• 

  viswanath.malepati

  • Post Options:
  • Link
    Copy

  Posted 19 February 2018, 6:13 am EST

  Hi,

  After sheet gets initialized, we have are setting following:

  sheet.options.clipBoardOptions = GC.Spread.Sheets.ClipboardPasteOptions.values
  

  and then tried to copy a range of cells (with some format like background color, applied) from excel to spread sheet and I am seeing that along with values, format is also being copied. This is not happening in Spread V9.

  in Spread V9 we used to use the following:

  sheet.clipBoardOptions(GcSpread.Sheets.ClipboardPasteOptions.Values);
  

  How to fix this?

  Thanks,.
  
  Viswanath

  paste V9 vs V11.zip

  Note: I have attached 2 HTML files with v9 version of setting ClipboardPasteOptions and V11 version of setting ClipboardPasteOptions. So, open each of them and then copy paste cells unto each of them, you will see the difference.

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 20 February 2018, 11:03 am EST

  Hello,

  I am able to replicate this issue at my end. I have reported this to the development team. I will let you know as soon as I get an update on this. The tracking id for this issue is 254643.

  Thanks,
  
  Deepak Sharma

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 6 March 2018, 2:14 am EST

  Hello,

  This issue has been fixed in SpreadJS v11.0.4. You can download the same from here:
  
  http://cdn.grapecity.com/spreadjs/11.0.4/Files/SpreadJS.Release.11.0.4.zip

  Thanks,
  
  Deepak Sharma