Dave, I updated my env to use 3.7 and while the number of instances of this issue has decreased (I think) the issue is still present. It affects the main cells that I need to be evaluate, unfortunately. The main error values I am seeing are 15 and -60.
Any other ideas how I can track this down? What would be very helpful (and probably not easy to get) is the fully resolved (or as close as one can get) tree of cell dependencies. I'd imagine though that this isn't something that is built until a cell is evaluated. If I had that I could probably figure out where the issue is. Thanks, Jon ----- Original Message ---- From: David Fisher <[email protected]> To: POI Users List <[email protected]> Cc: [email protected] Sent: Thu, December 2, 2010 4:23:25 PM Subject: Re: Error Values Hi Jon - > I am using POI 3.6. A lot of bug fixes and improvements with formula evaluation between 3.6 and 3.7. > > I have a .xls file in which I am evaluating some cells that have formulas and > macros in them. When I get to evaluate a cell with formulas in it, instead > of > getting a number I am getting #VALUE! as the return (although not always, in > most cases the cells evaluate normally). After a little digging I noticed > that > > when I look at the CellValue.getErrorValue() in this case it is always > 0, > usually 15 or 60. I tried looking in the source of the CellValue class to > see > what these values mean, but I didn't find anything. Here is my code: > > CellReference cellReference = new CellReference( row.getRowNum(), > cell.getColumnIndex() ) ; > CellValue cellValue = evaluator.evaluate( cell ) ; > byte err = cellValue.getErrorValue() ; > > It doesn't fail outright, like it would when you encounter a function written >in > > VB or something, so it's not as fatal as that. > > It would appear that it is a reference issue, assuming that the value > "#VALUE!" > > has the same meaning in POI as it does when using Excel. What I don't get is > that this spreadsheet works fine in Excel (not surprising, I know). I just >want > > to figure where the problem actually is so I can address it. Is there a way >for > > POI to give me the list dependencies for a given cell? > > Does anyone have any pointers for debugging this or teasing out more >information > > regarding the error? I would try 3.7-FINAL first. Regards, Dave > > Thanks in advance, > > Jon > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
