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?
Probably the best way is have a routine that allowed a formatted
string to be used.
It would have to be something like setCellValueDate(String
date,java.text.dateFormat formatter).
There would also be a getCellValueDate(java.text.dateFormat formatter).
It is a thought. It might solve some other issues.
Dave
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
