Anyone else experienced this? We use ODS HTML to write a .xls file with a date field column formatted yymon7, for example May-09. When the html opens in excel 2007, it looks fine. But if anything is modifed and saved, the field instead becomes 5-9-2010. I've even tried creating a character field to hold the month/year, and it still converts to a date in 2010, converting the month to month, year to day, and adding 2010 as the year. If we do a file save as in excel, and save it to excel 97-2003, or as an xlsx, then it is ok. Also, if keeping as file type html, it creates a whole folder of html output, filelist, sheet001, stylesheet, tabstrip. This did not happen in 9.1.3, with excel 2003.
... View more