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