Issue 10707 - dates entered in a cell are off by one day when opened with excel
Summary: dates entered in a cell are off by one day when opened with excel
Status: CLOSED DUPLICATE of issue 8281
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: 643
Hardware: PC Linux, all
: P2 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-01-16 15:51 UTC by Unknown
Modified: 2006-07-19 09:33 UTC (History)
1 user (show)

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

Attachments
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 Unknown 2003-01-16 15:51:06 UTC 
1. openoffice create a new spread sheet.  In cell A1 enter 01/16/2003, save the
   spread sheet as type Microsoft Excel 97/2000/XP .xls.
2. Use excel (I used excel 97 on WIN2K), open the spreadsheet, the date will be
   01/17/03 in cell A1
3. In excel cell A2 add text 01/16/2003 and save the spreadsheet.
4. Back in open office open the spreadsheet, cell A2 will have 01/15/03.

I have tried adjusting the date formats for the cells, no success.

Thanks.
Comment 1 frank 2003-01-16 15:58:42 UTC 
Hi Jay,

this is a double to Issue 8281

So I close it.

Frank

*** This issue has been marked as a duplicate of 8281 ***
Comment 2 frank 2003-01-16 15:59:12 UTC 
closed as double
Comment 3 delorea 2006-07-19 09:33:48 UTC 
*** Issue 67074 has been marked as a duplicate of this issue. ***