Issue 81038 - Autofilter paste function
Summary: Autofilter paste function
Status: CLOSED DUPLICATE of issue 33851
Alias: None
Product: Calc
Classification: Application
Component: printing (show other issues)
Version: OOo 2.2.1
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2007-08-26 17:19 UTC by werepants
Modified: 2007-08-26 23:25 UTC (History)
2 users (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description werepants 2007-08-26 17:19:01 UTC 
When the autofilter is applied to a spreadsheet, and a certain designation is
selected, it is very difficult to overwrite just the specific range selected.

For instance, if there is a spreadsheet full of 1, 2, 3, 4, and 5 in a given
column, and you select only rows containing a 2 by using autofilter, it does not
then allow you to copy and paste and make all the 2s into 8s.  If you do, any of
the rows between the rows containing 2 will be overwritten with 8s, even though
they aren't displayed or selected because of autofilter.

Ideal behavior would be that a row hidden by autofilter would not be editable. 
It is unintuitive that a selection in autofilter includes all hidden rows
in-between autofilter selections.
Comment 1 Regina Henschel 2007-08-26 23:25:09 UTC 
Duplicate to issue 33851. For discussion use
http://wiki.services.openoffice.org/wiki/Calc/Drafts/Issue_33851.



*** This issue has been marked as a duplicate of 33851 ***
Comment 2 Regina Henschel 2007-08-26 23:25:40 UTC 
closing duplicate