Hi Sri. So it seems to be the only way: Prefixing with "'" if there's not already one there. I thought such safety measures would already be used.
Regards, Karl-Heinz. -----Urspr�ngliche Nachricht----- Von: Srinadh Karumuri [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 31. M�rz 2004 14:37 An: POI Users List Betreff: Re: AW: HSSFCell - setCellValue("1.2") leads to a numerice value 1,2 in Excel Try a single quote in the front. It's probably the nature of the gaint. When I tried 1.2 & '1.2 in Excel it behaved differently. HSSFCell - setCellValue("'1.2") -Sri Karl-Heinz Zengerle wrote: >Hi world. > >Even > >oCS.setDataFormat(HSSFDataFormat.getBuiltinFormat("@")); // text > >doesn�t help (where oCS is the reference to the cell style. > >This is a double forcing of being a string and still ignoring it. > >Regards, Karl-Heinz. > > >-----Urspr�ngliche Nachricht----- >Von: Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED] >Gesendet: Mittwoch, 31. M�rz 2004 12:55 >An: [EMAIL PROTECTED] >Betreff: HSSFCell - setCellValue("1.2") leads to a numerice value 1,2 in >Excel > >Hi world. > >Does anybody know how to avoid the problem above? > >I�ld expect that when a string is written the resulting cell should be a >string. > > >MfG >Karl-Heinz Zengerle > > > > --------------------------------------------------------------------- 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]
