DO NOT REPLY [Bug 21923] - [PATCH] Modify HSSFWorkbook, FormulaParser and SheetReferences to support 3DRefs

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

DO NOT REPLY [Bug 21923] - [PATCH] Modify HSSFWorkbook, FormulaParser and SheetReferences to support 3DRefs

Bugzilla from bugzilla@apache.org
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG?
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=21923>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND?
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=21923





------- 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".

--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/