Issue 119020 - Autofilter doesn't work after cells with date values were changed
Summary: Autofilter doesn't work after cells with date values were changed
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.3
Hardware: PC Windows XP
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2012-03-05 01:06 UTC by nelsondfm
Modified: 2017-05-20 09:58 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description nelsondfm 2012-03-05 01:06:29 UTC 
error 87753.

I am sending a file in which the autofilter for dates (the first column in the file) didn't work properly, the original file was created in Excel 2003 and modified several times in excell 2007.  After modified the date format in some cells, the filter started working properly.  I tried it filtering rows for date=29-jan-2012 or other, what it did was showing the date I chose, and after.

Thank you for a great suite that works for free, It is no easy to gain the people confidence in working with OpenOffice I am working in it, but this sort of errors could make the people biased in favor of  returning to MSOffice.
Comment 1 binguo 2012-09-14 06:03:17 UTC 
Verified on Aoo_Trunk_20120912.1800, unfortunately, I did not repro this bug, so could you please follow the steps on latest build on your side to see if it still occurs? thank you. or would you please attach sample file to this bug?
Comment 2 Rob Weir 2013-04-03 00:19:19 UTC 
No response to our request for additional information from issue reporter.  We cannot reproduce the bug.