Apache OpenOffice (AOO) Bugzilla – Issue 21915
Changing column descriptions with AutoFilter active will change ALL columns starting from 1st value
Last modified: 2003-10-31 08:14:18 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-
JA: autofilter just hides the other cells but they're selected for the autofill
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-
Hi Andreas, this is a double to Issue 2977. Frank *** This issue has been marked as a duplicate of 2977 ***
closed double