Bug 38231 - Edit field command - data format: Change "31 Dec 1999" to one digit day
Summary: Edit field command - data format: Change "31 Dec 1999" to one digit day
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
3.3.2 release
Hardware: Other All
: medium enhancement
Assignee: Andreas Heinisch
URL:
Whiteboard: target:24.8.0
Keywords:
: 49868 90601 130107 (view as bug list)
Depends on:
Blocks: Fields
  Show dependency treegraph
 
Reported: 2011-06-13 02:13 UTC by Tobias Burnus
Modified: 2024-01-23 09:11 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Tobias Burnus 2011-06-13 02:13:18 UTC
If one inserts -> field command -> date & time -- and then double clicks on the date, one enters the  edit field command  dialog, where one can choose the date.

The example date (December 31, 1999) is badly chosen as one cannot distinguish showing the day as "31" or as "31". I would suggest a one-digit day, e.g. 2 such that one has "2" vs. "02" instead.

That is: Currently one has
  31 December 1999
  31 December 1999
in the list. Expected:
   3 December 1999
  03 December 1999
Comment 1 Björn Michaelsen 2011-12-23 12:26:03 UTC Comment hidden (obsolete)
Comment 2 Florian Reisinger 2012-08-14 14:01:33 UTC Comment hidden (obsolete)
Comment 3 Florian Reisinger 2012-08-14 14:02:37 UTC Comment hidden (obsolete)
Comment 4 Florian Reisinger 2012-08-14 14:07:12 UTC Comment hidden (obsolete)
Comment 5 Florian Reisinger 2012-08-14 14:09:18 UTC Comment hidden (obsolete)
Comment 6 Tobias Burnus 2012-08-14 15:00:43 UTC
Still unchanged with LibreOffice 3.6.0.4

Quoting comment 0:
  If one inserts -> field command -> date & time -- and then double clicks on
  the date, one enters the  edit field command  dialog, where one can choose the
  date.

The problem is that there are multiple "31 Dec 1999" - one meaning a leading zero the other not. Example: "2 Dec 1999" or "02 Dec 1999". Thus, choosing a two-digit day of the month is not useful.
Comment 7 Florian Reisinger 2012-08-15 15:01:07 UTC
Okay, IMHO that should not be soo difficult...
Comment 8 sophie 2014-07-21 13:33:04 UTC
*** Bug 49868 has been marked as a duplicate of this bug. ***
Comment 9 QA Administrators 2015-09-04 02:47:57 UTC Comment hidden (obsolete)
Comment 10 Robinson Tryon (qubit) 2015-12-13 11:20:57 UTC Comment hidden (obsolete)
Comment 11 QA Administrators 2018-09-21 02:48:07 UTC Comment hidden (obsolete)
Comment 12 Tobias Burnus 2018-09-21 13:57:58 UTC
Still the same with 6.1.0.1: It shows multiple entries of the form
  31 Dec 1999
and it is not possible whether that would become
  01 Dec 1999
or
   1 Dec 1999
if the day is single digit
Comment 13 QA Administrators 2019-09-22 02:59:44 UTC Comment hidden (obsolete)
Comment 14 Buovjaga 2019-10-22 16:35:11 UTC
*** Bug 90601 has been marked as a duplicate of this bug. ***
Comment 15 sdc.blanco 2020-01-21 12:30:59 UTC
*** Bug 130107 has been marked as a duplicate of this bug. ***
Comment 16 Mike Kaganski 2022-05-05 06:13:08 UTC
This is unrelated to "fields", and only relates to UI list of formats. Don't see why "needsDevEval" was in keywords.
Comment 17 Commit Notification 2024-01-22 19:14:15 UTC
Andreas Heinisch committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/58cfe9ccff7b6aa8ada18234ee73809700c39e02

tdf#38231 - Change default example date value to 1999-12-01

It will be available in 24.8.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 18 Andreas Heinisch 2024-01-23 09:11:28 UTC
There are still some problems with this sample date since now months and days may not be distinguished, e.g., 07.08.2024. MS uses 14. March 2012 where one can't still distinguish D vs. DD (09 or 9 for the day)