I have an HSSF question regarding HSSFCells that have a CellType of
CELL_TYPE_NUMERIC.

I am wanting to specify that a Cell has a numeric value (71.843 for
example) then somehow, possibly through an HSSFCellStyle, indicate that the
Cell is supposed to only *display * a certain number of decimal places,
such as only one decimal place which yields 71.8 in my example above.  I
tried to find a way to do this by looking in the POI Javadoc but had no
luck.  Anybody else ever try this and find a solution?

I realize that in Java code I could round the number before inserting its
value into the Cell to begin with, but the user community I am serving
would prefer to preserve the original number with more decimal places, just
display the rounded version.

Any ideas are appreciated!

Scott Smith
Application Architecture Development, Hallmark Cards Inc.
Sun Certified Java 2 Programmer
Sun Certified Web Component Developer



--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Reply via email to