Description: This bug concerns dates copied into calc with de-AT (de_AT.UTF-8) (Austrian) localization. In Austria people speak German, but with some variations. One is the word for january, which translates to "Jänner" OR "Januar". I can copy a date like "12. Jänner 2018" into calc an it is recognized as a date. But if I copy an equally often used date like "12. Januar 2018", it is NOT recognized as a date, but as text. Both "Jänner" and "Januar" are used in Austria and should therefore be handled as dates. This might be necessary for the German localization too, since some southern parts of Germany use the word "Jänner" too. Steps to Reproduce: 1.Format a cell to date-format 2.Copy a text like "12. Januar 2018" into this cell Actual Results: The cell will show the copied text as "text". Expected Results: The cell should turn the text into a date, like it does with a text like "12. Jänner 2018". Reproducible: Always User Profile Reset: No Additional Info: This problem might occur in the German localization too, just the other way around (recognizing "Januar" but not "Jänner"). Version: 5.4.2.2 Build-ID: 1:5.4.2-0ubuntu0.17.10.1 CPU-Threads: 8; Betriebssystem:Linux 4.13; UI-Render: Standard; VCL: kde4; Gebietsschema: de-AT (de_AT.UTF-8); Calc: CL User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.97 Safari/537.36 Vivaldi/1.94.1008.40
You can set the language in a number format. Set "German (Austria)" for detecting "Jänner" and "German (German)" for detecting "Januar". Detecting numbers and dates without language information makes no sense.
(In reply to Regina Henschel from comment #1) > You can set the language in a number format. Set "German (Austria)" for > detecting "Jänner" and "German (German)" for detecting "Januar". Detecting > numbers and dates without language information makes no sense. Thank you, that is actually very useful as a workaround for the problem I have right now, even though it doesn't solve the problem of working with mixed sources. In some cases "Januar" and "Jänner" are mixed together, depending on what the people filling out the forms use. The problem is, that both terms, "Januar" and "Jänner" are equally valid in the German language (de and at). Right now I have to treat the cells as text and create the date with additional formulas.
Januar and Jänner should be both detected as number format in all German languages. In mixed environments this would avoid problems. Duden [1] says that Jänner also in Germany and Switzerland can be used in some regions. And as stated by the bug opener, Januar is equally used as Jänner in Austria in written form. My Österreichisches Wörterbuch says that Januar is also possible in Austria. Therefore the differentiation is useless. [1] https://www.duden.de/rechtschreibung/Jaenner
Dear Nickson Thanda, This bug has been in ASSIGNED status for more than 3 months without any activity. Resetting it to NEW. Please assigned it back to yourself if you're still working on this.
@Eike, I thought you could be interested in this issue...
We don't have alternative month names in locale data nor supported in number scanner; this may be a valid request, someone would have to implement the feature. Other than that, it could be brutally hacked in for German locales.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=5043cf9b5a4bfa93e1a88f81b931a13b7931bfd5 Resolves: tdf#114927 recognize both Januar and Jänner in de-* German locales It will be available in 6.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=0f1ae0debdcb0d3e80651873b09ad23dfaa90123 Unit test for de-* Januar/Jänner, tdf#114927 It will be available in 6.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Verified. Thank you very much, Eike! Version: 6.2.0.0.alpha1+ (x64) Build ID: ae9f37ba753519ae4a2ae6384d052d417359602f CPU threads: 8; OS: Windows 10.0; UI render: GL; VCL: win; TinderBox: Win-x86_64@42, Branch:master, Time: 2018-10-23_02:03:22 Locale: de-AT (de_AT); Calc: CL