------- Additional Comments From [hidden email] 2005-05-16 17:54 -------
I attached two additional files that show the problem this patch is trying to
overcome. If you run the TestClass on test.xls, it'll blow up in
FormulaParser, line 276. This is because FormulaParser expects to be passed an
object of type Workbook so that it can resolve 3DRefs. Line 276 is calling the
checkExternSheet() method of the Workbook class. Since you can't get a Workbook
object from the HSSFWorkbook, it blows up. The two solutions are (1) make
getWorkbook in Workbook public so you can get it and pass it to the
FormulaParser or (2) modify Formula parser to accept SheetReferences that are
obtained from the Workbook.
The patch attached to this bug implements option 2 above since exposing the
Workbook directly was generally regarded as a "bad idea".