NPOI and setCellFormula(): decimal-separator is cutoff

Apr 4, 2013 at 12:30 PM
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():

Image

Any help would be greatly appreciated.
Dec 5, 2013 at 5:12 PM
I found the same problem whith NPOI 2.0.1.

If I use sheet.SetCellFormula("10 * 0.015"), the result is "10 * 15" when the correct is "10 * 1,5".
Coordinator
Dec 5, 2013 at 7:25 PM
Hi All,

Since 2.0.5 is just released, can you try the latest version? And let me know if it still exists.
Dec 27, 2013 at 1:29 PM
Hi tonyqus,
I just migrated my app to 2.0.5. I can confirm 100% that the same problem is still present and not fixed.

Thanks,
Coordinator
Dec 31, 2013 at 6:45 PM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.
Coordinator
Jan 9, 2014 at 10:40 PM
Can you donate some money to cover my efforts on fixing this issue :-)