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=16767>. 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=16767 string "12345" becomes the number 12345 Summary: string "12345" becomes the number 12345 Product: POI Version: 1.5.1 Platform: Macintosh OS/Version: MacOS X Status: NEW Severity: Normal Priority: Other Component: HSSF AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] CC: [EMAIL PROTECTED] The code below generates a 1-cell spreadsheet. When I open it, the "12345" is left-justified, like I would expect a string value to be. But if I double-click the cell and then click out of it without making any changes, it becomes the integer 12345. If I were creating the spreadsheet by hand I would have entered '12345 to force the value to be a string, and the apostrophe would be there when I double-click the cell. --Andy ========== import org.apache.poi.hssf.usermodel.*; import java.io.*; public class Test { public static void main(String[] args) { try { doMain(); } catch (Exception e) { e.printStackTrace(); } } private static void doMain() throws Exception { HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet = wb.createSheet("test"); HSSFRow row = sheet.createRow((short)0); HSSFCell cell = row.createCell((short)0); cell.setCellType(HSSFCell.CELL_TYPE_STRING); cell.setCellValue("12345"); FileOutputStream fos = new FileOutputStream("/tmp/test.xls"); wb.write(fos); fos.flush(); fos.close(); } } --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
