Bug 27349

Summary:	RangePtg not supported yet
Product:	POI	Reporter:	Todd McGrath <mcgrath>
Component:	HSSF	Assignee:	POI Developers List <dev>
Status:	RESOLVED FIXED
Severity:	normal
Priority:	P3
Version:	2.0-FINAL
Target Milestone:	---
Hardware:	All
OS:	All
Attachments:	use this spreadsheet to recreate read in spreadsheet, write back out - probably nto that helpful

Description Todd McGrath 2004-03-01 22:19:14 UTC

VLOOKUP to another sheet causes "[WARNING] Unknown Ptg 11 (17) at cell ..."

I'll upload Excel file to recreate.  See cell A1 vs. A2 on INPUT sheet.

Comment 1 Todd McGrath 2004-03-01 22:19:41 UTC

Created attachment 10622 [details]
use this spreadsheet to recreate

Comment 2 Todd McGrath 2004-03-01 22:23:01 UTC

Created attachment 10623 [details]
read in spreadsheet, write back out - probably nto that helpful

Comment 3 Josh Micich 2008-04-03 14:55:32 UTC

The bug summary used to be: "VLOOKUP with reference to another sheet"

RangePtg (0x11) did not exist at the time of logging this bug. It seems to have been added in svn r426082 (2006-07-27)

POI reads the spreadsheet without errors/warnings now, and even evaluates cell A2 (containing the VLOOKUP/RangePtg) OK.