Add needed rows/columns if current row/column number is lower than pasted

Add needed rows/columns if current row/column number is lower than pasted

Posted by: razeris563 on 7 September 2021, 6:15 am EST

• 

  razeris563

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 7 September 2021, 6:15 am EST

  Hey guys, i would like to ask how should I add new rows or columns, if i want to paste multiple copied rows/columns and my current sheet doesn’t have that many rows/columns?

  Currently as it is, it won’t do anything. In google sheets for example, it adds the needed amount of rows or columns for you to be able to paste what you’ve copied.

  Thank you a lot for the help!

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 8 September 2021, 4:45 am EST

  Hi,

  For this, you may set allowExtendPasteRange options true. Please refer to the following code snippet and let us know if you face any issues.

  
  spread.options.allowExtendPasteRange = true;
  
  

  ClipBoardOptions: https://www.grapecity.com/spreadjs/docs/v14/online/clipboard.html?highlight=allowextendpasterange%2C

  Regards,
  
  Avinash