See http://ask.libreoffice.org/en/question/52851/in-calc-when-i-auto-filter-date-june-all-june-plus-6th-of-all-other-months-appear-why/?answer=53206#post-id-53206 Load its attachment http://ask.libreoffice.org/upfiles/1436972506793222.ods Autofilter on EDate June works in an en-AU locale, but not in an en-US locale (months smaller than June are displayed as well). Dates are formatted with an en-AU locale (English (Australia)).
Created attachment 117283 [details] Bug details Reproduced under 4.2.8.2 and 5.1.0.0.alpha1+ (home baked). See that the filter selects all dates that have day 6 or 7 (as if it was mistaken for the month field, these selections are not random) and all dates that have month 6 or 7.
confirmed in comment 1, setting as new
Error happens when Locale use M/D and cell is formatted with D/M. (or vice-versa) When both cell formatting and cell format use the same Month/Day order, there is no problem. Filtering on June is correct with French locale. (As both French and Autralian use D/M)
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=3e17ed1fc2845da5a279d21ffa3ea51d637e515e Resolves: tdf#92767 use ISO 8601 for internal date string representation 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/17172 for 5-0 https://gerrit.libreoffice.org/17173 for 4-0
Not sure if this is useful: I can confirm the bug fix.
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=9519a22cdffbd2bd69ce3dd0f264b80b357c8409&h=libreoffice-4-4 Resolves: tdf#92767 use ISO 8601 for internal date string representation 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.
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=5b0c58818bcbe921075052b2dd11000edfade28b&h=libreoffice-5-0 Resolves: tdf#92767 use ISO 8601 for internal date string representation 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.
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/14d064cee7b76e8a2a2201d4da423336f68fe624 tdf#92767: sc: Add UItest It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.