Hi
I am exporting only two columns to the excel
"Amount" and "Out Of 10 Percent".
I will enter the amount in "Amount" column and "Out Of 10 Percent", i will display the 10 Percent of the amount
Say Amount Out Of 10 Percent
1000 100
100 10.
I can do the calculation in C# and i can able to export the content to excel as above.
My need is in the exported exce, if change the amount means i should able to get the corresponding amount in the next column.
(i.e) in the exported excel, if i edit the "Amount" ->1000 to 500 means the next column "Out Of 10 Percent" should change as 100 -> 50. I mean it should be auto calculated in the exported excel.
Is that i can abke to achieve this.
Thanks.
Please let me know if the question is not clear.
