[Libreoffice-bugs] [Bug 51697] New: EDITING: Cell format for date is not taken into account when entering data
bugzilla-daemon at freedesktop.org
bugzilla-daemon at freedesktop.org
Tue Jul 3 22:18:47 CEST 2012
https://bugs.freedesktop.org/show_bug.cgi?id=51697
Bug #: 51697
Summary: EDITING: Cell format for date is not taken into
account when entering data
Classification: Unclassified
Product: LibreOffice
Version: 3.5.4 release
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Status Whiteboard: BSA
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: libreoffice-bugs at lists.freedesktop.org
ReportedBy: matteosistisette at gmail.com
Problem description:
Steps to reproduce:
1. Right click on a cell, select "format cells"
2. For "Category" select "Date", and for "format" select "31/12/99"
3. Type into the cell: 02/01/12
Current behavior:
The date is interpreted according to the current locale. If the current locale
is USA, it is interpreted as February 1 and it comes out displayed as
"01/02/12"
Expected behavior:
The date should be interpreted according to the format that has been assigned
to the cell. So since the cell is formatted as "31/12/99", it should be
interpreted as January 2 and it would show up as you typed it.
Platform (if different from the browser):
Browser: Mozilla/5.0 (X11; Linux i686) AppleWebKit/536.11 (KHTML, like Gecko)
Chrome/20.0.1132.47 Safari/536.11
--
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