Issue 40753 - Exporting to Excel from Calc saves Date Format as a custom format
Summary: Exporting to Excel from Calc saves Date Format as a custom format
Status: CLOSED DUPLICATE of issue 31933
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 1.1.4
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-01-16 19:23 UTC by peschtra
Modified: 2005-01-19 08:02 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
File in Calc with correct formatting (8.50 KB, application/vnd.sun.xml.calc)
2005-01-16 19:26 UTC, peschtra 		no flags Details
File in Excel with incorrect formatting (date as custom format) (10.00 KB, application/vnd.ms-excel)
2005-01-16 19:27 UTC, peschtra 		no flags Details
File when if opened in Excel it lists the cells with a date format, but opening in OOo lists as a custom format (9.50 KB, application/vnd.ms-excel)
2005-01-16 19:28 UTC, peschtra 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description peschtra 2005-01-16 19:23:21 UTC 
When I save a spreadsheet with with cells in mate format (OOo format code
M/DD/YYYY) as and excel spreadsheet it is imported in excell as a custom format
code rather than as a Date format code.

The same happens in reverse. That is if I edit the cell format in excel to be a
date format and the open the .xls file in OOo, OOo interprest it as a custom
format code, not as a date code.

This isn't a problem if I am only using OOo or Excel, but the transfer over to a
custom format code causes trouble when I export to my Palm using Docs to Go.

Is there a way we can format the cell so that Excel recognized it as a Date code?

I have attached two file. The OOo Calc file that has the date format code & the
excel file that has it recgonized as a custom code.
Comment 1 peschtra 2005-01-16 19:26:10 UTC 
Created attachment 21572 [details]
File in Calc with correct formatting
Comment 2 peschtra 2005-01-16 19:27:12 UTC 
Created attachment 21573 [details]
File in Excel with incorrect formatting (date as custom format)
Comment 3 peschtra 2005-01-16 19:28:09 UTC 
Created attachment 21574 [details]
File when if opened in Excel it lists the cells with a date format, but opening in OOo lists as a custom format
Comment 4 frank 2005-01-18 15:02:04 UTC 
Hi,

this is a double to Issue 31933.

Frank

*** This issue has been marked as a duplicate of 31933 ***
Comment 5 frank 2005-01-18 15:02:36 UTC 
closed double
Comment 6 peschtra 2005-01-18 23:39:07 UTC 
Sorry about that. Never would have searched for that. :(
Comment 7 frank 2005-01-19 08:02:47 UTC 
So would I, I've asked the developer as I had in mind that we had something like
this before.

FRank