Issue 10707

Summary:	dates entered in a cell are off by one day when opened with excel
Product:	Calc	Reporter:	Unknown <non-migrated>
Component:	code	Assignee:	oc
Status:	CLOSED DUPLICATE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P2	CC:	issues
Version:	643
Target Milestone:	---
Hardware:	PC
OS:	Linux, all
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

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. ***