Okay, I've done some testing of the named ranges code. It does not support
ranges such as:
$G$11:$I$16
Attached is a spreadsheet that fails to load under your code.
I get the following stacktrace:
ava.lang.reflect.InvocationTargetException: java.lang.RuntimeException:
Unknown PTG = 3b (59)
at org.apache.poi.hssf.record.formula.Ptg.createPtg(Ptg.java:146)
at
org.apache.poi.hssf.record.NameRecord.getParsedExpressionTokens(NameRecord.j
ava:604)
at org.apache.poi.hssf.record.NameRecord.fillFields(NameRecord.java:576)
at org.apache.poi.hssf.record.Record.fillFields(Record.java:142)
at org.apache.poi.hssf.record.Record.<init>(Record.java:104)
at org.apache.poi.hssf.record.NameRecord.<init>(NameRecord.java:116)
at java.lang.reflect.Constructor.newInstance(Native Method)
at
org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:212
)
at
org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:15
0)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:150)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:190)
at
org.apache.poi.hssf.usermodel.examples.NamedRanges.main(NamedRanges.java:87)
org.apache.poi.hssf.record.RecordFormatException: Unable to construct record
instance, the following exception occured: null
at
org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:225
)
at
org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:15
0)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:150)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:190)
at
org.apache.poi.hssf.usermodel.examples.NamedRanges.main(NamedRanges.java:87)
Regards,
Glen
----- Original Message -----
From: Libin Roman
To: [EMAIL PROTECTED]
Sent: Tuesday, April 16, 2002 5:33 PM
Subject: Named Ranges
Hi ,
I have sent the Named Ranges patch to the bugzilla.
Hope to see it soon in the cvs :)))
>From HSSFWorkbook you can create a new named range. From HSSFWork you can
get the HSSFName (high level of named range) by name or by index , which
from you get get the reference or to set it.
Hope you like it :)),
Libin Roman
begin 666 workbook.xls
MT,\1X*&Q&N$`````````````````````/@`#`/[_"0`&```````````````!
M````&0``````````$ ``_O___P````#^____`````!@```#_____________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M______________________\)"! ```8%`/X<S0?)0 ``!@$``.$``@"P!,$`
M`@```.(```!<`' `$@``4')E9F5R<F5D($-U<W1O;65R(" @(" @(" @(" @
M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @($(``@"P!&$!`@``
M`, !```]`0(```"<``(`#@`9``(````2``(````3``(```"O`0(```"\`0(`
M```]`!(`: $4`5PZQ",X```````!`%@"0 `"````C0`"````(@`"````#@`"
M``$`MP$"````V@`"````,0`:`,@```#_?Y !````````!0%!`'(`:0!A`&P`
M,0`:`,@```#_?Y !````````!0%!`'(`:0!A`&P`,0`:`,@```#_?Y !````
M````!0%!`'(`:0!A`&P`,0`:`,@```#_?Y !````````!0%!`'(`:0!A`&P`
M'@0<``4`%P``(B0B(RPC(S!?*3M<*"(D(B,L(R,P7"D>!"$`!@`<```B)"(C
M+",C,%\I.UM2961=7"@B)"(C+",C,%PI'@0B``<`'0``(B0B(RPC(S N,#!?
M*3M<*"(D(B,L(R,P+C P7"D>!"<`" `B```B)"(C+",C,"XP,%\I.UM2961=
M7"@B)"(C+",C,"XP,%PI'@0W`"H`,@``7R@B)"(J(",L(R,P7RD[7R@B)"(J
M(%PH(RPC(S!<*3M?*"(D(BH@(BTB7RD[7RA 7RD>!"X`*0`I``!?*"H@(RPC
M(S!?*3M?*"H@7"@C+",C,%PI.U\H*B B+2)?*3M?*$!?*1X$/P`L`#H``%\H
M(B0B*B C+",C,"XP,%\I.U\H(B0B*B!<*",L(R,P+C P7"D[7R@B)"(J("(M
M(C\_7RD[7RA 7RD>!#8`*P`Q``!?*"H@(RPC(S N,#!?*3M?*"H@7"@C+",C
M,"XP,%PI.U\H*B B+2(_/U\I.U\H0%\IX `4``````#U_R `````````````
M`, @X `4``$```#U_R ``/0``````````, @X `4``$```#U_R ``/0`````
M`````, @X `4``(```#U_R ``/0``````````, @X `4``(```#U_R ``/0`
M`````````, @X `4``````#U_R ``/0``````````, @X `4``````#U_R `
M`/0``````````, @X `4``````#U_R ``/0``````````, @X `4``````#U
M_R ``/0``````````, @X `4``````#U_R ``/0``````````, @X `4````
M``#U_R ``/0``````````, @X `4``````#U_R ``/0``````````, @X `4
M``````#U_R ``/0``````````, @X `4``````#U_R ``/0``````````, @
MX `4``````#U_R ``/0``````````, @X `4```````!`" `````````````
M`, @X `4``$`*P#U_R ``/@``````````, @X `4``$`*0#U_R ``/@`````
M`````, @X `4``$`+ #U_R ``/@``````````, @X `4``$`*@#U_R ``/@`
M`````````, @X `4``$`"0#U_R ``/@``````````, @DP($`!" `_^3`@0`
M$8 &_Y,"! `2@ 3_DP($`!. !_^3`@0``( `_Y,"! `4@ 7_8 $"````A0`1
M`-(%``````D`;F5W('-H965TC `$``$``0"N`00``0`!!!<`" `!````````
M`!@`)@`````,"P````````````!->4YA;65D4F%N9V4[```"``(``@`"`!@`
M'P`````%"P````````````!497-T,CL```H`#P`&``@`P0$(`,$!``" . $`
M_ `(````````````_P`"``@`"@````D($ ``!A `_AS-!\E ```&`0``"P(0
M`````````````````(H&```-``(``0`,``(`9 `/``(``0`1``(````0``@`
M_*GQTDUB4#]?``(``0`J``(````K``(```""``(``0" ``@````````````E
M`@0````(`8$``@#!!!0````5````@P`"````A `"````H0`B``$`9 `!``$`
M`0`"`"P!+ $```````#@/P```````. _``!5``(`" ```@X`````````````
M```````^`A(`M@8`````0 ``````````````'0`/``,*``8````!``H`#P`&
M".\`!@```#<````*````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````_O\```4``@```````````````````````0``
M`."%G_+Y3V@0JY$(`"LGL]DP````8 ````0````!````* ````@````P````
M#0```$P````3````6 ````(```#D! ``'@```!,```!0<F5F97)R960@0W5S
M=&]M97(``$ `````?4_SB^;!`0,`````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M`````````````````````````/[_```%``(```````````````````````$`
M```"U<W5G"X;$).7" `K+/FN, ```+0````(`````0```$@````7````4 ``
M``L```!8````$ ```& ````3````: ```!8```!P````#0```'@````,````
MC@````(```#D! ```P```.T."0`+``````````L`````````"P`````````+
M`````````!X0```!````"@```&YE=R!S:&5E= `,$ ```@```!X````+````
M5V]R:W-H965T<P`#`````0``````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M```````````````````````````!`````@````,````$````!0````8````'
M````_O___PD````*````"P````P````-````#@````\```#^____$0```!(`
M```3````% ```!4````6````%P```/[____]_____O__________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M_________________________________________________U(`;P!O`'0`
M( !%`&X`= !R`'D`````````````````````````````````````````````
M```````````````6``4!__________\"````( @"``````# ````````1@``
M`````````````/!>LCJ-YL$!_O___P``````````5P!O`'(`:P!B`&\`;P!K
M````````````````````````````````````````````````````````````
M`````!(``@'_______________\`````````````````````````````````
M`````````````````````! ````````%`%,`=0!M`&T`80!R`'D`20!N`&8`
M;P!R`&T`80!T`&D`;P!N````````````````````````````````````* `"
M`0$````#````_____P``````````````````````````````````````````
M``````@`````$ ````````4`1 !O`&,`=0!M`&4`;@!T`%,`=0!M`&T`80!R
M`'D`20!N`&8`;P!R`&T`80!T`&D`;P!N```````````````X``(!________
M________````````````````````````````````````````````````$ ``
)```0````````
`
end
