Nick, Exactly my thinking but for some reason trying to open the unzipped XML file using TextMate clobbered my machine. Not sure what's up there but will try to find a workable solution to opening it. I'll report what I find here.
Cheers, Chris On Tue, Aug 9, 2011 at 4:32 AM, Nick Burch <[email protected]> wrote: > 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].**org<[email protected]> > For additional commands, e-mail: [email protected] > >
