Issue 114942 - autofilter does not show cells with the date range 1sep-12sep of any year
Summary: autofilter does not show cells with the date range 1sep-12sep of any year
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.2.1
Hardware: Unknown All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-10-05 17:02 UTC by gigahz
Modified: 2013-12-12 17:12 UTC (History)
2 users (show)

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

Attachments
a spreadsheet showing the error (7.41 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-10-05 17:05 UTC, gigahz 		no flags Details
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 gigahz 2010-10-05 17:02:52 UTC 
Yes, I know it sounds strange. 

Autofilter does not show cells with the date range 1sep-12sep of any year.

To reproduce: 
1 create two columns, one with some text and one with the date 25 august some
year. Now drag the date field down to create dates past 15 september the same year.

2 Apply autofilter and try and select a date. You will be able to select 1
september, but nothing is shown in the list (the whole autofiltered list is hidden)

3 If you select some date before 1 sep or after 12 sep, the corresponding lines
are shown.

Expected results: The corresponding line should be shown.
Comment 1 gigahz 2010-10-05 17:05:24 UTC 
Created attachment 71960 [details]
a spreadsheet showing the error
Comment 2 gigahz 2010-10-05 17:29:14 UTC 
I haven't checked if other date ranges display similar behaviour.
Comment 3 gigahz 2010-10-05 17:41:32 UTC 
OK after some trial and error I've found that this bug depends on the LANGUAGE
of the cells (Format | Number | Language): 

If the Language is set to "English (USA)" then all is OK, you can apply whatever
format you want and the dates are selected as they should be.

However, if you select whatever other language it fails to display the date
ranges mentioned above. (well I tried with "English (Great Britan)", "Norwegian
Bokmål" and "Spanish (Spain)").

Maybe this helps the coders? :)
Comment 4 Edwin Sharp 2013-12-12 17:12:23 UTC 
Confirmed with
AOO410m1(Build:9750)  -  Rev. 1543812
Rev.1543812
Win 7