DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUGĀ· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=42541>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED ANDĀ· INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=42541 Summary: Problem with Formula cells. Product: POI Version: 3.0-dev Platform: PC OS/Version: Windows XP Status: NEW Severity: critical Priority: P1 Component: HSSF AssignedTo: poi-dev@jakarta.apache.org ReportedBy: [EMAIL PROTECTED] POI Version . poi-3.0-rc4-20070503.jar Create a simple excel file . input a formula in C1 as =A1+B1 Copy the same formula into the corresponding cells for the C column by dragging the C1 Cell. Excel will generate the formulas automatically for the cells. Save the workbook and try opening it. InputStream istream = new FileInputStream(filename); POIFSFileSystem fs = new POIFSFileSystem(new BufferedInputStream(istream)); HSSFWorkbook wb= new HSSFWorkbook(fs,true); FileOutputStream fileOut = new FileOutputStream("c:\\test.xls"); wb.write(fileOut); fileOut.close(); istream.close(); All the cells where the formula is copied will show #value instead of the value. This happens only in the current release(poi-3.0-rc4-20070503). Could somebody please fix this or suggest some solution. This happens only for those formula cells that have been copied. -- Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta POI Project: http://jakarta.apache.org/poi/