To the other committers: Obviously replying to him will encourage this kind of behavior in the future.
-Andy -- 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: Sun, 11 Apr 2004 15:10:01 -0700 (PDT) > To: POI Users List <[EMAIL PROTECTED]> > Subject: Re: How to distinguish between different dates formats and decimals > > 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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
