On Wed, 14 May 2008, Andy Chien wrote:
I think I found out what is going on, the following is just a suspicion
but I have not had enough time to trace through the source code.
POI is having trouble parsing inter-sheet references because the
Workbook Object is not supplied.
That sounds quite possible, yes. Basic formula references should be fine,
but complex intra-sheet ones won't be possible without all the usermodel
data structures kicking about
It seems that workbook is a lower level data structure container in
HSSFworkbook.
That's correct. model.Workbook handles just record stuff, and then
HSSFWorkbook presents a sane view on top of it all. You won't have a
model.Workbook when using eventusermodel
Possibly your only option is to pick up the records that the formula
parser needs, as they go past. You can probably persuade model.Workbook to
initialise off just a few records, which you then pass into the formula
stuff. Won't be pretty though :(
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
