Mr. Oliver, I did not realize I had sent this message twice and secondly I wasn't sure if you are part of this user list. Apologies to everyone who got this email twice.
Now I think you are acting too smart, if you can't answer this question simply don't reply. Please behave like a professional! --- "Andrew C. Oliver" <[EMAIL PROTECTED]> wrote: > I won't be answering this question because you sent > everyone a cc of it as > well and then forwarded it to me a second time. I > don't need multiple > duplicate copies of a question sent to the list. If > you want priority > support you have to pay for it. No amount of > discourtesy will acquire it. > Don't play dumb either, I simply cannot believe that > it wouldn't occur to > you that we didn't all want a duplicate of this > message. > -- > Andrew C. Oliver > http://www.superlinksoftware.com/poi.jsp > Custom enhancements and Commercial Implementation > for Jakarta POI > > http://jakarta.apache.org/poi > For Java and Excel, Got POI? > > The views expressed in this email are those of the > author and are almost > definitely not shared by the Apache Software > Foundation, its board or its > general membership. In fact they probably most > definitively disagree with > everything espoused in the above email. > > > From: Davinder Kohli <[EMAIL PROTECTED]> > > Reply-To: "POI Users List" > <[EMAIL PROTECTED]> > > Date: Sat, 10 Apr 2004 17:40:39 -0700 (PDT) > > To: POI Users List <[EMAIL PROTECTED]> > > Subject: How to distinguish between different > dates formats and decimals > > > > Hi, > > I am trying to get the actual format of the cell > > containing different date formats and decimal > values. > > I am also trying to determine how many decimal > places > > are there in a decimal field. > > > > Since the celltype returned for all of them is > > NUMERIC, I get the cell style and then check the > > dataformat as shown below. > > > > int cellType = theCell.getCellType(); > > HSSFCellStyle cellStyle = theCell.getCellStyle(); > > short dataFormatIndex = cellStyle.getDataFormat(); > > > > For all the 17 date formats supported by excel the > > dataformatIndex was one the following indexes: > > > 14,15,16,17,18,19,20,21,22,164,165,168,169,170,171,172,173,174,175,177,176,178 > > ,179,180,181,182. > > > > I got the same indexes back for some of the > decimal > > values. The dataFormatIndex is unique when the > dates > > and decimals are in the same sheet but when they > are > > in separate sheets, the dataFormatIndex is same > for, > > say, date in the format 3/12/2001 and a decimal > field > > having 3 decimal places. > > > > Please let me know if you need me to be more > specific. > > BTW I have tried the HSSFDateUtil methods, they > return > > me true for fields containing decimal values. > > > > Any help would be appreciated! > > > > > > > > __________________________________ > > Do you Yahoo!? > > Yahoo! Tax Center - File online by April 15th > > http://taxes.yahoo.com/filing.html > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: > [EMAIL PROTECTED] > > For additional commands, e-mail: > [EMAIL PROTECTED] > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > __________________________________ Do you Yahoo!? Yahoo! Tax Center - File online by April 15th http://taxes.yahoo.com/filing.html --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
