Description of problem: If I have a column of dates in the usual dd/mm/yyyy format and convert it to YYYY-MM-DD (for use in MySQL) and then export the spreadsheet to a csv file, the dates remain in the original format Version-Release number of selected component (if applicable): 1.9.125 How reproducible: Alway Steps to Reproduce: 1. Start oocalc and enter a column of dates. 2. select the entire column and alter the date format 3. file->save as->somefile.csv Actual results: The dates will be in the original format Expected results: The dates should be in the new format Additional info:
A commonly reported thing, but oddly it's the expected behaviour. http://qa.openoffice.org/issues/show_bug.cgi?id=4925
*** Bug 169338 has been marked as a duplicate of this bug. ***