DO NOT REPLY [Bug 49156] NPE when evaluateInCell is used

[bu...@apache.org]

https://issues.apache.org/bugzilla/show_bug.cgi?id=49156

--- Comment #1 from Vasili <vg...@rogers.com> 2010-04-20 15:48:34 EDT ---
Exception occurs only when reading Excel 2007 files. When using the same
spreadsheet but been saved as 97/2000 Excel format (the same formulas) and so
HSSF is used internally - everything is fine. (but we need to process files
been saved by default as 2007+ as well!)

I've tried to use evaluateFormulaCell() instead, but the formulas results are
different (we have a bunch of regression tests using aggregate functions such
as calculating of the sum of all formulas sums etc) than using
evaluateInCell(). The later calculates correctly but due to the NPE mentioned
above - it works for 97/2000 Excel files only. I'm expecting it to work in the
same way (with the same results) - for 2007 format.
That is why I'm waiting for NPE fix - for evaluateInCell() and can't use
evaluateFormulaCell().

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org