Bug 166664 - date conversion not exported correctly
Summary: date conversion not exported correctly
Status: CLOSED UPSTREAM
Alias: None
Product: Fedora
Classification: Fedora
Component: openoffice.org
Version: rawhide
Hardware: All
OS: Linux
medium
medium
Target Milestone: ---
Assignee: Caolan McNamara
QA Contact:
URL:
Whiteboard:
Keywords:
: 169338 (view as bug list)
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2005-08-24 14:20 UTC by Paul F. Johnson
Modified: 2007-11-30 22:11 UTC (History)
1 user (show)

(edit)
Clone Of:
(edit)
Last Closed: 2005-08-24 14:45:19 UTC

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)


External Trackers
Tracker ID Priority Status Summary Last Updated
OpenOffice.org 4925 None None None Never

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. ***
Note You need to log in before you can comment on or make changes to this bug.