Bug 166664

Summary: date conversion not exported correctly
Product: [Fedora] Fedora Reporter: Paul F. Johnson <paul>
Component: openoffice.orgAssignee: Caolan McNamara <caolanm>
Status: CLOSED UPSTREAM QA Contact:
Severity: medium Docs Contact:
Priority: medium    
Version: rawhideCC: darren
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2005-08-24 14:45:19 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Paul F. Johnson 2005-08-24 14:20:17 UTC
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:

Comment 1 Caolan McNamara 2005-08-24 14:45:19 UTC
A commonly reported thing, but oddly it's the expected behaviour.

http://qa.openoffice.org/issues/show_bug.cgi?id=4925

Comment 2 Caolan McNamara 2005-09-28 13:14:39 UTC
*** Bug 169338 has been marked as a duplicate of this bug. ***