Issue 24036 - Autofilter fails to select entire spreadsheet contents
Summary: Autofilter fails to select entire spreadsheet contents
Status: CLOSED DUPLICATE of issue 14298
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL: http://cheap.net.au/~writer/test_filt...
Keywords:
Depends on:
Blocks:
 
Reported: 2004-01-01 16:00 UTC by belzecue
Modified: 2004-01-22 16:21 UTC (History)
1 user (show)

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

Attachments
test file showing autofilter row omission (14.61 KB, application/vnd.sun.xml.calc)
2004-01-01 16:04 UTC, belzecue 		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 belzecue 2004-01-01 16:00:07 UTC 
See linked file, which was imported from an excel original.

Notice the last row, first column contains text 'horror classes'.  Autofilter 
dropdown on first column (subject) fails to show this row.  'horror classes' 
should show in the dropdown list.

This seems to be related to Issue 14298, which I reported earlier and which 
was assigned as a duplicate of 14251.  Note that there are NO NAMED RANGES in 
this file -- the usual cause of errors of this type.  Have I overlooked 
something?  Thanks.
Comment 1 belzecue 2004-01-01 16:04:16 UTC 
Created attachment 12218 [details]
test file showing autofilter row omission
Comment 2 oc 2004-01-09 10:23:38 UTC 
This one is duplicate to 14298. If you don't agree because this task descripes
another problem, please reopen this task and add a more detailed description.

*** This issue has been marked as a duplicate of 14298 ***
Comment 3 oc 2004-01-09 10:27:33 UTC 
Closed because duplicate.
Note: to solve your problem you have to delete the databaserange (DATA-DEFINE RANGE)
Comment 4 belzecue 2004-01-22 16:21:44 UTC 
Thanks.  That fixed it.  I got confused between named ranges and data ranges, 
and was only looking at the former.