Bug 65281 - standard filter: Empty/Not empty does not work in columns with date format
Summary: standard filter: Empty/Not empty does not work in columns with date format
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.3.3 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: target:4.4.0 target:4.3.3 target:4.2.7
Keywords:
Depends on:
Blocks:
 
Reported: 2013-06-03 07:02 UTC by Jacqueline Rahemipour
Modified: 2014-09-23 23:07 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
test file standard filter (8.82 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-06-03 07:02 UTC, Jacqueline Rahemipour
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Jacqueline Rahemipour 2013-06-03 07:02:59 UTC
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
Comment 1 ign_christian 2013-06-07 17:00:21 UTC
confirm reproducible on LO 4.0.4.1 (Win7 32bit)
Comment 2 Commit Notification 2014-09-23 22:55:24 UTC
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.
Comment 3 Commit Notification 2014-09-23 23:03:22 UTC
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.
Comment 4 Commit Notification 2014-09-23 23:06:25 UTC
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.
Comment 5 Kohei Yoshida 2014-09-23 23:07:18 UTC
Huge props to David Ostrovsky for fixing this. :-)