poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 12730] - values dont get copied to another sheet.
Date Tue, 28 Oct 2003 18:07:51 GMT
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=12730>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=12730

values dont get copied to another sheet.

lists@aviksengupta.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|REOPENED                    |RESOLVED
         Resolution|                            |FIXED



------- Additional Comments From lists@aviksengupta.com  2003-10-28 18:07 -------
Works for me.. Excel2002, following code, no need to press F2, excel sheet has
empty Sheet1, "=Sheet1!A1" in Sheet2!A1

               String filename="12730.xls";
               FileInputStream in = new FileInputStream(filename);
               HSSFWorkbook wb = new HSSFWorkbook(in);
               HSSFSheet sheet = wb.getSheetAt(0);
               HSSFRow row = sheet.getRow(0);
               if (row==null) row=sheet.createRow(0);
               HSSFCell cell = row.getCell((short)0);
               if (cell==null) cell=row.createCell((short)0);
               cell.setCellValue(1.0);
               File f = new File("test12730.xls");
               FileOutputStream fileOut = new FileOutputStream(f);
               wb.write(fileOut);
               fileOut.close();

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


Mime
View raw message