Hi,

I stumbled upon an issue with the current handling of dates in the Cell implementation of the simple API and would appreciate any feedback.

In Cell there are currently two methods for setting date and time values. The method setDateValue() uses the format yyyy-MM-dd, setTimeValue() uses the format 'PT'HH'H'mm'M'ss'S'.

According to the ODF specification the date format for office:date-value, which is used in Cell, can either be http://www.w3.org/TR/2004/REC-xmlschema-2-20041028/#date or http://www.w3.org/TR/2004/REC-xmlschema-2-20041028/#dateTime

It seems to me that we are missing a method to set a date and time value, we can either set date or time, but not both. Also, from my understanding, the time format we are currently using is not valid as it is missing the date part.

At first I thought we just might need another method that sets both date and time but probably we also have to change the format for the existing time method.

What do you think? Am I missing something?

Regards
Florian

--
Florian Hopf
Freelance Software Developer

http://blog.florian-hopf.de

Reply via email to