Hey, My recommendation would have a method called setCellValue(Date d, TimeZone tz) which creates a GregorianCalendar with the timezone given. Then the date set in the timezone would be exactly what I want it.
The setCellValue(Date date) method as it is right now already creates a GregorianCalendar (but it creates it with the default time zone) -- why can't we make this configurable to what the user wants? noobguru MSB wrote: > > Yes, but you are going to need to use formulae to do so I think. Have a > look at this link; > > http://www.exceltip.com/st/Converting_Time_Values_from_One_Time_Zone_to_Another/834.html > > it sort of gives you an idea of how to use a formula to do the work. Your > best bet may be to have another sheet where there are all the possible > timezones entered accompanied by the number of hours each is either in > front of or behind your default. Then you can link into them using > formulae I would guess. The timzone could be shown alongside each > date/time value and - if the user changes it - the formula could be used > to recalculate the value displayed in the cell. Not something I have done > myself but it must be possible. > > I could very well be wrong but I do not think that it is possible to just > use the formatting options available on the cell nor do I think there is > an option to change your time zone at the global - application - level as > there is with OpenOffice. > > > noobguru wrote: >> >> Hi, >> >> So I'm trying to call the Cell cell.setCellValue(java.util.Date) >> method. It puts the date in my excel file great, however it's showing the >> date as my default timezone of my system. I don't want it to show that, >> I want it to show a date according to any time zone I want. Is there a >> way to do this? >> >> Thanks, >> noobguru >> > > -- View this message in context: http://www.nabble.com/Setting-Date-object-in-Excel-File-tp22251385p22254001.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
