Insert Row in XLSIO

[Nguyen Duy Hung]

I have using XLSIO create report.
I have create name ranged with name = "DuLieu_HH";
When I insert row in ranged name "DuLieu_HH" -> OK
But In Name Ranged I have set Formula in Column -> when I insert row in ranged name "DuLieu_HH" -> i want row insert contains formula.

Examples
I have attach file
in file attach I have define name ranged with name "ChiTieu_HangHoa"

When I insert row befor row is index = 12. I want copy formula in cell with row = 12 and col = "F" for row I insert (Formula in column ThanhTien)
Help me



Du Lieu Thu_9de32986.rar

[Sridhar]

Hi Nguyen,

Thank you very much for using Syncfusion products.

We are able to see that after inserting the row in the worksheet using InsertRow method the formula is not updated in the newly created row. By default in MSExcel the insert row is update only the styles and borders applied to the previous row, and it does not update the Formula when inserting new row.We have taken the screen video of testing done at our side and placed in the below link for your reference.XlsIO also follows the same behaviour and we are unable to affect the default behaviour of MSExcel.

Video Link:
F100420_Video619777013.zip

Please take a look at the video and let us know if these helps you.

Please let us know if you require any further clarifications.

Regards,
Sridhar.S