Hi world. Excel made the problems. We run macros at the next startup and there it was obvious. So from POI nothing is influencable.
Regards, Karl-Heinz. -----Urspr�ngliche Nachricht----- Von: Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 21. April 2004 18:35 An: [EMAIL PROTECTED] Betreff: how to force to be a string cell Hi world. In some cases we explicitly store things as strings. At the moment wenn the cell value is set we see the value correct. But when we open Excel afterwards we see 04.03.2004 where we have set "03/04-4". Even additional forcing with e.g. HSSFCellStyle oCS = this.oiShXl.getOiWBXl().getOiWBP().createCellStyle(); oCS.setDataFormat(HSSFDataFormat.getBuiltinFormat("@")); // text doesn't help. Because of the implicit conversion our original input is lost. As a date value might be derived from several external representation (and thus that implicit conversions aren't a bijective function in the mathematical sense) this can't be corrected in a general manner by Excel macros. How can we force that the things remain strings??? A further trial was prefixing with a prime (') but this also didn't work well and brought other problems. In another application we copy a string from one cell to another (normally empty one) via String sTmp = oCellP.getStringCellValue(); oCellPT.setCellValue(sTmp); There with the same data ("03/04-4") we don't have such problems. Regards, Karl-Heinz Zengerle --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
