Run the patches from phpMyAdmin root directory.
The correct way for dates seems to be like this:
<table:table-cell office:value-type="date" office:date-value="2009-09-10">. So I added that to ods.php (also time).
However, a strange thing is that, if you don't specify a style, nothing seems to display. I'm not quite sure why. So I've also specified three non-existent styles: DateCell, TimeCell, DateTimeCell. So this is patch 1; mainly it corrects the type from String to Date or Time.
Patch 2 actually defines DateCell, TimeCell, and DateTimeCell. I thought these were supposed to be defined in styles.xml, so I tried that but with no luck. So I've defined them in content.xml instead. Maybe an expert in OO can help more.
Thomas
A patch to correct Date, Time, and DateTime in ODS Export
Merged in subversion, thanks.
Looks good, thanks for the patch!