In spreadsheet I have formula cell which has =32767+32768. When I process this using POI (poi-3.0.10-FINAL), it is evaluated to -1. When I debugged the code, I noticed the formula in cell as =32767+-32768, which is obviously evaluated properly to -1. Now -32768 is not at all expected. is it? Moreover, 32767+32767 works fine.
Created attachment 21430 [details] Test spreadsheet (Refer to A5)
Fixed and committed to svn (trunk). Yegor
The fix is working, I tested it. Could you please release a patch for 3.0.1 containing this fix? Sorry , I should have mentioned this before in version selection. Thanks very much Yegor for a quick turnaround.
>Could you please release a patch for 3.0.1 >containing this fix? No. 3.0.2 is coming, the fix is included in it. If you wish, you can patch 3.0.1 yourself. You need to replace org.apache.poi.hssf.record.formula.IntPtg. Yegor
No Problem.