That's an Excel issue. Check the Excel help (Press F1 in Excel). Good luck, Frans
> -----Original Message----- > From: Andrš Petr (EXT) [mailto:[EMAIL PROTECTED] > Sent: Thursday, February 17, 2005 10:03 AM > To: POI Users List > Subject: RE: Meaning of values of HSSFCellStyle.getDataFormat() > > > Hi Amol. > > And how this should help me? There are listed the same > formats as in mentioned Javadoc with no information whether > it formats cell to date or number. > > Thanks, > Petr > > > -----Original Message----- > > From: Amol Deshmukh [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, February 16, 2005 7:35 PM > > > > "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 > > > > -----Original Message----- > > From: Andrš Petr (EXT) [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, February 16, 2005 11:59 AM > > > > 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? > > --------------------------------------------------------------------- > 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/ > ----------------------------------------------------------------- ATTENTION: The information in this electronic mail message is private and confidential, and only intended for the addressee. Should you receive this message by mistake, you are hereby notified that any disclosure, reproduction, distribution or use of this message is strictly prohibited. Please inform the sender by reply transmission and delete the message without copying or opening it. Messages and attachments are scanned for all viruses known. If this message contains password-protected attachments, the files have NOT been scanned for viruses by the ING mail domain. Always scan attachments before opening them. -----------------------------------------------------------------
