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-tp22251385p22252079.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]
