Insert row and copy formatting down

Insert row and copy formatting down

Posted by: dean.kinnear on 3 January 2023, 10:09 am EST

• 

  dean.kinnear

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 3 January 2023, 10:09 am EST

  Is there a way to insert rows and copy the formatting with it as Excel does?

• 

  dean.kinnear

  • Post Options:
  • Link
    Copy

  Posted 3 January 2023, 10:37 am EST

  Nevermind, I got it working with addRows and copyTo.
  
  Thanks anyway!

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 4 January 2023, 1:08 am EST

  Hi Dean,

  We are happy that your issue has been resolved. You could monitor the RowChanged Event and then copy the formatting of the previous rows to match the Excel’s behavior. In the arguments of the RowChanged Event, you can check for the propertyName “addRows” and the rowIndex of the newly added row(s).

  RowChanged Event: https://www.grapecity.com/spreadjs/api/classes/GC.Spread.Sheets.Events#rowchanged

  Regards,
  
  Ankit