Issue 96442 - Remove Filter Failure
Summary: Remove Filter Failure
Status: CLOSED DUPLICATE of issue 93091
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOO300m9
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: niklas.nebel
QA Contact: issues@sc
URL:
Keywords: needmoreinfo, oooqa, regression
Depends on: 93091
Blocks:
  Show dependency tree
 
Reported: 2008-11-21 22:59 UTC by benjohn
Modified: 2013-08-07 15:14 UTC (History)
4 users (show)

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

Attachments
Original Sheet (6.77 KB, text/plain)
2008-11-21 23:01 UTC, benjohn 		no flags Details
Filter for "x" in column A (6.73 KB, text/plain)
2008-11-21 23:02 UTC, benjohn 		no flags Details
Data - Filter - Remove Filter (6.68 KB, text/plain)
2008-11-21 23:03 UTC, benjohn 		no flags Details
A patch about issue 96442. (660 bytes, text/plain)
2009-02-23 08:47 UTC, gaozm 		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 benjohn 2008-11-21 23:00:01 UTC 
When data in a column is filtered on a value, it is properly displayed.

When REMOVE filter is applied, only the filtered data is displayed and the the 
original unfiltered data is not.
file:///C:/Users/John/Desktop/Unfiltered.ods
file:///C:/Users/John/Desktop/Filter%20X.ods
file:///C:/Users/John/Desktop/Remove%20Filter%20X.ods
Comment 1 benjohn 2008-11-21 23:01:13 UTC 
Created attachment 58209 [details]
Original Sheet
Comment 2 benjohn 2008-11-21 23:02:05 UTC 
Created attachment 58210 [details]
Filter for "x" in column A
Comment 3 benjohn 2008-11-21 23:03:34 UTC 
Created attachment 58211 [details]
Data - Filter - Remove Filter
Comment 4 Rainer Bielefeld 2008-11-22 10:19:44 UTC 
I checked with "Ooo 3.0.0 RC3 Multilingual version German UI WIN XP: [OOO300m8
(Build9357)]" and can confirm the reported effect. 

The problem is caused by the empty cells in the filter range. If you fill them
with some character or number, all will work as expected.

That works fine with 2.4.1, so regression.

The problem reported here seems to have the same roots (or even is a DUP?) as 
Issue 93091

@benjohn:
You filtered by simply marking 'A1:A8' and then you entered your filter criteria
for a standard filter?
Comment 5 Rainer Bielefeld 2008-11-22 12:36:33 UTC 
And NEW, of course!
Comment 6 benjohn 2008-11-22 17:51:06 UTC 
I selected the column, so I'm not sure what exact range Calc selected. Then with
the user interface Data - Filter - Standard Filter and put in my criteria.

To return to original data via user interface Data - Filter - Remove and did not
get back to original sheet.

I uninstalled 3.0 and reloaded 2.4 and accessed the same file and the filter
function worked as expected so in this case the spreadsheet was not corrupted by
its visit to 3.0
Comment 7 Regina Henschel 2008-11-22 18:43:36 UTC 
Please try this:
Mark column, which was used for filter
Format > Row > Show
Comment 8 gaozm 2009-02-23 08:47:28 UTC 
Created attachment 60375 [details]
A patch about issue 96442.
Comment 9 oc 2009-09-22 13:20:42 UTC 
Hi Niklas, please have a look
Comment 10 niklas.nebel 2009-10-14 17:04:30 UTC 
adjusting target
Comment 11 niklas.nebel 2010-07-30 11:53:54 UTC 
This is in fact the same as issue 93091, already fixed in 3.2.

*** This issue has been marked as a duplicate of 93091 ***
Comment 12 niklas.nebel 2010-07-30 11:54:39 UTC 
closing duplicate