Bug 69356 - FORMATTING: DDDDD ordinal day date format not yet available
Summary: FORMATTING: DDDDD ordinal day date format not yet available
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
(earliest affected)
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
Whiteboard: BSA Confirmed:
Depends on:
Blocks: Number-Format Fields
  Show dependency treegraph
Reported: 2013-09-14 14:09 UTC by 2chezturtle
Modified: 2019-04-17 10:15 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Document showing (un)superscripted dates. (9.66 KB, application/vnd.oasis.opendocument.text)
2013-11-26 10:53 UTC, 2chezturtle

Note You need to log in before you can comment on or make changes to this bug.
Description 2chezturtle 2013-09-14 14:09:10 UTC
Today in the UK the date is Saturday 14th September 2013 but Libreoffice still doesn't allow this as a default date format. 

Steps to reproduce:
1. INSERT....OTHER....DATE etc
2. Select format from selection list (or create own using DDDDD)
3. ....

Current behavior: Saturday 14 September 2013
14 September
1 Janvier

Expected behavior: Saturday 14th September 2013
14th September
1er Janvier

Operating System: All
Version: unspecified
Comment 1 Robinson Tryon (qubit) 2013-11-25 05:28:18 UTC
CONFIRMED in Libreoffice + Ubuntu 12.04.3

Entering "DDDDD" as the number Format code results in (the equivalent of) "Saturday14".

"DDDDD" ordinal day date format does not appear in Help files yet, either:

Severity -> enhancement
Status -> NEW
Comment 2 2chezturtle 2013-11-26 10:53:37 UTC
Created attachment 89826 [details]
Document showing (un)superscripted dates.
Comment 3 Russell Knighton 2015-02-10 14:48:16 UTC
Just wanted to add a bump to this enhancement request as automatic date fields are basically unusable for me without the ability to include an ordinal in the day portion of the date.
Comment 4 Eike Rathke 2019-04-17 10:14:46 UTC
As of LibreOffice 6.1 ordinal numbers in number format codes are available with the NatNum12 modifier. For this example that would be the format code

 [NatNum12 D=ordinal-number]DDDD D

See the NatNum12 section at the bottom of https://help.libreoffice.org/6.2/en-US/text/shared/01/05020301.html