2. The generated excel file might be opened under protected mode. But, enabling the protection will perform calculation.
Kindly check the above points and get back to us with your sample by creating an incident from Direct Trac if the problem still exists.
Please let us know if you need any clarification.
WYWinson YangOctober 31, 2013 03:39 AM UTC
Thanks for your reply.
I had done everything as you said, but it doesn't work.
And I found the point is I put the value to IRange.Text, if I put the value to IRange.Value, then formula will work.
JMJohnson Monohar M Syncfusion Team November 7, 2013 05:59 AM UTC
Thank you for updating us.
The calculation part doesn't work if the cell type is text, which is a default behavior of MS Excel. It would be grateful if you could share us the sample in a new incident from Direct Trac to provide a prompt solution at the earliest.