Issue 21915 - Changing column descriptions with AutoFilter active will change ALL columns starting from 1st value
Summary: Changing column descriptions with AutoFilter active will change ALL columns s...
Status: CLOSED DUPLICATE of issue 2977
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1
Hardware: PC Windows 98
: P2 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
Depends on:
Reported: 2003-10-30 16:26 UTC by Unknown
Modified: 2003-10-31 08:14 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2003-10-30 16:26:16 UTC
For me, this is really a CRITICAL issue because it can screw up your whole 

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 

 ...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 

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.

Comment 1 Joost Andrae 2003-10-30 19:24:51 UTC
JA: autofilter just hides the other cells but they're selected for the
Comment 2 Unknown 2003-10-30 19:41:39 UTC
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.

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

this is a double to Issue 2977.


*** This issue has been marked as a duplicate of 2977 ***
Comment 4 frank 2003-10-31 08:14:18 UTC
closed double