| Summary: | In the Austrian localization of Calc the German word "Januar" isn't recognized as a date. | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | ingo |
| Component: | Localization | Assignee: | Eike Rathke <erack> |
| Status: | VERIFIED FIXED | ||
| Severity: | enhancement | CC: | erack, rb.henschel, thomas.lendo, xiscofauli |
| Priority: | medium | ||
| Version: | Inherited From OOo | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | target:6.2.0 | ||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 107575 | ||
|
Description
ingo
2018-01-09 11:51:23 UTC
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 |