Formula in Excel using NPOI

May 23, 2014 at 6:33 AM
I am using NPOI dll version 1.2.2.0 for genrating excel sheet in C#. When I apply formula on some cell programmatically and export excel then in protected mode of excel sheet all the cells having formula show '0' value. but when i edit this excel all formulas work properly on those cell. Is there any solution from which applied formula can work in protected mode also?

I cannot switch to higher versions. Please suggest/ provide any solution.

Thanks.
NMathur