[Upstream] Edit Date format does not match configured date format
Bug #391572 reported by
dotancohen
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
LibreOffice |
Fix Released
|
High
|
|||
OpenOffice |
Unknown
|
Low
|
|||
libreoffice (Ubuntu) |
Fix Released
|
Undecided
|
Björn Michaelsen | ||
openoffice.org (Ubuntu) |
Won't Fix
|
Low
|
Unassigned |
Bug Description
Binary package hint: openoffice.org-calc
When editing a date in Calc, the date format used to edit the date does not match the date format configured for the cell.
Steps to reproduce:
1) Right-Click on a cell -> Format Cells -> Numbers -> Category -> Date -> Choose format 31/12/1999
2) Enter into that cell my wedding day: September 2, 2005: 2/9/2005
What is displayed?
February 9, 2005: the day of a car bombing.
What is expected to be displayed?
September 2, 2005: my wedding day.
Changed in openoffice.org (Ubuntu): | |
importance: | Undecided → Low |
status: | New → Triaged |
summary: |
- Edit Date format does not match configured date format + [upstream] Edit Date format does not match configured date format |
Changed in openoffice: | |
status: | Unknown → Confirmed |
Changed in openoffice.org (Ubuntu): | |
status: | Triaged → Won't Fix |
summary: |
- [upstream] Edit Date format does not match configured date format + Edit Date format does not match configured date format |
Changed in df-libreoffice: | |
importance: | Undecided → Unknown |
status: | New → Unknown |
summary: |
- Edit Date format does not match configured date format + [Upstream] Edit Date format does not match configured date format |
Changed in df-libreoffice: | |
importance: | Unknown → High |
status: | Unknown → Fix Released |
Changed in openoffice: | |
importance: | Unknown → Low |
To post a comment you must log in.
When a cell date format is set to yyyy-mm-dd, the input line will show US format
mm/dd/yyyy. Also, when the cell is doubleclicked it also changes to US format
(from yyyy-mm-dd) until Enter is pressed.
To reproduce:
Language: Default
1. Open a new spreadsheet.
2. Format a cell A1 to Date in the format yyyy-mm-dd
- Highlight cell A1
- on the menu select "format->cells..."
- select Category: Date
Format : 1999-12-31
Note: The Format Code shows YYYY-MM-DD
3. In the cell enter date 2002-06-04; press "Enter"
4. Highlight the cell again
THE INPUT LINE SHOWS DATE AS: 06/04/2002
5. Doubleclick the cell
THE CELL SHOWS DATE AS: 06/04/2002
A. The cell should ALWAYS show the date in the format set for the cell.
B. The input line should ALWAYS show the date in the format set for the cell.
My OS is Windows 2000 US version.
available)
The regional options are:
-General
- Your locale: English (United States)
-Date
- Short date format: yyyy-MM-dd
- Long date format: dddd, dd MMMM, yyyy (since yyyy-mm-dd, dddd is not