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: user-unsubscr...@poi.apache.org > For additional commands, e-mail: user-h...@poi.apache.org > --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org