poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marot Laurent" <Laurent.Ma...@alliacom.com>
Subject question about single cell named ranges
Date Fri, 16 Jan 2004 10:40:45 GMT

> Hi guys,
> 
> i 'm facing the problem below when trying to set a name to a cell 
> 
> i get this exception trying the code below
> java.lang.ArrayIndexOutOfBoundsException: 1 at org.apache.poi.hssf.record.formula.Area3DPtg.setArea(Area3DPtg.java:285)
at org.apache.poi.hssf.record.NameRecord.setAreaReference(NameRecord.java:747) at org.apache.poi.hssf.usermodel.HSSFName.setReference(HSSFName.java:164)
at org.apache.jsp.Excel_jsp._jspService(Excel_jsp.java:72) 
> 
> 
> 
> wb.setSheetName(0,"Catalogue");
> wb.setSheetName(1,"HW per Site");
> 
> HSSFName nomTest = wb.createName();
> nomTest.setNameName("test");
> nomTest.setReference("Catalogue!$A$1");
> 
> Could you please help me ?
> 
> Thanks a lot

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


Mime
View raw message