Issue 10749 - excel spreadsheet dates ioff by one
Summary: excel spreadsheet dates ioff by one
Status: CLOSED DUPLICATE of issue 8281
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: 643C
Hardware: PC Linux, all
: P2 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-01-18 01:27 UTC by Unknown
Modified: 2003-09-08 16:55 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-18 01:27:34 UTC 
Sorry if this is a duplicate, my session timed out when I entered this the
first time, I was not able to find the issue so here it is again.

1. In excel (I used excel 97, win2k) create a spreadsheet.
2. In cell A1 enter 01/15/2003 and save as Microsoft excel 97/2000/XP .xls
3. In open office open the spread sheet.  The date in cell A1 will be 01/14/2003.
4. In cell A2 enter 01/15/2003 and save.
5. Re-open the spread sheet in excel, the date in A2 will be 01/16/2003.

I have tried adjusting the date display and cell formating with no success.

Thanks.
Comment 1 daniel.rentz 2003-01-20 08:31:50 UTC 
double

*** This issue has been marked as a duplicate of 8281 ***
Comment 2 daniel.rentz 2003-01-20 08:32:00 UTC 
double->closed