Apache OpenOffice (AOO) Bugzilla – Issue 55141
Auto Filter list option don't contain all the values
Last modified: 2013-08-07 15:12:27 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.
Created attachment 29941 [details] Defectlist
Hi, 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 filterrange. Frank
*** Issue 60712 has been marked as a duplicate of this issue. ***
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-expressions> <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:named-expressions> <table:database-ranges> <table:database-range table:name="Excel_BuiltIn__FilterDatabase_1" table:target-range-address="List1.A1:List1.C3"/> </table:database-ranges>
*** Issue 83119 has been marked as a duplicate of this issue. ***
I think fixing Issue 85305 (Dynamically grow a filtered range for autofilter, standard filter, and advanced filter) would fix this one.