We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

insert row and copy format

How can i keep the formatting when inserting rows dynamically?

sample below based on demos.

  1. before inserting a row, cells are italicized and center aligned (red arrows)
  2. after the row is inserted, the formatting of the cells is not copied in the inserted rows, not italicized and left aligned (red arrows)

2 Replies

JR Jose Ricardo Montaño April 12, 2023 08:00 AM UTC

below is the first image that is not showing on my post.




SP Sangeetha Priya Murugan Syncfusion Team April 13, 2023 03:06 PM UTC

Hi Jose,


We have some limitation while inserting the row/column with the formatting applied cells and we have already documented it on our site.


https://ej2.syncfusion.com/documentation/spreadsheet/rows-and-columns/#limitations-of-insert-and-delete


You can insert the row with predefined values and formats using the insertRow method. For more details, please refer to the below links.


https://www.syncfusion.com/kb/13863/how-to-insert-rows-in-the-used-range-with-predefined-values-using-context-menu-option-in


https://helpej2.syncfusion.com/angular/documentation/api/spreadsheet/#insertrow


Or else you can copy the formats from the previous row and paste them in the newly created row based on your needs.


Meanwhile, we have considered this as an improvement and the fix will be available in any of our upcoming releases. We appreciate your patience until then. You can track the status of this improvement using the link below from our feedback portal. 


Feedback Portal Link: https://www.syncfusion.com/feedback/42874/provide-support-to-insert-row-column-between-the-formatting-applied-cells



Loader.