poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nagaraj_K <Nagara...@satyam.com>
Subject RE: getReference()
Date Mon, 10 Nov 2003 14:00:06 GMT
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:avik@apache.org]
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    org.apache.poi.hssf.usermodel.HSSFName@651060
> 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: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
************************************************************************** 
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.
**************************************************************************

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message