poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hardie82 <thomas.harttha...@yahoo.de>
Subject Re: IndexBound-Exception by FormulaCell-Evaluation
Date Tue, 23 Sep 2008 11:22:26 GMT

I don't know how many sheets the external file has because i didn't get the
file :(. But how can i save the problem? Could i check wether the formula is
a reference or not? In that case, i could ignore the evaluate and get the
next formula cell. I only want to get the message if it contains an error or

Pierre Lavignotte wrote:
> Now I can reproduce...
> POI doesn't handle the external file reference and just evaluate the
> 'examplesheetname!N12' formula as if it were in the same workbook.
> If your external sheet has an index greater than the number of sheet
> in the main workbook, it breaks.

View this message in context: http://www.nabble.com/IndexBound-Exception-by-FormulaCell-Evaluation-tp19622168p19625647.html
Sent from the POI - User mailing list archive at Nabble.com.

To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

View raw message