Apache OpenOffice (AOO) Bugzilla – Issue 20642
Formatted Date Fields lose format when saved as CSV
Last modified: 2003-10-07 10:44:51 UTC
I receive a csv file in which I have to change the dates from MM/YY/DD to YYYY-MM-DD. I see the change on screen, but when I save the file the dates revert to their original format. Steps to reproduce: Create a new spreadsheet with data like so: Name Join Date Jane Doe 01/01/01 Alice Jones 01/02/01 Sally Smith 01/03/01 Marge Simpson 01/04/01 Click on the "Join Date" column heading to select the column. Go to Format/Cells/Date/ and choose the YYYY-MM-DD setting and then ok. Observe the change on screen. Save file as a csv. Close and reopen. At the import prompt, note that all dates are now formatted as MM/DD/YYYY. Finish the import process and note that the dates now display as MM/DD/YY format. This is the only reason that I continue to use Excel. I need to have my dates in YYYY-MM-DD format in a CSV file to import into MySQL, and OpenOffice can't handle that.
Please Attach the documents which make this problem, so we can test it/faster to confirm. (Without the documents, we cannot confirm the problem easily/need more time) Don't forget to cut other part of the documents, so the file size is small, but we still able to see the problem.
Created attachment 10056 [details] csv file
Hi, this is a duplicate to Issue 4925. Therefore I've set the flags. Frank *** This issue has been marked as a duplicate of 4925 ***
closed double