You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@poi.apache.org by Marek Lewczuk <ma...@lewczuk.com> on 2007/03/24 00:36:44 UTC

problem with excel data format

Hello all,
I would like to let you know about a small (but very important) bug with 
excel data format. Please create a numeric cell (with value set to e.g. 
-1232423 and style it data format like this:
# ##0_ ;[Green]-# ##0

When you will open generated excel workbook you will see that the format 
has been modified to this:
#\ ##0_ ;[Green]-#\ ##0

The change cause that the number like -1232423 isn't formated as it 
should be, instead
-1 232 423
we've got
-1232 423

Hope you will find the way to fix this bug.

Thanks
ML


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/