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

Posted to user@poi.apache.org by Oytun Askin <oy...@gmail.com> on 2005/06/13 20:35:36 UTC

HSSF: output 0.0459 to excel file to see 4.59%

Hi guys, 
I read a formatted Cell in an Excel file, then put a value in the Cell with 
the .setCellValue(variableName)  where variableName contains the value "0.0459" 
and  save the HSSF file. However when I open the saved file i see 0.0459 
although the style of the cell it is displayed on is a percentage 0.00##%. 
Any ideas how to "preserve the cell style" ? ? 



---------------------------------------------------------------------
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/