I am using NPOI dll version 22.214.171.124 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.