Bug 26483

Summary:	Formula Parser barfs on 3DRefs because of lack of access to the internal workbook
Product:	POI	Reporter:	Eric Ladner <eladner>
Component:	HSSF	Assignee:	POI Developers List <dev>
Status:	RESOLVED DUPLICATE
Severity:	normal
Priority:	P3
Version:	2.0-pre3
Target Milestone:	---
Hardware:	All
OS:	All
Attachments:	Test case spreadsheet Java example that tickles the bug

Description Eric Ladner 2004-01-28 05:15:48 UTC

Attached is an Excel spreadsheet and a snippet of Java that shows the error.

it blows up on line 295 of FormulaParser:

  short externIdx = book.checkExternSheet(book.getSheetIndex(sheetName));

because there was no workbook to get the external sheet references from
(external reference meaning external to the sheet the formula is on.

Comment 1 Eric Ladner 2004-01-28 05:16:43 UTC

Created attachment 10104 [details]
Test case spreadsheet

Comment 2 Eric Ladner 2004-01-28 05:17:18 UTC

Created attachment 10105 [details]
Java example that tickles the bug

Comment 3 Avik Sengupta 2005-05-19 15:33:40 UTC


*** This bug has been marked as a duplicate of 34944 ***