Description: In regio Flanders, in Belgium, we enter date as: DD-MM-JJJJ (JJJJ is Dutch for YYYY). For easy sorted lists we format the date automatically to JJJJMMDD So, when entering in a cell f.e. 14/2/2017 Calc should display 20170214 That does not work for our language Dutch (BE). Calc displays 14/2/2017 That does work for neighbour language Dutch (NL). Calc displays 20170214 Steps to Reproduce: 1. cell format : category Date; layout JJJJMMDD (OR JJJJMMDD); Language Dutch (Belgium) 2. cell input date, fe 14/2/2017 3. displays 14/2/2017 ans should display 20170214 Actual Results: date formatted in JJJJMMDD displays wrong for language Dutch (Belgium) Expected Results: I use Dutch (NL) to have the correct display of JJJJMMDD for my country (BE) Reproducible: Always User Profile Reset: No Additional Info: I add an attach to the bug: LibreOffice_Calc_FormatDate-YYYYMMDD_Dutch-BE_Wrong.pdf User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.115 Safari/537.36
Created attachment 135221 [details] LibreOffice_Calc_FormatDate-YYYYMMDD_Dutch-BE_Wrong.pdf
Created attachment 135223 [details] display date format I can not confirm behavior Version: 6.0.0.0.alpha0+ Build ID: e371ec501db0c473bea7ef7325d9a9049f913b5e CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; Locale: nl-BE (en_US.UTF-8); Calc: group
And can not confirm in Version: 5.3.4.2 Build ID: SlackBuild for 5.3.4 by Eric Hameleers CPU Threads: 8; OS Version: Linux 4.9; UI Render: default; VCL: kde4; Layout Engine: new; Locale: nl-BE (en_US.UTF-8); Calc: group
Created attachment 135232 [details] Calc Format Date YYYYMMDD Dutch Displays Unreliable Even with a brand new Calc Sheet there are problems with formatting the date in YYYY-MM-DD when switching between countries with the same language. My attachment LibreOffice_Calc_FormatDate-YYYYMMDD_Dutch_DisplaysUnreliable.pdf describes how to simulate date formatting, switching from Dutch (NL) to Dutch (BE). ATTENTION: the result format has to be YYYY-MM-DD (not YYYYMMDD).
Created attachment 135242 [details] Dutch NL to BE format Still no problems with changing between the two locals New spreadsheet and followed the description from the second pdf Version: 5.3.4.2 Build ID: SlackBuild for 5.3.4 by Eric Hameleers CPU Threads: 8; OS Version: Linux 4.9; UI Render: default; VCL: kde4; Layout Engine: new; Locale: nl-NL (en_US.UTF-8); Calc: group
Created attachment 135247 [details] Calc Format Date YYYY-MM-DD Dutch Displays Unreliable (as .ods) I made a calc sheet to simulate the YYYY-MM-DD problem in Dutch when switching from NL to BE (or BE to NL) Attachment: LibreOffice_Calc_FormatDate_YYYY-MM-DD_Dutch_DisplaysUnreliable.ods
The difference between the two locals is NL-nl: use the minus "-" to fill in the date; exp 8-8-2017 BE-nl: use the division "/" to fill in the date; exp 8/8/2017 so form me its not a bug and i have you removed from the assignee because this is only for developers
Created attachment 135295 [details] Calc Format Date JJJJ-MM-DD Local Date Delimiter Displays Not In calc, options, I changed the Dutch (BE) Local Date Delimiter from D/M/J into D-M-J formatted a cell to JJJJ-MM-DD entered 7-8-2017 expected 2017-08-07 result 7-8-2017 This is very confusing, even if it shouldn't be a bug. See: LibreOffice_Calc_FormatDate_JJJJ-MM-DD_Local-DateDelimiter_DisplaysNot.pdf and LibreOffice_Calc_FormatDate_JJJJ-MM-DD_Local-DateDelimiter_DisplaysNot.ods
Created attachment 135296 [details] Calc Format Date JJJJ-MM-DD Local Date Delimiter Displays Not (as .ods) In calc, options, I changed the Dutch (BE) Local Date Delimiter from D/M/J into D-M-J formatted a cell to JJJJ-MM-DD entered 7-8-2017 expected 2017-08-07 result 7-8-2017 This is very confusing, even if it shouldn't be a bug. See: LibreOffice_Calc_FormatDate_JJJJ-MM-DD_Local-DateDelimiter_DisplaysNot.pdf and LibreOffice_Calc_FormatDate_JJJJ-MM-DD_Local-DateDelimiter_DisplaysNot.ods
(In reply to Xavier Van Wijmeersch from comment #7) > The difference between the two locals is > NL-nl: use the minus "-" to fill in the date; exp 8-8-2017 > BE-nl: use the division "/" to fill in the date; exp 8/8/2017 > > so form me its not a bug > and i have you removed from the assignee because this is only for developers What do you mean with: " and i have you removed from the assignee because this is only for developers "
What do you mean with: "and i have you removed from the assignee because this is only for developers" Why well when set yourself as assignee this mean that you will provided a solution for the problem But my guess is your not a developer, and so the developers can not take a look to the problem, but the cc list is for us the demanding for help, and you will always receive a mail when there is a change or anything else And is it possible that you put ' before entering the date, that's why no result Otherwise i think you messed up some options in LO
(In reply to Xavier Van Wijmeersch from comment #11) > What do you mean with: > "and i have you removed from the assignee because this is only for > developers" > > Why well when set yourself as assignee this mean that you will provided a > solution for the problem > But my guess is your not a developer, and so the developers can not take a > look to the problem, but the cc list is for us the demanding for help, and > you will always receive a mail when there is a change or anything else > > And is it possible that you put ' before entering the date, that's why no > result > Otherwise i think you messed up some options in LO ah ok. Indeed I'm not a developer. I dont know how I came on that list.
(In reply to Xavier Van Wijmeersch from comment #11) > And is it possible that you put ' before entering the date, that's why no > result > Otherwise i think you messed up some options in LO I did not put a quotation mark (') while entering, before the date (to make it text). You can check that in my attachment: LibreOffice_Calc_FormatDate_JJJJ-MM-DD_Local-DateDelimiter_DisplaysNot.ods
Look in the input line and you will see a quotation mark (') before the 7 Delete it and you will have the correct format And i want to close these as not a bug, if no one have any objection
Created attachment 135340 [details] Calc Format Date JJJJ-MM-DD NO Quotation Mark, but Local Date Delimiter Displays NOT For me this date display isue, according cell date format and local settings, is not resolved. Hereby an attachment where you can see, that there is no quotation mark in the input cell. And still the date displays NOT according the cell date format (JJJJ-MM-DD) and the adapted calc Local Date accept setting (D-M-Y). See: LibreOffice_Calc_FormatDate_JJJJ-MM-DD_NO-QuotationMark_Local-DateDelimiter-DisplaysNOT.ods
(In reply to Xavier Van Wijmeersch from comment #14) > Look in the input line and you will see a quotation mark (') before the 7 > Delete it and you will have the correct format > This is right. Maybe I was too quick while making this example. But look at my attachment (20170809 at 14:00): LibreOffice_Calc_FormatDate_JJJJ-MM-DD_NO-QuotationMark_Local-DateDelimiter-DisplaysNOT.ods No Quotation Mark visible in the input cell, and still a bad date display.
Created attachment 135416 [details] Calc Local Date Delimiter Depends From Start Up Method LibreOffice Options behaviour! Windows7 Full Patched LibreOffice V5.3.4.2 Starting Calc from: the PortableApp Menu Item LibreOffice Date accept pattern: D-M-Y;D-M; Default Language: Nederlands (Belgie) Starting Calc from: File Browser: RightClick on .ods>Open Date accept pattern: D/M/Y;D/M Default Language: Standaard - Nederlands (Belgie Local Options settings are different, depending from the start method of calc !!
---------- Doorgestuurd bericht ---------- Van: Xavier van wijmeersch <xv3247@gmail.com> Datum: 10 augustus 2017 om 15:00 Onderwerp: Aan: rdiependaele@netscape.net laten we dit voor de software ontwikkelaars rusten ik woon 9660 Brakel en volgende week ben ik op 16/08/2017 in UZ-Gent om 12u ben ik dan vrij laten wij dit in stilte oplossen en ja je observatie is juist en eventueel is het probleem ergens anders vanuit mijn vrije bijdrage heb meermaals ervaren dat het geheel niet begrepen wordt en deze een persoonlijk ontmoeten kan het probleem oplossen vrijblijvend Xavier ========================== Xavier, no personal contact. No. For the moment, I do not know if this date format issue is a bug or a misunderstanding from me. We can continue via a LibreOffice forum. Give me one. If not, I can work around, while this behaviour always stays a secret: to bug or not to bug ;-)
Description: In regio Flanders, in Belgium, we enter date as: DD-MM-JJJJ (JJJJ is Dutch for YYYY). For easy sorted lists we format the date automatically to JJJJMMDD So, when entering in a cell f.e. 14/2/2017 (14th of February 2017) Calc should display 20170214 2017 August : Windows7 Pro Full Patched LibreOffice V5.3.4.2 Starting Calc from: the PortableApp Menu Item LibreOffice Date accept pattern: D-M-Y;D-M; Default Language: Nederlands (Belgie) Starting Calc from: File Browser: RightClick on .ods>Open Date accept pattern: D/M/Y;D/M Default Language: Standaard - Nederlands (Belgie) That did not work (2017 August) for our language Dutch (BE). Calc displayed 14/2/2017 That did work (2017 August) for neighbour language Dutch (NL). Calc displayed 20170214 Steps to Reproduce (2017 August): 1. cell format : category Date; layout JJJJMMDD; Language Dutch (Belgium) 2. cell input date, fe 14/2/2017 3. displays 14/2/2017 and should display 20170214 Actual Results (2017 August): date formatted in JJJJMMDD displays wrong for language Dutch (Belgium) Expected Results (2017 August): I used Dutch (NL) to have the correct display of JJJJMMDD for my country (BE) ====== 2019 November : Windows10 Pro Full Patched LibreOffice V6.2.5.2 (x86) Starting Calc from: the PortableApp Menu Item LibreOffice or the File Browser: RightClick on .ods>Open Date accept pattern: D-M-Y;D-M; Default Language: Nederlands (Belgie) Steps to Reproduce (2019 November): 1. cell format : category Date; layout JJJJMMDD; Language Dutch (Belgium) 2. cell input date, fe 4/11/2019 3. displays 20191104 I dont know why this is RESOLVED now: version upgrade Winodws or LibreOffice...?! This case Bug 111447, is RESOLVED and CLOSED for me.