Red Hat Bugzilla – Bug 166664
date conversion not exported correctly
Last modified: 2007-11-30 17:11:12 EST
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):
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
The dates will be in the original format
The dates should be in the new format
A commonly reported thing, but oddly it's the expected behaviour.
*** Bug 169338 has been marked as a duplicate of this bug. ***