I am using the Java SimpleDateFormat to convert times into text for headings. What I found was the times shown in my heading were an hour different than the times shown in my data cells in the sheet. Attached is a file with a snipet of code that takes the same Date and in one case converts it into a string using SimpeDateFormat and puts the result into a cell and in the other case it puts the Date object into another cell and then setting the Style formatting to display the Date in a similar format. The dates are 2 hours apart. (I am running in America/Chicago timezone and it is currently daylight savings here.) What am I missing? Is there a problem with handling of dates in cells or do I need to manipulate the Date object before inserting into cell?
Thanks for any help.