Applied formula on excel removed after adding a new row in excel


#1

Hi,

When i am adding a new row and inserting data dynamically, data inserted successfully but formula already applied on the excel removed automatically.
Formula should be remain as it is.

I am sharing my xaml and xlsx file. In xlsx file i have written formula.
I want to update this xlsx file with formula(already applied on excel file).
Please help me.

Main.xaml (9.4 KB)
Test.xlsx (12.9 KB)

Thanks


#2

Does this link help?


#3

Not resolved. Please give me some ideas so that I can do it.
Code already attached