Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||AutoFilter with a Standard Filter applied - fill down values with the fill handle across rows hidden by the filter not only fills the cells in the visible rows but also fills the cells in the hidden rows as well|
|Status:||CLOSED DUPLICATE||QA Contact:||issues@sc <issues>|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
Description vavra_milan 2011-05-12 21:10:38 UTC
AutoFilter with a Standard Filter applied - fill down values with the fill handle across rows hidden by the filter not only fills the cells in the visible rows but also fills the cells in the hidden rows as well In a table with AutoFilter and a Standard Filter applied, if you try to fill down cells with the fill handle across rows hidden by the Standard Filter, not only will the cells in the visible rows be filled, but also cells in the hidden rows will be filled. For example: Let's have the following simple table: |A|B| 1|a|b| 2|1| | 3|2| | 4|1| | 5|2| | 6|1| | Let's select it, A1:B6, and apply AutoFilter to it by selecting Data, Filter, AutoFilter from the menu. Then let's apply Standard Filter on column A to show rows that equal 2. The result will look like this: |A|B| 1|a|b| 3|2| | 5|2| | Now click B3 and enter x. |A|B| 1|a|b| 3|2|x| 5|2| | Click B3 to select it. Drag the fill handle on B3 to B5. |A|B| 1|a|b| 3|2|x| 5|2|x| Cancel the Standard Filter on column A. The result looks like this: |A|B| 1|a|b| 2|1| | 3|2|x| 4|1|x| 5|2|x| 6|1| | Notice that B4 was filled. The expected result would be: |A|B| 1|a|b| 2|1| | 3|2|x| 4|1| | 5|2|x| 6|1| | where only the cells in rows visible at the time the fill handle was used would be filled.
Comment 1 niklas.nebel 2011-05-13 12:33:43 UTC
This behavior is already changed in OOo 3.4 beta, see issue 89232 and http://blogs.oracle.com/GullFOSS/entry/changed_behavior_of_autofill_when. *** This issue has been marked as a duplicate of issue 89232 ***
Comment 2 Oliver-Rainer Wittmann 2012-06-13 12:25:30 UTC
getting rid of value "enhancement" for field "severity". For enhancement the field "issue type" shall be used.