Hi Sri.
Using POI it's not the easy way like directly in Excel. I see the prime
(') everywhere. When copying the value it's still interpreted as 1,2 and
then displayed like date and time.
Regards, Karl-Heinz.
-----Urspr�ngliche Nachricht-----
Von: Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 31. M�rz 2004 14:50
An: 'POI Users List'
Betreff: AW: AW: HSSFCell - setCellValue("1.2") leads to a numerice
value 1,2 in Excel
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]
