[Libreoffice-bugs] [Bug 106214] Filtering on date columns doesn't work with autofilter
https://bugs.documentfoundation.org/show_bug.cgi?id=106214 Markus Mohrhardchanged: What|Removed |Added Status|NEW |ASSIGNED Assignee|libreoffice-b...@lists.free |markus.mohrhard@googlemail. |desktop.org |com -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 106214] Filtering on date columns doesn't work with autofilter
https://bugs.documentfoundation.org/show_bug.cgi?id=106214 --- Comment #11 from stefan_lange...@t-online.de--- With my Comment 9 I was wrong: When the date is formated as date + time, the filter works. But in this case not the date autofilter with year-month-day is shown, but the "normal" text autofilter. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 106214] Filtering on date columns doesn't work with autofilter
https://bugs.documentfoundation.org/show_bug.cgi?id=106214 --- Comment #10 from Chris Jackson--- I have the same problem and have discovered that it appears to be a mismatch between the date format used in the Autofilter and the format you use in the date column of your spreadsheet. This bug has been introduced in version 5.2.6, it was working fine before. I found this out - and in the process found a temporary workaround - by selecting 'Standard filter...' from the dropdown box created by Autofilter on the date column I want to filter on. The dates in this column of my spreadsheet are in DD/MM/YY format e.g. 19/03/17 However, when I click on 'Standard filter...' option, the resulting dialogue box displays 3 fields across the top - Field Name, Condition and Value. The 'Value' field contains the date in -MM-DD format e.g. 2017-03-19. When I select the date from this field, the autofilter works and displays all dates containing 19/03/17. So - in my case anyway - the autofilter is using -MM-DD date format, whilst my date values in the spreadsheet are in DD/MM/YY format; hence there is a mismatch and that is why the autofilter is not working. To get round this, you can either use the Standard filter function as described above, or you can reformat your date column into -MM-DD format (or whichever format is being used in your Standard filter option) and then use Autofilter as normal. Not ideal, but it's a workaround. It's a bug that definitely needs fixing. I've tried altering language and date settings in Preferences but to no avail. Hope this helps. Chris -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 106214] Filtering on date columns doesn't work with autofilter
https://bugs.documentfoundation.org/show_bug.cgi?id=106214 --- Comment #9 from stefan_lange...@t-online.de--- Created attachment 131914 --> https://bugs.documentfoundation.org/attachment.cgi?id=131914=edit extended spreadsheet to demostrate the result of my test I have made a new test with several formats of the date cells. To demonstrate the results, I have attached the document "test-case+Datum.ods" (= modified file "test-case.ods"). - When date cells are formatted without time, the autofilter delivers no results. This is not influenced by the date format --> Columns C + D in the attached document - When date cells are formatted with time, the autofilter works properly. This is not influenced by the date format - also when a user defined format is used. --> Columns E + F (user defined format) in the attached document -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 106214] Filtering on date columns doesn't work with autofilter
https://bugs.documentfoundation.org/show_bug.cgi?id=106214 --- Comment #8 from stefan_lange...@t-online.de--- Hi, is anybody looking for this problem? It would be good if it could be solved at least in the next version LO 5.3.2. If it is too hard to find the reason and to solve the problem, I think one should think about to retire the patch for Bug 105629. IMHO it is more serious if filter on date columns doesn't work as if filter on time values doesn't work. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 106214] Filtering on date columns doesn't work with autofilter
https://bugs.documentfoundation.org/show_bug.cgi?id=106214 Xisco FaulĂchanged: What|Removed |Added CC||mar...@studiostorti.com --- Comment #7 from Xisco FaulĂ --- *** Bug 106481 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 106214] Filtering on date columns doesn't work with autofilter
https://bugs.documentfoundation.org/show_bug.cgi?id=106214 Aron Budeachanged: What|Removed |Added Summary|Autofilter Fails to Select |Filtering on date columns |Entries |doesn't work with ||autofilter -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs