Created attachment 91959 [details] Autofilter on date bug Create a spredsheet document. Set the first column as "Date" format. Name the first line as "Date" for header. Then enter 3 dates, one by line. Generate an autofilter. Click on the down arrow, and.... "dummy" ? See screenshot
Created attachment 91969 [details] screenshot with correct meta file
Confirmed with Version: 4.3.0.0.alpha0+ Build ID: fb7899e2423d26710200e46f66cf85894525afec TinderBox: Win-x86@39, Branch:master, Time: 2014-01-08_04:02:07 Regression between 4.1.4 and 4.2.0.
Still there in the latest 4.2.0.3 (4.2 RC3) I hope it'll be fixed before official release :/
Bouh! This make filtering on dates unusable. Adding to MAB 4.2 Best regards.
CCing Calc devs
Bug still there in final 4.2.0.4
Bug still there in version 4.2.1.1 Build ID: d7dbbd7842e6a58b0f521599204e827654e1fb8b Linux X64 DEB
*** Bug 75009 has been marked as a duplicate of this bug. ***
We need a test document. I can't reproduce this.
Created attachment 94323 [details] test document showing the problem Here is a test document. I added a list of dates in the column A and set the autofilter. Best regards. JBF
Thanks. Hmm it still works for me. Perhaps this is French locale specific, since the dates are locale-specific.
Yup, switching LANG to fr_FR.utf-8 and it's reproducible.
I got this.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=2be2786879883badd6d0075e63965bacd312ed23 fdo#73565: Populate date members in a locale-safe way. 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.
4.2 backport: https://gerrit.libreoffice.org/8139
Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=7af1124f83df4d96f6ebe58536de7c51406df661&h=libreoffice-4-2 fdo#73565: Populate date members in a locale-safe way. It will be available in LibreOffice 4.2.3. 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.
Fixed.
(In reply to comment #17) > Fixed. Thank you very much Kohei ! Verified fixed on version 4.2.3.0.0+. :-) Do you plan a backport to 4.2.2 ? Best regards. JBF
(In reply to comment #18) > (In reply to comment #17) > > Fixed. > > Thank you very much Kohei ! > Verified fixed on version 4.2.3.0.0+. :-) > > Do you plan a backport to 4.2.2 ? > > Best regards. JBF I tried, but gerrit is not coorporating. git push origin HEAD:refs/for/libreoffice-4-2-2 Counting objects: 13, done. Delta compression using up to 8 threads. Compressing objects: 100% (7/7), done. Writing objects: 100% (7/7), 1.45 KiB, done. Total 7 (delta 6), reused 0 (delta 0) remote: Resolving deltas: 100% (6/6) remote: Processing changes: refs: 1, done remote: (W) No changes between prior commit 018244d and new commit 430b872 To ssh://logerrit/core.git ! [remote rejected] HEAD -> refs/for/libreoffice-4-2-2 (no changes made) error: failed to push some refs to 'ssh://logerrit/core.git'
And there *is* a change between the commit. Sorry I don't have time to investigate this right now. I need to move on.
Thanks Kohei, nice the new selection for dates. Verified in: Version: 4.2.3.0.0+ Build ID: 7af1124f83df4d96f6ebe58536de7c51406df661 TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-02-20_11:39:39
Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-4-2-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=8e2e2b0d2d585839e2ecf339f26336c8f653b0e6&h=libreoffice-4-2-2 fdo#73565: Populate date members in a locale-safe way. It will be available already in LibreOffice 4.2.2. 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.
*** Bug 75945 has been marked as a duplicate of this bug. ***
*** Bug 77270 has been marked as a duplicate of this bug. ***