Apache OpenOffice (AOO) Bugzilla – Issue 364
AutoFilter behaves strangely
Last modified: 2006-12-14 05:14:38 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.
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.
Same in Windows 2000 environment
Will continue work on this isssue asap.
changing QA contact from bugs@ to issues@
Same problem. If I make a copy/paste over a column, all fields, also the invisible, ar changend. Build 638C
*** Issue 16112 has been marked as a duplicate of this issue. ***
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.
*** Issue 11029 has been marked as a duplicate of this issue. ***
*** Issue 11102 has been marked as a duplicate of this issue. ***
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).
closed
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
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