Summary: | Autofilter on date creates a "dummy" thing instead of date list | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Frederic Mestayer <dricks2222> |
Component: | Calc | Assignee: | Kohei Yoshida <kohei> |
Status: | RESOLVED FIXED | ||
Severity: | critical | CC: | erack, folibof, gerard.fargeot, gibi, iplaw67, jbfaure, kyoshida, markus.mohrhard, miguelangelrv, rebollo.h |
Priority: | highest | Keywords: | regression |
Version: | 4.2.0.3 rc | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | target:4.3.0 target:4.2.2 | ||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 65675 | ||
Attachments: |
Autofilter on date bug
screenshot with correct meta file test document showing the problem |
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. *** |
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