"open excel document using MS Excel" > "Right click on a cell (any cell)" > "Format cells..." > "Number" tab > select "Custom" > Scroll to see more such cryptic values
HTH ~ amol -----Original Message----- From: Andrš Petr (EXT) [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 16, 2005 11:59 AM To: POI Users List Subject: Meaning of values of HSSFCellStyle.getDataFormat() Hi, I am bit confused by meaning of values returned by HSSFCellStyle.getDataFormat(). In JavaDoc values are maped to some cryptic string values, but what is meaning of these values? I can guess that some are probably date formats and others represent numbers, but in case of several I have no idea. Where can I find which formats represent numbers and which dates? Or better piece of code that reads value from cell and prints it with proper formatting? Thanks, Petr --------------------------------------------------------------------- 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/ --------------------------------------------------------------------- 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/
