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=30319>. 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=30319 [EMAIL PROTECTED] changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED ------- Additional Comments From [EMAIL PROTECTED] 2006-01-03 08:29 ------- I have implemnted a fix in SVN, however it is not as suggested in the Workbook, but rather in the low level FormatRecord. Confirmed that it works with the following code: Please check on a euro excel version, but ill close since i think that it is now fixed. import org.apache.poi.hssf.usermodel.*; import java.io.*; public class Test { public static void main(String[] args) { try { long time1 = System.currentTimeMillis(); // HSSFWorkbook wb = new HSSFWorkbook(new FileInputStream(new File( // "c:/workbook-orig.xls"))); // wb.write(new FileOutputStream(new File("c:/workbook-out.xls"))); // HSSFWorkbook wb = new HSSFWorkbook(); HSSFDataFormat df = wb.createDataFormat(); short fmt = df.getFormat("_([$\u20ac-2]\\\\\\ * #,##0.00_);_([$\u20ac-2]\\\\\\ * \\\\\\(#,##0.00\\\\\\);_([$\u20ac-2]\\\\\\ *\\\"\\-\\\\\"??_);_(@_)"); HSSFSheet s = wb.createSheet("TestSheet"); HSSFRow r = s.createRow(0); HSSFCell c = r.createCell((short)1); c.setCellValue(12.34); c.getCellStyle().setDataFormat(fmt); wb.write(new FileOutputStream(new File("c:/test1_out.xls"))); System.out.println("Elapsed :"+(System.currentTimeMillis()-time1)); } catch (Exception ex) { ex.printStackTrace(); } } } -- 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/
