Copying the filtered data to clipboard is copying non-visible rows

[SeethaRaman]

I am trying to filter some data in Excel 2007 using autofilters and copy the
result set data to clipboard using ctrl + C and paste it on a separate work
book using ctrl + V. However, it is copying all the filtered rows data also
instead of only the visible rows.

This is not the desired behavior. Is there a way to achieve this as is done
in Excel 2003.

SeethaRaman

 

[Nick Hodge]

SeethaRaman

Sorry, can't replicate...works fine here, both with standard filters and
table ones. In fact they work the same

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[SeethaRaman]

I am able to consistantly repro this. I am not sure what I am missing here. I
have an excel spread sheet in Excel 2007 Beta with some 500 rows and 8
columns. All the 8 columns have autofilter set. I apply different filters on
couple of columns and select the first column values using ctrl + C and paste
it another spread sheet. I am getting all the rows instead of the filtered
values only.

Please let me know how I can repro this to you.

SeethaRaman

 

[Nick Hodge]

SeethaRaman

Couple of things I've not tried is multiple filters and copying one column.
I take a look and get back

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[Nick Hodge]

SeethaRaman

I have now tried this with more rows and multiple filters (5 rows filtered).
I have tried selecting entire columns, just the used data in a column, the
entire filtered data set (and the row below), the entire sheet and in each
occasion the data copied (ctrl+c) and pasted on a new sheet (ctrl+v) was
just the filtered list

Is this a new file or a previous version one? If it's updated could you try
this with a new 2007 workbook?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[SeethaRaman]

Sorry for getting back to you this late.
The earlier one was an updated Excel sheet from Excel 2003 and opened in
Compatibility mode with Excel 2007.

I have created a new work book using Excel 2007, copy pasted all the data
from old XLS file, saved it as XLSX file (new extension for Excel 2007). Now
I apply filter (not even multiple, only one filter on a particular column)
and selected first few row values from first column and pasted to a new
excel. Now I again get all the rows which are filtered.

This is a bug. No doubt.

SeethaRaman

 

[Nick Hodge]

SeethaRaman

I've posted this on a beta newsgroup I have and see if I get any better
answers for you as I can't replicate how ever hard I try

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[Nick Hodge]

SeethaRaman

I've got no one at MS to repro this either. Can you list me detailed steps
and we'll all try and repro. (remember things like version detail, new or
old workbooks, etc.)

If we still fail, I'll possibly get the workbook from you or put you in
touch directly.

Interestingly I came across another while testing. If you filter several
columns when set up as a 'table' and just copy the rows the formatting style
(bight blue, dark blue, etc) gets copied over. If you copy and paste the
entire column the formatting gets lost

Later....

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[SeethaRaman]

I can send you the spread sheet that I am using. The repro steps are pretty
much straight forward.
1. Have spread sheet data in Tabular format (rows and columns). I have data
of 8 columns and 500 rows. I have columns like the following:
BugID, Bug Title, Bug Type, Priority, Assigned For, Assigned To, Status,
Opened By
2. The possible/current values in each column are:
BugID: any 4 digit numeral
Bug Title: Any text
Bug Type: "60 Day", "Non 60 Day", "Parser Dev"
Priority: "P0", "P1","P2","P3"
Assigned For: "Engineering", "Technical Review"
Assigned To: To whom the bug was assigned to (any alias, initials)
Status: "Closed", "Resolved", blank
Opened By: some name or blank
3. Now have some dummy data in those columns.
4. Sort on the first column (Bug ID).
5. Set "Auto Filter" to all the eight columns.
6. Now chose to filter on "Status" column having value "Closed". Out of 500
rows, some 350 will be selected. The status bar shows "350 of 500 records
found". Make sure that some the first 10 rows of original data are filtered
(do not have "Closed" in "Status" column).
7. Now select first 10 rows (for eg) of first column.
8. Copy and paste in another Excel sheet. You will see all the "Bug ID" s
filtered i.e., not having "Status" column set to "Closed". Basically, I
wanted to see only the first few "Bug ID"s for which the "Status" column does
not have "Closed".

Hope I am making some sense.

SeethaRaman

 

[Nick Hodge]

SeethaRaman

Can you send me a copy of the workbook. (Take out the obvious bits in my
email address)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[SeethaRaman]

I have sent the spread sheet to (e-mail address removed)

SeethaRaman