Spread 11.0.6 Copy paste doesnt copy value in adjacent columns

Spread 11.0.6 Copy paste doesnt copy value in adjacent columns

Posted by: Shalini89garg on 7 May 2018, 5:51 pm EST

• 

  Shalini89garg

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 7 May 2018, 5:51 pm EST

  Hi,

  PFA Example, we are facing one issue that on copy paste values its not getting copied to adjacent cell.can anyone please help on this.

  Below are the steps to reproduce

  1. Click on sheet 2.and put value as 2 in column tourinMth1 and value as 3 in column tourinMth2

  2. now select both these values and press Ctrl +C

  3. Now select All the columns after Total and press Ctrl +V.
     
     It doesn’t copy values.

  But same scenario works in Excel
  
  SpreadJSExportIncludeHeaders.zip

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 8 May 2018, 11:20 pm EST

  Hi Shalini,

  I am not able to replicate this issue at my end with the sample application you provided. I copied the cells as you stated and pasted in selected range. It pasted the values in column tourinMth1and column tourinMth2 respectively.

  Please refer to the attached video and let me know if I am missing something.

  Thanks,
  
  Deepak SharmaSpreadJSCopyPasteIssue.zip

• 

  Shalini89garg

  • Post Options:
  • Link
    Copy

  Posted 9 May 2018, 12:58 am EST

  Hi Deepak,

  I watched the Video, In the video after 3rd step ,i was able to see that values in mth 3 still remains 1 ,but same step if you try on excel ,it copies values from Mth1 ,

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 9 May 2018, 5:21 pm EST

  Hi Shalini,

  To achieve the behavior shown by Excel you can set:

   spread.options.allowCopyPasteExcelStyle = true;
              spread.options.allowExtendPasteRange = true;
  

  Thanks,
  
  Deepak Sharma