[Libreoffice-bugs] [Bug 48633] New: Calc (mis-)dates for years between 1/Jan/1831-15/Apr/1880
bugzilla-daemon at freedesktop.org
bugzilla-daemon at freedesktop.org
Fri Apr 13 07:30:49 CEST 2012
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.
More information about the Libreoffice-bugs
mailing list