poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Paulo L. de Carvalho" <...@netcabo.pt>
Subject Re: question about single cell named ranges
Date Fri, 16 Jan 2004 12:54:09 GMT
Marot Laurent wrote:
>> 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");

Tsa bug.

Try a workaround:

nomTest.setReference("Catalogue!$A$1:$A$1");


PC



---------------------------------------------------------------------
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