I've a serious problem copying this formula with NPOI 1.2.5 from one cell to another with C#:
The original cell contain this:
=IF(H21>(H23*0.9997);IF(H21<(H23*1.0003);"OK";"Errore");"Errore")
The resulting cell reports exactly this formula, but with the decimal separator stripped. So I get this:
=IF(H21>(H23*9997);IF(H21<(H23*10003);"OK";"Errore");"Errore")
This is my debugger view right after the setFormula():
Any help would be greatly appreciated.
This issue has been identified as a bug form the developer. We can't do much more than paying attention to it and wait for a fixed release.