Issue 364 - AutoFilter behaves strangely
Summary: AutoFilter behaves strangely
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: 614
Hardware: PC Windows NT
: P4 Trivial with 3 votes (vote)
Target Milestone: ---
Assignee: falko.tesch
QA Contact: issues@sc
: 11029 11102 16112 (view as issue list)
Depends on:
Reported: 2001-02-02 12:45 UTC by issues@www
Modified: 2006-12-14 05:14 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description issues@www 2001-02-02 12:45:40 UTC
A table with n different columns and m different rows is entered. The first row
acts as heading and is formatted as text. All the rest of the respective columns
is formatted as text, date, something, respectively. At some intermediate stage
AutoFilter is activated.

Later the filter for column x is applied. Afterwards the filter choice of the
column y is opened. All values are displayed not just the ones visible in the
current filtered situation (according to filter for column x). But the  choice
of "all" doesn't change anything, the choice of an unvisible value results in an
empty table. The full table can be recovered by setting the filter to all in
column y first, followed by setting to all in column x. In general to recover
the whole table the all-filter has to be applied exactly in reversed order the
excluding filters were applied.

An email with an example follows.
Comment 1 oc 2001-02-26 13:34:07 UTC
The choice of "all" as a filter criterion affects only the chosen criterion and 
not the whole Autofilter. You could see which filter is applied on the 
filtericon (black arrow: no filter applied, blue arrow: filter applied).
The fact that if you apply a filter on one column you could see all entries on 
another column is a request for enhancement.
Comment 2 issues@www 2001-04-06 14:26:14 UTC
Same in Windows 2000 environment
Comment 3 falko.tesch 2001-04-09 15:13:54 UTC
Will continue work on this isssue asap.
Comment 4 Unknown 2001-11-08 23:05:44 UTC
changing QA contact from bugs@ to issues@
Comment 5 Unknown 2001-11-13 13:17:15 UTC
Same problem. If I make a copy/paste over a column, all fields, also 
the invisible, ar changend. Build 638C
Comment 6 oc 2003-06-26 13:25:52 UTC
*** Issue 16112 has been marked as a duplicate of this issue. ***
Comment 7 Unknown 2003-06-27 04:22:16 UTC
This is for information of Wolfgang Praskac, that doing copy paste in 
the filtered range is not a good thing to do, because you would 
incidently replace the cells which you do not want to. 
I do it in two steps, I copy-paste on the top cell of the filtered 
range (as a single-cell-paste), then I select the whole cell-range 
down wards, Then I Press F2-Funtion-key, then I do Ctrl+Enter.
Comment 8 frank 2003-08-13 16:02:31 UTC
*** Issue 11029 has been marked as a duplicate of this issue. ***
Comment 9 frank 2003-08-14 15:58:56 UTC
*** Issue 11102 has been marked as a duplicate of this issue. ***
Comment 10 falko.tesch 2003-10-15 14:23:37 UTC
Our behaviour is technically corret. Nevertheless we found that many
users thought different.
Therefroe we now throw an error message before pasting (and
overwriting existing data).
Comment 11 falko.tesch 2003-10-15 14:24:01 UTC
Comment 12 zhongqiyao 2006-12-12 08:43:36 UTC
OpenOffice 2.0.4, Chinese (Traditional characters).
Windows XP Home SP2, Chinese (Traditional characters).

1. If you say this is technical correct, could you compare with the
   "Backspace" or "Delete" action?

2. Do row filtering, so that only row 2 and 4 are visible.

3. For any column,
   At row 2, drag the lower right corner to row 4 so that it will copy
   the content of row 2 to row 4.  Now row 3 is also affected.

4. ALTERNATIVELY, for any column,
   At row 2, do "copy". Then highlight both row 2 and
   row 4 and do "paste".  Now row 3 is also affected.

5. HOWEVER, For any column,
   If you select row 2 and row 4, and do either "backspace" or 
   "delete", it will not delete row 3.  (Same as Microsoft Office.)

6. Therefore, I personally think that if "5" is correct, then "2"
   and "4" are wrong.


Comment 13 zhongqiyao 2006-12-14 05:14:38 UTC
I would also like to comment that showing a warning when the
user wants to paste does not really work, because:

1. The user may overwrite an empty cell.

2. The user may think that the paste is on non-empty cells
visible in the filter.