The following error is thrown when the reference name is NEW $B$14:$B$39
java.lang.NumberFormatException: 14:$B$39
at java.lang.Integer.parseInt(Unknown Sou
at java.lang.Integer.parseInt(Unknown Sou
at org.apache.poi.hssf.util.CellReference
at GetCellName.getNamedCellUsingIndex(Get
at GetCellName.main(GetCellName.java:83)
Any clues??
Nags
-----Original Message-----
From: Avik Sengupta [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 6:52 PM
To: POI Users List
Subject: Re: getReference()
One cant be sure till you show us the code fragment that is calling poi
(compilable) and an example sheet that exhibits the error. Otherwise, we
will just be groping in the dark.
Regards
-
Avik
On Mon, 2003-11-10 at 18:57, Nagaraj_K wrote:
> If a sheet is protected .... getReference() method in HSSFName throws the
> follwing error....
> cName [EMAIL PROTECTED]
> java.lang.IndexOutOfBoundsException: Index: -1, Size: 1
> at java.util.ArrayList.RangeCheck(Unknown Source)
> at java.util.ArrayList.get(Unknown Source)
> at
> org.apache.poi.hssf.model.Workbook.getSheetName(Workbook.java:449)
> at
> org.apache.poi.hssf.model.Workbook.findSheetNameFromExternSheet(Workb
> ook.java:1700)
> at
> org.apache.poi.hssf.model.Workbook.getSheetReferences(Workbook.java:1
> 685)
> at
> org.apache.poi.hssf.usermodel.HSSFName.getReference(HSSFName.java:126
> )
> at GetCellName.getNamedCellUsingIndex(GetCellName.java:41)
> at GetCellName.main(GetCellName.java:79)
>
> Is it a bug or am I not missing something??
>
> Nags
> **************************************************************************
> This email (including any attachments) is intended for the sole use of the
> intended recipient/s and may contain material that is CONFIDENTIAL AND
> PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying
or
> distribution or forwarding of any or all of the contents in this message
is
> STRICTLY PROHIBITED. If you are not the intended recipient, please contact
> the sender by email and delete all copies; your cooperation in this regard
> is appreciated.
> **************************************************************************
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
**************************************************************************
This email (including any attachments) is intended for the sole use of the
intended recipient/s and may contain material that is CONFIDENTIAL AND
PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or
distribution or forwarding of any or all of the contents in this message is
STRICTLY PROHIBITED. If you are not the intended recipient, please contact
the sender by email and delete all copies; your cooperation in this regard
is appreciated.
**************************************************************************
