Issue 55141 - Auto Filter list option don't contain all the values
Summary: Auto Filter list option don't contain all the values
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: 680m130
Hardware: PC Windows XP
: P3 Trivial with 5 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
: 60712 83119 (view as issue list)
Depends on:
Reported: 2005-09-27 15:23 UTC by karindames
Modified: 2013-08-07 15:12 UTC (History)
3 users (show)

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

Defectlist (121.50 KB, application/vnd.sun.xml.calc)
2005-09-27 15:25 UTC, karindames
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description karindames 2005-09-27 15:23:41 UTC
On Calc enter a spreadsheet with a header row containing the field name.  
Select Data -> Filter -> Autofilter.  Once enabled click on the Status field 
(see attachment) drop down option to select only specific values.

Expected to see statuses 'Open', 'Closed' and 'Rejected' in the list.  'Open' 
is not displayed.
Comment 1 karindames 2005-09-27 15:25:16 UTC
Created attachment 29941 [details]
Comment 2 frank 2005-09-28 09:19:13 UTC

the problem is the built in autofilter range set by Excel. Currently the values
in this range do not contain a 'open' value, so there is no choice in the
autofilter. To workaround this, you have to adjust the autofilter range by
applying an autofilter in Excel and save the file again.

Daniel have a look at Data-filter-special filter in Excel to determine the

Comment 3 daniel.rentz 2006-01-31 16:32:52 UTC
*** Issue 60712 has been marked as a duplicate of this issue. ***
Comment 4 podlesh 2006-08-08 13:43:07 UTC
What is status of this bug? I see no change in almost one full year. Will
someone repair it, or a new one should be created because the bug is in excel
import filter?

This bug happen when Excel file with autofiler is imported. Saved .ods file
contains something like:

        <table:named-range table:name="Excel_BuiltIn__FilterDatabase_1"
table:base-cell-address="$List1.$A$1" table:cell-range-address="$List1.$A$1:.$C$3"/>
        <table:database-range table:name="Excel_BuiltIn__FilterDatabase_1"
Comment 5 frank 2007-10-30 14:10:54 UTC
*** Issue 83119 has been marked as a duplicate of this issue. ***
Comment 6 camillem 2010-09-06 17:43:36 UTC
I think fixing Issue 85305 (Dynamically grow a filtered range for autofilter,
standard filter, and advanced filter) would fix this one.