Re: [ddsteps-user] Converting from Excel Date to java.util.Date

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

<html><head><META HTTP-EQUIV=3D"Cache-control" CONTENT=3D"no-cache"><META =
HTTP-EQUIV=3D"Pragma" CONTENT=3D"no-cache"></head><body =
bgcolor=3D"white"><FONT face=3Dverdana size=3D2>
<P><FONT face=3Dverdana size=3D2>Hi Bj rn</FONT></P>
<P><FONT face=3Dverdana size=3D2>&nbsp;Created a jira bug can be seen @ <A =
href=3D"http://jira.ddsteps.org/browse/DDS-50">http://jira.ddsteps.org/brow=
se/DDS-50</A></FONT></P>
<P>&nbsp;and congratulation to Adam.</P>
<P>Thanks<BR>Saad</P>
<P><FONT face=3Dverdana size=3D2><B><I>"Bj rn Granvik" =
&lt;bjo...@ja...&gt;</I></B> wrote:=20
<BLOCKQUOTE style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: blue=
 =
2px solid">
<TABLE border=3D0>
<TBODY>
<TR>
<TD width=3D60><FONT face=3Dverdana size=3D2>Date:</FONT></TD>
<TD><FONT face=3Dverdana size=3D2>12/28/2006 09:39:31 AM</FONT></TD></TR>
<TR>
<TD><FONT face=3Dverdana size=3D2>From:</FONT></TD>
<TD><FONT face=3Dverdana size=3D2>"Bj rn Granvik" =
&lt;bjo...@ja...&gt;</FONT></TD></TR>
<TR>
<TD><FONT face=3Dverdana size=3D2>To:</FONT></TD>
<TD><FONT face=3Dverdana =
size=3D2>Saa...@Co...&nbsp;</FONT></TD></TR>
<TR>
<TD><FONT face=3Dverdana size=3D2>cc:</FONT></TD>
<TD><FONT face=3Dverdana =
size=3D2>dds...@li...&nbsp;</FONT></TD></TR>
<TR>
<TD><FONT face=3Dverdana size=3D2>Subject:</FONT></TD>
<TD><FONT face=3Dverdana size=3D2>Re: [ddsteps-user] Converting from Excel =
Date to java.util.Date&nbsp;</FONT></TD></TR></TBODY></TABLE>Hi =
Saad,<BR><BR>Thanks for providing such a good error report.<BR>Possibly you=
 =
already have been provided with an answer - in that case<BR>please disregar=
d=
 this reply.<BR><BR>Right now our lead on DDSteps is away. He just turned =
=66ather :-)<BR><BR>Could you please create an issue in Jira with the =
information below=3F<BR>We'll get to it as soon as possible.<BR><BR>Thanks =
again for your help,<BR>Bj rn<BR><BR><BR><BR>28 dec 2006 kl. 18.12 skrev =
Saa...@Co...:<BR><BR>&gt; Hi<BR>&gt;<BR>&gt; ddsteps versio=
n=
 1.1.1-beta2<BR>&gt;<BR>&gt; An excel date comes back as one day previous i=
n=
 java.util.Date in<BR>&gt; my application.<BR>&gt; According to the jxl faq=
 =
its due to a GMT TimeZone used by jxl and<BR>&gt; local TimeZone<BR>&gt; =
used by the application ref=3D<A class=3Dmsg-link =
href=3D"http://www.andykhan.com/jexcelapi/" =
target=3D_blank>http://www.andykhan.com/jexcelapi/</A><BR>&gt; =
tutorial.html#dates.<BR>&gt; There is no fix provided by jxl since its upto=
 =
the client app to<BR>&gt; handle the date without<BR>&gt; the GMT timezone.=
 =
In an effort to get my unit test to work I digged<BR>&gt; a little =
=66urther<BR>&gt; in ddsteps code to get the correct date.<BR>&gt;<BR>&gt; =
I=
 made the change at org.ddsteps.dataset.excel.getValue() line #<BR>&gt; 102=
.=
 with the following code.<BR>&gt;<BR>&gt; ...<BR>&gt; DateCell dateCell =3D=
 =
(DateCell) cell;<BR>&gt; String pattern =3D =
((SimpleDateFormat)dateCell.getDateFormat<BR>&gt; ()).toPattern();<BR>&gt; =
SimpleDateFormat sdf =3D new SimpleDateFormat(pattern);<BR>&gt; Date =
date=3Dnull;<BR>&gt; try {<BR>&gt; date =3D =
sdf.parse(dateCell.getContents());<BR>&gt; } catch (ParseException e) =
{<BR>&gt; throw new RuntimeException();<BR>&gt; }<BR>&gt;<BR>&gt; return =
date;<BR>&gt; ...<BR>&gt;<BR>&gt; Since I dont know if this is the right =
place and/or prefered type<BR>&gt; of fix.<BR>&gt; How and when can I get a=
 =
=66ix for ddsteps for this problem=3F Do I<BR>&gt; need to create an issue =
in jira=3F<BR>&gt;<BR>&gt; Thanks<BR>&gt; Saad.<BR>&gt;<BR>&gt;<BR>&gt; =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR>&gt;=
 Confidentiality Notice: The information contained in and<BR>&gt; =
transmitted with this communication is strictly confidential, is<BR>&gt; =
intended only for the use of the intended recipient, and is the<BR>&gt; =
property of Countrywide Financial Corporation or its affiliates and<BR>&gt;=
 =
subsidiaries. If you are not the intended recipient, you are<BR>&gt; hereby=
 =
notified that any use of the information contained in or<BR>&gt; transmitte=
d=
 with the communication or dissemination, distribution,<BR>&gt; or copying =
of this communication is strictly prohibited by law. If<BR>&gt; you have =
received this communication in error, please immediately<BR>&gt; return thi=
s=
 communication to the sender and delete the original<BR>&gt; message and an=
y=
 copy of it in your possession.<BR>&gt; =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR>&gt;<BR>&gt=
;=
 =
----------------------------------------------------------------------<BR>&=
gt;=
 ---<BR>&gt; Take Surveys. Earn Cash. Influence the Future of IT<BR>&gt; =
Join SourceForge.net's Techsay panel and you'll get the chance to<BR>&gt; =
share your<BR>&gt; opinions on IT &amp; business topics through brief =
surveys - and earn cash<BR>&gt; <A class=3Dmsg-link =
href=3D"http://www.techsay.com/default.php=3F" =
target=3D_blank>http://www.techsay.com/default.php=3F</A><BR>&gt; =
page=3Djoin.php&amp;p=3Dsourceforge&amp;CID=3DDEVDEV_______________________=
_________<BR>&gt;=
 _______________<BR>&gt; ddsteps-user mailing list<BR>&gt; =
dds...@li...<BR>&gt; <A class=3Dmsg-link =
href=3D"https://lists.sourceforge.net/lists/listinfo/ddsteps-user" =
target=3D_blank>https://lists.sourceforge.net/lists/listinfo/ddsteps-user</=
A><BR><BR></BLOCKQUOTE></FONT>
<P></P></FONT>
<P><pre =
wrap>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Confidentiality Notice: The information contained in and transmitted with =
this communication is strictly confidential, is intended only for the use o=
=66=
 the intended recipient, and is the property of Countrywide Financial =
Corporation or its affiliates and subsidiaries.  If you are not the intende=
d=
 recipient, you are hereby notified that any use of the information =
contained in or transmitted with the communication or dissemination, =
distribution, or copying of this communication is strictly prohibited by =
law.  If you have received this communication in error, please immediately =
return this communication to the sender and delete the original message and=
 =
any copy of it in your possession.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
</pre></P></body></html>