Bug 27349 - RangePtg not supported yet
Summary: RangePtg not supported yet
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 2.0-FINAL
Hardware: All All
: P3 normal with 1 vote (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2004-03-01 22:19 UTC by Todd McGrath
Modified: 2008-04-03 14:55 UTC (History)
0 users

use this spreadsheet to recreate (13.50 KB, application/octet-stream)
2004-03-01 22:19 UTC, Todd McGrath
read in spreadsheet, write back out - probably nto that helpful (4.47 KB, text/plain)
2004-03-01 22:23 UTC, Todd McGrath

Note You need to log in before you can comment on or make changes to this bug.
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.