Apache OpenOffice (AOO) Bugzilla – Issue 42881
Fill Down does not work properly when the spreadsheet is filtered
Last modified: 2007-07-16 01:55:18 UTC
When a spreadsheet is filtered (Data->Filter->Autofilter), lets say that there are 3 columns, with headers named as "Bug Description(BU)", "Severity (S)" and "Assigned To (A)", and you have the following rows: BU S A ============== ====== ======= Bug Desc 1 Moderate Bug Desc 2 Moderate Bug Desc 3 Moderate Bug Desc 4 Moderate Bug Desc 5 Minor Bug Desc 6 Minor Bug Desc 7 Minor Bug Desc 8 Moderate Bug Desc 9 Moderate When I filter the list by Severity, by moderate, naturally I will get BU S A ============== ====== ======= Bug Desc 1 Moderate Bug Desc 2 Moderate Bug Desc 3 Moderate Bug Desc 4 Moderate Bug Desc 8 Moderate Bug Desc 9 Moderate Say, when I try to assigned the issue to Peter for example, go to the cell marked "X" and try to fill down "Peter" to the rest of the rows for moderate as in the following example: BU S A ============== ====== ======= Bug Desc 1 Moderate Peter Bug Desc 2 Moderate Bug Desc 3 Moderate Bug Desc 4 Moderate Bug Desc 8 Moderate Bug Desc 9 Moderate X I get this: BU S A ============== ====== ======= Bug Desc 1 Moderate Peter Bug Desc 2 Moderate Peter Bug Desc 3 Moderate Peter Bug Desc 4 Moderate Peter Bug Desc 8 Moderate Peter Bug Desc 9 Moderate Peter which seems to be correct. But on removing the filter I get the following: (Behaviour A) BU S A ============== ====== ======= Bug Desc 1 Moderate Peter Bug Desc 2 Moderate Peter Bug Desc 3 Moderate Peter Bug Desc 4 Moderate Peter Bug Desc 5 Minor Peter Bug Desc 6 Minor Peter Bug Desc 7 Minor Peter Bug Desc 8 Moderate Peter Bug Desc 9 Moderate Peter instead of this: (Behaviour B) BU S A ============== ====== ======= Bug Desc 1 Moderate Peter Bug Desc 2 Moderate Peter Bug Desc 3 Moderate Peter Bug Desc 4 Moderate Peter Bug Desc 5 Minor Bug Desc 6 Minor Bug Desc 7 Minor Bug Desc 8 Moderate Peter Bug Desc 9 Moderate Peter which should be the correct behaviour.
Hi, this is a double to Issue 33851 Frank *** This issue has been marked as a duplicate of 33851 ***
closed double
Simple to recreate. Make the following 3 row by 2 column spreadsheet A 1 B 1 A 1 Auto Filter the first column then filter on the letter A will now have A 1 A 1 Click on the number 1 and change it to the number 9. Click on the number 1 in row 2 while holding the shift button down. Now enter fill down Should now have A 9 A 9 Now Filter All and should have A 9 B 1 A 9 BUT Instead the middle row is incorrect and get A 9 B 9 A 9