Bug 62683 - EDITING: [Bug 52619] EDITING: 1 day is subtracted if typed date is before July 26, 1790
Summary: EDITING: [Bug 52619] EDITING: 1 day is subtracted if typed date is before Jul...
Status: RESOLVED DUPLICATE of bug 52619
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.4.3 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2013-03-24 00:28 UTC by JC
Modified: 2013-03-24 16:27 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Date conversion calculator: Enter Quaker dates as d, m, y in cells b3, c3, d3; yields Gregorian date in cell f3. Bug occurs when converted date is earlier than 27 Jul, 1790 (9.76 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-03-24 00:28 UTC, JC 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description JC 2013-03-24 00:28:03 UTC 
Created attachment 76956 [details]
Date conversion calculator: Enter Quaker dates as d, m, y in cells b3, c3, d3; yields Gregorian date in cell f3. Bug occurs when converted date is earlier than 27 Jul, 1790

Problem description: 
Already in the system [Bug 52619] EDITING: 1 day is subtracted if typed date is before July 26, 1790

I'm experiencing this bug in the US, Mountain Time Zone DST, UTC-6;
Previous reports seem to have involved certain European time zones.
Steps to reproduce:
I encountered it using the date() formula; then after reading the 52619 bug messages, I see that it also happens when typing the date.

Current behavior:
Subtracts one day from the entered or calculated date, for dates before 27 July, 1790
Expected behavior:
Display and use dates as entered or calculated.

I'm Using v 3.6.4.3 (Build ID: 2ef5aff) with Windows 7, on a HP Pavilion dv6 Notebook, with Intel Core i5 CPU M480, 64 bit

Thanks!
              
Operating System: Windows 7
Version: 3.6.4.3 release
Comment 1 bfoman (inactive) 2013-03-24 16:27:30 UTC 
No need to file a new report for known bug - please add a comment instead.

*** This bug has been marked as a duplicate of bug 52619 ***