Hi,
I am using POI 3.6.
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?
Thanks in advance,
Jon
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
