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@lists.freedesktop.org ReportedBy: nkout...@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. _______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs