Issue 42881

Summary:	Fill Down does not work properly when the spreadsheet is filtered
Product:	Calc	Reporter:	kheekien <kheekien>
Component:	editing	Assignee:	spreadsheet <spreadsheet>
Status:	CLOSED DUPLICATE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	OOo 1.1.4
Target Milestone:	---
Hardware:	All
OS:	Windows XP
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description kheekien 2005-02-16 03:01:40 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.

Comment 1 frank 2005-02-16 10:30:02 UTC

Hi,

this is a double to Issue 33851

Frank

*** This issue has been marked as a duplicate of 33851 ***

Comment 2 frank 2005-02-16 10:30:17 UTC

closed double

Comment 3 jeffbil 2007-07-16 01:55:17 UTC

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