Problem description: LibreOffice Calc is no longer recognizing the date formats separated by "/" anymore. I've checked the 3.5.x series and i figured that the following formats are no longer exists in LibreOffice's current release: dd/mm/yy dd/mm/yy dd/mm/yyyy dd/mm/yyyy dd/mmm/yyy dd/mm/yy dd/mm/yyyy hh:mm:ss I know i wrote them duplicates, because i've copied from LO 3.5's Date Formats section. I've checked this issue and there is not a certain rule however, the spellguide refers three common used date seperators: "." and "/" and "-" Could you please arrange the Turkish dae formats for the use of these three seperators. And also is it possible to change the behaviour of the unformatted cell to response date entries as DD.MM.YYYY instead of the current output DD.MM.YY? Best regards, Zeki Operating System: All
Taking over.
I assume that this > dd/mmm/yyy should be dd/mmm/yyyy instead (4-digit year). > "." and "/" and "-" > > Could you please arrange the Turkish dae formats for the use of these three > seperators. Adding <DateAcceptancePattern>D.M</DateAcceptancePattern> <DateAcceptancePattern>D/M</DateAcceptancePattern> <DateAcceptancePattern>D/M/Y</DateAcceptancePattern> <DateAcceptancePattern>D-M</DateAcceptancePattern> <DateAcceptancePattern>D-M-Y</DateAcceptancePattern> to the default D.M.Y pattern. > And also is it possible to change the behaviour of the > unformatted cell to response date entries as DD.MM.YYYY instead of the > current output DD.MM.YY? Sure, no problem.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=c506650b21c628e603ce7dc3dc30238c480342d2 resolved fdo#57668 additional date formats using '/' separator 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.
Patch is pending review for 3-6
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=bc19a37be6a6c8538d8a7b07adedd754db17f1df&g=libreoffice-3-6 resolved fdo#57668 additional date formats using '/' separator 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.
(In reply to comment #5) > Eike Rathke committed a patch related to this issue. > It will be available in LibreOffice 3.6.5. Eike, thank you very much for your great help. > The patch should be included in the daily builds available at > http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More I will test it from the daily builds. Btw, is there any chance to include it to the upcoming 3.6.4 release :[ Best regards, Zeki
I doubt there will be another 3.6.4 RC.