Created attachment 80184 [details] test file standard filter If a column contains cells with date format, the standard filter hides all data rows when setting the filter criteria to Empty or Not Empty - Open attached file - Open data - filter - standard filter - Select filter criteria: One = Not Empty -> Result: All data rows are hidden - Try filter criteria: Three = Not Empty -> Result: filter works as expected
confirm reproducible on LO 4.0.4.1 (Win7 32bit)
David Ostrovsky committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=551ee32dfaaddd2aa48efebaefab0730474b656d fdo#65281 Empty/Not empty doesn't work in columns with date format 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.
David Ostrovsky committed a patch related to this issue. It has been pushed to "libreoffice-4-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=a24dafaaaa5fcb1ffed686f2608e96ae316f72c9&h=libreoffice-4-3 fdo#65281 Empty/Not empty doesn't work in columns with date format It will be available in LibreOffice 4.3.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.
David Ostrovsky committed a patch related to this issue. It has been pushed to "libreoffice-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=f1ea6f2d1ef5e40a832c3fbe2475a4ee8cc475ec&h=libreoffice-4-2 fdo#65281 Empty/Not empty doesn't work in columns with date format It will be available in LibreOffice 4.2.7. 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.
Huge props to David Ostrovsky for fixing this. :-)