Description: It concerns date fields for the format "31 janvier 1999" (and also for "vendredi 31 janvier 1999", maybe others). It works for all day in the month but the first because in french, you don't say "le UN janvier" but le "le PREMIER janvier". Therefore, it should NOT be written "1 janvier 1999"* BUT "1er janvier 1999"["er" are smaller and higher character = "Exposant" in french]. A small detail but it needs to be fixed to reach perfection Pleas forward to the right team if not you Thanks a lot for your work on this wonderful software Actual Results: 1 février 2019 (date field with that format) Expected Results: 1er février 2019 (with "ER" small and high ("Exposant" in french) Reproducible: Always User Profile Reset: No Additional Info: I wrote almost nothing because I honestly could put the thing in the summary, please notice me briefly if I can do more THX
Please have a look at https://help.libreoffice.org/6.2/en-US/text/shared/01/05020301.html?DbPAR=SHARED#bm_id3153514 For example for "vendredi 1er février 2019" use the format string [NatNum12 J=ordinal-number]NNNNJ MMMM AAAA Does that meet your enhancement request? Status set to NEEDINFO. Please set it back to UNCONFIRMED once the requested information have been done. Best regards. JBF
Created attachment 149578 [details] example of date [NatNum12 J=ordinal-number] => 1er (1st) NOT working in french
The page you sent me is probably exactly what I am looking for. Unfortunately, I tried it, but I could not let it work for french (in fact, there is a warning on the very page you sent me to read : " Not all format codes give meaningful results for all languages.") My test ott is attached I don't intend to bother you with personnal concern, but I think this is a very standard date format in french letters which might be useful to add in standard french version of LibreOffice(wtriter). I also made that comment because I thought it could be easy to add. I hope you don't feel as my personnal LibreOfficeTeacher. For the moment being, I don't consider my request as solved, but I would understand if you abandon it considering it not a priority Merci beaucoup! (I do my best to be a LibreOffice Ambassador in my local administration, I hope it will eventually result in a better (?financial) support from the leaders) Kind regards, C.Morand
it seems you're using an old version of LibreOffice. Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
Confirmed with Version: 6.2.4.2 Build ID: 2412653d852ce75f65fbfa83fb7e7b669a126d64 Threads CPU : 8; OS : Mac OS X 10.14.5; UI Render : par défaut; VCL: osx; Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR Calc: threaded Insert a date field, if not on first of the month, adjust date by adding or subtracting days to get to first day of month. Change date (right mouse button click on date field) format to long date. Ordinal is not displayed.
(In reply to Alex Thurgood from comment #5) > Change date (right mouse button click on date field) format to long date. > Sorry, double-click on date field, not right mouse button click.
Jean-Baptiste's suggested custom formatting also works...so this should really be in the default list ?
(In reply to Alex Thurgood from comment #7) > Jean-Baptiste's suggested custom formatting also works...so this should > really be in the default list ? Sure but it should be shown only for French and with a correct example, that is not 31/12/1999, but 01/12/1999. I do not know how to do that. Best regards. JBF
List of format examples is defined for each local in: https://opengrok.libreoffice.org/xref/core/i18npool/source/localedata/data/fr_FR.xml?r=d5146c0e#145 Default displayed value is defined here: https://opengrok.libreoffice.org/xref/core/include/svx/flagsdef.hxx?r=c049c76f#86 But it is the same value for all languages. Shall we increase SvxNumValCategory::Date and SvxNumValCategory::Time by 2 (to avoid same value for day and month) => January, 2nd 2000 or decrease by 30 => December, 1st 2000 By the way, format [NatNum12 J=ordinal-number]NNNNJ MMMM AAAA add ordinal notation to all days, not only the first: vendredi 31ᵉ décembre 1999 which may be not expected by user. We need a conditional formatting to follow typographic rules.