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 30319] - Euro symbol in usermodel DataFormat (+ FIX)
Date Tue, 03 Jan 2006 07:29:57 GMT
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


jheight@apache.org changed:

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




------- Additional Comments From jheight@apache.org  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: poi-dev-unsubscribe@jakarta.apache.org
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/


Mime
View raw message