poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From MSB <markbrd...@tiscali.co.uk>
Subject Re: Setting Date object in Excel File
Date Sat, 28 Feb 2009 09:46:43 GMT

Assuming that you are talking about inserting a formatted String into a cell
that is typed to hold text then I can forsee one problem - what if the user
wishes to include the date value in some forumla; to calculate elapsed time
for example?


Dave Fisher-6 wrote:
> 
>>  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: user-unsubscribe@poi.apache.org
>> For additional commands, e-mail: user-help@poi.apache.org
>>
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/Setting-Date-object-in-Excel-File-tp22251385p22260351.html
Sent from the POI - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message