poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dragos <dbo...@infonium.ca>
Subject Cell reference
Date Tue, 09 Nov 2004 15:34:13 GMT
Hello all,

I'm trying to create a cell that is a reference to a cell from another excel 
file. To do that I used:

HSSFWorkbook wb = new HSSFWorkbook();
FileOutputStream fileOut = new FileOutputStream("workbook.xls");
HSSFSheet sheet = wb.createSheet("firstSheet");

HSSFRow row = sheet.createRow((short)0);

HSSFCell cell = row.createCell((short)1);
cell.setCellFormula("'C:\\[test2.xls]results'!$A$2");
wb.write(fileOut);
fileOut.close();

... but in the resulted excel file I find "=#REF!$A$2". Is this functionality 
supported or maybe there is something wrong with my code?

Regards,
Dragos


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