Hi Steve. Can you ensure that no Excel macros run at the next startup of that file. I had a similar problem where the open world (POI, OpenOffice) was making the things correct and where macros caused such things.
Did you also test it with Michael's proposal? Regards, Karl-Heinz. -----Ursprüngliche Nachricht----- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 14. Mai 2004 15:15 An: [EMAIL PROTECTED] Betreff: RE: Problem Formatting a cell in Excel after using HSSFWorkbook I tried: row = sheet.createRow(rowNum++); cell = row.createCell(colNum); cell.setCellValue("11111.25"); style = wb.createCellStyle(); style.setDataFormat(HSSFDataFormat.getBuiltinFormat("@")); cell.setCellStyle(style); And I still can not format Column A with Excel. -Steve More -----Original Message----- From: Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED] Sent: Friday, May 14, 2004 4:07 AM To: 'POI Users List' Subject: AW: Problem Formatting a cell in Excel after using HSSFWorkbook Hi Steve. Try something like HSSFCellStyle oCS = oWB.createCellStyle(); oCS.setDataFormat(HSSFDataFormat.getBuiltinFormat("@")); // text Does it also happen then? I didn't discover such problems up to yet. Regards, Karl-Heinz. -----Ursprüngliche Nachricht----- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 13. Mai 2004 20:15 An: [EMAIL PROTECTED] Betreff: Problem Formatting a cell in Excel after using HSSFWorkbook I am creating a HSSFWorkbook with HSSFCell and it works pretty well. The cells are created using text values not number values and when this is viewed in Excel none of the cells can be formatted using the Excel format functions. If you take the following example: http://jakarta.apache.org/poi/hssf/quick-guide.html#DataFormats and change one of the: cell.setCellValue(11111.25); to cell.setCellValue("11111.25"); compile and run, you will see this problem when trying to format column A. Should I submit this as a bug or am I doing something wrong ? -Thanks Steve More NOTICE: This e-mail may contain confidential or legally privileged information and is intended solely for delivery to the specific person identified as the recipient. Any review, re-transmission, dissemination or other use or taking of any action in reliance upon this e-mail by persons other than the intended recipient is prohibited. If you receive this e-mail in error, please contact us at ([EMAIL PROTECTED]) and delete from your computer system, or otherwise from you records, the information, which was transmitted to you in error. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
