copy/paste after filtering

this is sorta working for me:

if you command-click (discontiguous selection) the row markers for the cells shown in a filtered table, copying will copy all data in the cells in just those rows.

you can then paste the copied text into the top left cell of an inserted table and you're pretty much ready to go. the table seems to adjust flexibly so that it will expand to hold the pasted data.

this workaround is obviously of limited use if you're dealing with massive amounts of info, and it seems to strip formulas and so forth (not unexpectedly).

(if you shift-click to do the selection, all cells in the logical selection range - including those not visible in the filtered view - will be copied )

(this is an addition, not a reply - never too sure about forums)

you can extend this technique so you can shift-click all the filtered data in two clicks (say, top left cell to bottom right one). just use existing fields or add them as necessary to sort first (so that your target cells will be contiguous), and then filter on those fields. the sort ensures that all the cells you want lie next to one another, so, when you filter, there are no invisible cells between the ones you can see. just shift click to get 'em all, and paste into a blank table as before.

(a select-all copy won't work because it still returns every bit of data in the table.)

I desire this feature also.

The way I'd really like to see it implemented is an inherent function call itself - "Into this Table I'd like that other table right there after it is sorted by these criteria and filtered by these other criteria."

Sort and Filter rocks IMNSHO, but it would be really handy to be able to us if programtically as opposed to only being available via user action.

Yes,

Simply sort on all the criteria you filtered by in ascending order. i.e. if you filtered A, B, C then sort on A, B, C.

This should push all of the undesired rows after the ones you want, then simply shift click and you're done. I just did that technique on a table with over 44,000 rows and it got the exact set I needed.

I usually work with 20,000 rows and only 1 column. I tried the suggestion from Sovereign but still can't copy/paste only the filtered results. 😟

I'm impressed with the options for us to set unlimited filtering options (in excel, we only can set max 2 filtering options), but Numbers still need to learn much from excel on how to handle the filtered results.

So far, I still work with excel all the time, the Numbers application is useless in my Mac 😟

Hope it will be fix in the next update.

Hello

Describing a problem here doesn't help to solve it because we are not Apple employees but users trying to help other users.

Go to "Provide Numbers Feedback" in the "Numbers" menu and explain what you wish so that Apple's engineers may be read it.

Yvan KOENIG (from FRANCE mardi 13 novembre 2007 15:45:14)

I figured out a fast easy way to do this with zillions of rows...

1) Create a single sheet.
2) Create a single table with a single column. (I didn't use header or footers.)
3) Fill the single column will your data (I imported a CSV with 500 rows.)
4) Apply your filter. (I was left with 128 rows of data after the filter.)
5) Export the sheet to PDF (I just created a tmp.pdf file on my desktop using file->export)
6) Open the pdf (You'll notice only your filtered data is in the PDF -YEY!- )
7) Select the contents of the column in the pdf file.
8) Paste it into a new table in numbers.

The whole process takes about 30 seconds. But it is MUCH better than control-clicking each row 1 by 1.

Hope this help others! Hope apple makes this better. (Yes, I sent feedback!)

Random thought:
Numbers is the ONLY spreadsheet app I don't mind using. It is amazingly intuitive for someone like me who hates spread sheets.

Completing work with it is just so easy to do and easy to make look good! It is hard not to get excited about something that is normally SSSSSOOOOOO boring!