Issue 21915

Summary:	Changing column descriptions with AutoFilter active will change ALL columns starting from 1st value
Product:	Calc	Reporter:	Unknown <non-migrated>
Component:	ui	Assignee:	oc
Status:	CLOSED DUPLICATE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P2	CC:	issues
Version:	OOo 1.1
Target Milestone:	---
Hardware:	PC
OS:	Windows 98
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description Unknown 2003-10-30 16:26:16 UTC

For me, this is really a CRITICAL issue because it can screw up your whole 
sheet.

Reproduction of the issue:

- have a sheet ready with >=3 columns and lots of different values (there need 
to be some dupes though!)

- click the square on the upper left and select 

 Data->AutoFilter
 ...this will affect ALL columns!

- filter according to a certain value, make sure that the values are 
alphanumerical and that number of results is greater than 1

- CHANGE the first value, REMEMBER the row number on the top and use AutoFill 
to copy the value to ALL the other cells beneath the first value in the same 
column.

Expected: AutoFill should only affect the cells matched by the filter.
Actual: AutoFill will affect ALL (!!) cells in the current work column starting 
from the first row number you remembered!
This will result in the value being copied to all cells <= 32000.

This is a serious thing.
If you're using this more frequently, make sure to BACKUP your sheets in time, 
considering that the Undo buffer can't always do magic.

-AE-

Comment 1 Joost Andrae 2003-10-30 19:24:51 UTC

JA: autofilter just hides the other cells but they're selected for the
autofill

Comment 2 Unknown 2003-10-30 19:41:39 UTC

Odd.
Hmm ... I believe this to work in MS Excel.
It took me about 1 hour to repair this document (even though I had a 
backup, otherwise it would have taken much more than that).

Should be in, but of course I accept more negative (or positive?) 
comments about this issue and the do's and do-not's.

The only (and very strenuous) way out of this is write down (!) the 
cells you want to have changed, and use the Find->Replace command. 
But I don't want to do this.
Beat me, but this is a criteria to switch to MS Excel, at least 
sometimes. I've needed this feature uncountable times already.

-AE-

Comment 3 frank 2003-10-31 08:13:58 UTC

Hi Andreas,

this is a double to Issue 2977.

Frank

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

Comment 4 frank 2003-10-31 08:14:18 UTC

closed double