Issue 12484 - Dates appear one day off in OOo compared to MS Excel
Summary: Dates appear one day off in OOo compared to MS Excel
Status: CLOSED DUPLICATE of issue 8281
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: 643C
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-03-19 19:06 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
Screenshot showing same spreadsheet open in Excel and OOo with different dates displayed (197.53 KB, image/jpeg)
2003-03-19 19:07 UTC, Unknown 		no flags Details
Spreadsheet that has this date problem (41.50 KB, text/xls)
2003-03-19 19:29 UTC, Unknown 		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 Unknown 2003-03-19 19:06:42 UTC 
I have a spreadsheet created in Excel that lists dates in it. When I open it in
OOo 643c the dates are consistently one day behind. For example, a date listed
in spreadsheet in Excel is shown as "03/07/03 Friday". In OOo is is shown as
"03/06/03 Thursday". Same spreadsheet. This is very problematic and very scary
to my end users. What is the reason for this?

I will be posting this spreadsheet and a screenshot showing the spreadsheet in
Excel and OOo shortly.
Comment 1 Unknown 2003-03-19 19:07:43 UTC 
Created attachment 5170 [details]
Screenshot showing same spreadsheet open in Excel and OOo with different dates displayed
Comment 2 Unknown 2003-03-19 19:29:16 UTC 
Created attachment 5173 [details]
Spreadsheet that has this date problem
Comment 3 frank 2003-03-20 07:53:06 UTC 
Hi Brian,

what's about using the search facility of Issuezilla to grep for Dates ?

You will find some duplicates to this one.

So I close this one also as duplicate.

Frank

*** This issue has been marked as a duplicate of 8281 ***
Comment 4 frank 2003-03-20 07:53:22 UTC 
closed double