Created attachment 117605 [details] Sample file to reproduce the issue. For cells with Spanish cell format, from a validation list: lun 03/08/2015 -> 03/08/15 (is recognized as date) mar 04/08/2015 -> mar 04/08/2015 (not is recognized as date) mié 05/08/2015 -> 05/08/15 (is recognized as date) The issues is inherited, reproducible with AOo 4.1.1 It doesn't happen with English(US)(UK), French (FR).
Confirmed with LO 4.4.4. Note that long date "martes 04/08/2015" is recognized as date.
Thanks for the clarification, I forgot to do it.
On pc Debian x86-64 with master sources updated yesterday, I could reproduce this. I took a look to i18npool/source/localedata/data/es_ES.xml (see http://opengrok.libreoffice.org/xref/core/i18npool/source/localedata/data/es_ES.xml) I wonder if the pb could be due to the fact that "mar" may also be interpreted as the month March ("Marzo"). I suppose there's a link with i18npool/source/localedata/LocaleNode.cxx and generateCode. Digging a bit, I found this: http://opengrok.libreoffice.org/xref/core/svl/source/numbers/zforfind.cxx#1487 I must keep on digging.
Thanks Julien, following your comment, thinking if it can be in other languages, I have tested in Galicia "martes" "marzo", Italian "Martedì" "Marzo" happens the same. Maybe the same issue with other languages where the first three letters are equal for weekday and month name. Perhaps one way could be testing weekday if month test fails.
Eike: digging in svl/source/numbers/zforfind.cxx is quite difficult. Would you have some idea? (see previous comments for the rare already findings)
Yes, I have an idea ;-) "mar" abbreviation for "martes" is the same string as "mar" abbreviation for "marzo" and apparently takes precedence, which it should not.
I'll fix this.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=c7d66949beecab92dc8f1380c54751710aa0b7a2 Resolves: tdf#93080 short day name and month name may interfere It will be available in 5.1.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=b02f792f23e6d5872de1f2f5abd0151a89751c43 unit test for short name ambiguity, tdf#93080 It will be available in 5.1.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.
Pending review https://gerrit.libreoffice.org/17545 for 5-0 https://gerrit.libreoffice.org/17546 for 4-0
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=c978ce3b0774912ec0979b6cfec02927d8837a3e&h=libreoffice-5-0 Resolves: tdf#93080 short day name and month name may interfere It will be available in 5.0.1. 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 "libreoffice-4-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=28b7e6f0acfa5e8cc3a08218584eeb71e4b313a3&h=libreoffice-4-4 Resolves: tdf#93080 short day name and month name may interfere It will be available in 4.4.6. 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.
On pc Debian x86-64 with master sources updated today, I don't reproduce this. Thank you Eike!