On Mon, 8 Aug 2011, Chris McCann wrote:
Tracing into the formula that's causing the problem I found an odd
situation. Looking at the formula in Excel (using Excel Mac version 12.2.6)
I see the formula for cell U46 is listed as:
=SUMIF($AI$3:$JN$3,U$36,$AI46:$JN46)
When I call cell.get_cell_formula using POI, though, I get:
U46 = SUMIF($AI$3:$JN$3,AB$36,$AI46:$JN46)
The NPE is being raised because there's no value in AB36.
The key question is what has been stored in the xlsx file? If you unzip
the .xlsx and then look at the sheet xml file for the sheet with the
problem formula in, you should be able to find the cell xml (there's a
reference on it with the cell's location). What has excel stored there?
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
