Could not copy/paste row/columns to other sheet

Could not copy/paste row/columns to other sheet

Posted by: timzod on 9 October 2017, 11:34 pm EST

• 

  timzod

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 9 October 2017, 11:34 pm EST

  I have tried with online demo (https://www.grapecity.com/en/demos/spread/JS/InspectorSample/ ) and failed.

  There has two sheet A and B, A has 20 columns and B has 10 columns,
  
  when I copy a whole row from A to B , paste will failed
  
  but if I copy a whole row from B to A , paste will succed.

  It seems that current spreadjs can only copy rows(less columns) to other sheet rows(more columns) , BTW copy a whole columns also has similar problem

  step to recreate with InspectorSample

  1. create a new sheet with name sheet10 by click icon ‘+’ (the sheet has columns A~T)
  2. switch to sheet Formula , copy the row 21
  3. switch to sheet10, click any row,try to paste , nothing happened

  I know it maybe lead to datastructure problem when copying between different sheet, but the cell in row 21 after G21 cell are all blank and maybe can be ignored when copy/paste.

  Can anyone help me on this problem?
  
  Thanks very much!

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 10 October 2017, 12:05 pm EST

  Hello,

  I am able to replicate this issue. The behavior is because of the difference in the number of Columns. To workaround the issue you would need to either set the number of columns in the newly added sheet as same as the number of column in Formula sheet or just select the data cells instead of the complete row.

  I will check with the development team if this is a design behavior and let you know.

  Thanks,
  
  Deepak Sharma

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 11 October 2017, 10:08 am EST

  Hello,

  I have reported this issue to the development team as a bug, I will let you know once I get an update on this.
  
  The tracking id for this issue is :247197

  Thanks,
  
  Deepak Sharma

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 13 October 2017, 2:38 am EST

  Hello,

  This is found to be a design behavior, when target range is smaller than source range, the paste behavior will fail. You would need to set the “allowExtendPasteRange” to true in order to paste extended range.

  Thanks,
  
  Deepak Sharma