Steps how to reproducible with "LibreOffice 3.6.1.2 German UI/Locale [Build-ID: e29a214] on German WIN7 Home Premium (64bit) 0. Launch LibO 1. New Writer Document From LibO start Center 2. Menu 'Tools -> Options -> Writer -> Table -> Input: All Number recognition checked' 3. 'Tools -> Options -> Language settings -> Language -> Locale=German' 4. Draw Table 3x3 5. For A1 select Number Format TT.MM.JJJJ (=German for DD.MM.YYYY) 6. Type "31.12." into A1 Result as expected "31.12.2012" 7. For A2 select Number Format JJJJ-MM-TT (=German for YYYY-MM-DD) 8. Type "31.12." into A2 Bug: "1931-12-01" This problem persists in Master and will not be healed with new date acceptance pattern, as you can see in Attachment 66432 [details] for Bug 52240, what also shows the bug. Modifying A1 to Numbr format JJJJ-MM-TT after input keeps correct date, so this problem is recognition related. I will check appearance version of this bug later @Eike: Although I think that this one is completely independent to date acceptance pattern, but I think you should know about this bug, because date recognition is affected.
@Rainer First: How do you "select Number Format"? To select I set the cursor to the empty cell A1 and use "Table -> Number Format... -> Category "Date" -> Format "TT.MM.JJJ" For Step 7 the same procedure - but choosing "JJJJ-MM-TT" I have observed the following: Doing step for step - as described by you - in both cells is shown 31.12.2012 after typing "31.12." OS: Windows XP
Created attachment 66439 [details] Sample Document I can't see any obvious proceeding in Jochen's proceeding, but [Reproducible] with LibO 3.5.2.2 on Ubunut 12 64 Bit (VirtualBox) With Server installation (own profile) of "LibreOffice 3.5.6.2 German UI/Locale [Build-ID: e0fbe70-5879838-a0745b0-0cd1158-638b327] on German WIN7 Home Premium (64bit) Nomber recognition or Cell formatting is broken, does not work Also broken with 3.4.5, I will check that later. Attached Sample shows my results from WIN 3.6.1 @Jochen: Your OS? OS Languge? Locale (I think German)? Document Language? LibO Version? > in both cells is shown 31.12.2012 Then you are doing something wrong, it's not plausible that with number format setting "JJJJ-MM-TT" you get "31.12.2012". Or you struggle with an other bug
@Rainer the theme is IMHO relativ relatively complex (OS, OS Languge, document language, LibO Version, formatting etc.). Misunderstandings are preprogrammed. Does it make sense to discuss per PM or ML (e.g. de-discuss-ML)?
(In reply to comment #2) > Your OS? OS Languge? Locale (I think German)? Document Language? LibO Version? OS: Windows XP OS Languge: German Locale: German Document Language: German LibO Version: 3.6.0.4 Changed status to NEW
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-4-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=3043bfc6248b15836903d6d34c0f8581eebf27e9&g=libreoffice-4-0 resolved fdo#54344 let date pattern match overrule incomplete format match It will be available in LibreOffice 4.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=8041285b369e58df477b5e92df4bde68e96056a2 resolved fdo#54344 let date pattern match overrule incomplete format match 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.
Change pending review for 3-6 as https://gerrit.libreoffice.org/1426
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-3-6": http://cgit.freedesktop.org/libreoffice/core/commit/?id=c796f58d6ea3999268333f6cff687ee517882717&g=libreoffice-3-6 resolved fdo#54344 let date pattern match overrule incomplete format match It will be available in LibreOffice 3.6.5. 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.