Hi,

thanks a whole lot for the hint, Karl-Heinz. Unfortunatly my client didn't
liked 
the idea to prefix the values 'cause they are in the visibility of the end
user.
But, my technical lead found a hack by setting the cell data format:

[..]
   HSSFCellStyle cellStyle = cell.getCellStyle();
   short cellDataformat = cellStyle.getDataFormat();
   cellStyle.setDataFormat((short) 49);
   // Comment in HSSFDataFormat: 
   /*       0x31, "@" - This is text format.<P> */
[..]

After that the format is 'rocksolid' text and can't easly read in Strings.

THX again,
cu Stefan

REWE GROUP
LIKB business systems
Marx-Consulting (extern) c/o

REWE-Informations-Systeme GmbH
Humboldtstraße 140-144 - 51149 Köln

Telefon +49 (0)221 149 - 5953
Telefax +49 (0)221 149 - 97 5953
www.rewe-group.com



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

Reply via email to