[Libreoffice-bugs] [Bug 48633] New: Calc (mis-)dates for years between 1/Jan/1831-15/Apr/1880

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=48633

             Bug #: 48633
           Summary: Calc (mis-)dates for years between
                    1/Jan/1831-15/Apr/1880
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO 3.5.2 Release
          Platform: x86 (IA32)
        OS/Version: Windows (All)
            Status: UNCONFIRMED
          Severity: major
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: nkoutsou at otenet.gr


Created attachment 59891
  --> https://bugs.freedesktop.org/attachment.cgi?id=59891
date ranges that illustrate the 'bug'

If you enter any date between 1/Jan/1830-15/Apr/1880 and Libreoffice Calc
enters it as -1d.

i.e. enter any date in the range 1/Jan/1831-15/Apr/1880 and calc will register
the value as -1d from the date entered. 
E.g. enter 1/1/1880 press enter and the cell will get the value 31/12/1879

To overcome you need to enter dates as +1d.
If you want to enter 18/1/1880 (d/m/yyyy) you should enter 19/1/1880 (d/m/yyyy)
As a result it is also ***impossible*** to enter 14/4/1880

See attached for illustration fo the problem.

Notes: Bug found/tested in: 
1. LibreOffice 3.5.0rc3 
Build ID: 7e68ba2-a744ebf-1f241b7-c506db1-7d53735
2.LibreOffice 3.5.2.2 
Build ID: 281b639-6baa1d3-ef66a77-d866f25-f36d45f 

Cheers,

N.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.