Issue 364

Summary:	AutoFilter behaves strangely
Product:	Calc	Reporter:	issues@www <issues>
Component:	code	Assignee:	falko.tesch
Status:	CLOSED FIXED	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P4	CC:	issues
Version:	614
Target Milestone:	---
Hardware:	PC
OS:	Windows NT
Issue Type:	ENHANCEMENT	Latest Confirmation in:	---
Developer Difficulty:	---

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

closed

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.

Thanks.

Qiyao

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.

Thanks.

Qiyao