Issue 84874 - Data filters imported from Excel not properly editable
Summary: Data filters imported from Excel not properly editable
Status: CLOSED DUPLICATE of issue 35579
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.3.1
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Depends on:
Reported: 2007-12-26 08:48 UTC by camillem
Modified: 2008-09-25 08:37 UTC (History)
1 user (show)

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

Custom AutoFilter in Excel (42.89 KB, image/png)
2008-02-05 03:18 UTC, ghazishahryar
no flags Details
Standard Filter in OO Calc (after reopening it in OOCalc) (57.50 KB, image/png)
2008-02-05 03:19 UTC, ghazishahryar
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description camillem 2007-12-26 08:48:17 UTC
When you open an Excel file with a data filter of the "contains" type, it works
fine but is not properly editable.
1)Create an Excel file with a data filter "Contains" someText
2)Open it in OOo : it works as expected
3)Edit the filter by choosing Standard in the drop down menu : the value is
"*someText*" and the checkbox for using wildcards is not ticked, while the value
should be ".*someText.*" and the checkbox should be ticked.

This is probably related to
Comment 1 ghazishahryar 2008-02-05 03:17:48 UTC
Here is a more descriptive set of steps to reproduce the bug  for someone like 
me who does not use Excel that often.

1. Create an Excel sheet.
2. Click on the menu item "Data", then sub-menu item "Filter", and then sub-
menu item "Auto Filter" (Data --> Filter --> Auto Filter)
3. After clicking on the "Auto Filter" you'll see drop-down lists in the first 
row for all columns in the spreadsheet
4. Each column will get its own drop-down list containing functions that you 
can use on that column
5. Click on any of the drop-down lists and then select (Custom...)
6. A dialog box will appear, where, from the first drop-down list you'll choose 
the function "contains" and then follow the steps mentioned by the
bug report's description.

Also, by "checkbox for using wildcards" (in the description) the bug reporter 
probably means the option for using Regular Expressions for searching. 
Anyways, in Windowx XP with SP2 using OO Calc 2.3.1 I also saw '*' in 
the "standard" filter on both sides of the filter string and also the Regular 
Expression checkbox was unchecked.

I am also attaching images of the custom (for Excel) filter and standard (for 
OO Calc) dialog boxes.
Comment 2 ghazishahryar 2008-02-05 03:18:52 UTC
Created attachment 51365 [details]
Custom AutoFilter in Excel
Comment 3 ghazishahryar 2008-02-05 03:19:43 UTC
Created attachment 51366 [details]
Standard Filter in OO Calc (after reopening it in OOCalc)
Comment 4 amy2008 2008-09-25 08:36:47 UTC
Duplicate to issue 35579.
Because of lacking of the corresponding operation options. In OOo, there is 
no 'contains' or 'does not cotain'.
Li Meiying

*** This issue has been marked as a duplicate of 35579 ***
Comment 5 amy2008 2008-09-25 08:37:36 UTC