|Summary:||RangePtg not supported yet|
|Product:||POI||Reporter:||Todd McGrath <mcgrath>|
|Component:||HSSF||Assignee:||POI Developers List <dev>|
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.