paste a filtered dataset

asked 2019-11-07 13:03:18 +0100

patbell101 gravatar image

updated 2019-11-07 13:10:16 +0100

I have a worksheet with filtered rows. I want to copy values from cells in a single column into another worksheet but it just copies the unfiltered data. To clarify I have many rows hidden by the filter but when I copy, all the hidden data get pasted. I have say, 25 cells but they become 250 when I paste.

I am using paste special->paste special with Selection:Text, Numbers, Data and Time; Operations:None; Options:None; Shift Cells:Dont shift. I have tried Values only and Values and formats but all attempts just paste the unfiltered data.

The source worksheet is filtered using Data-MoreFilters-StandardFilter on values in a single column.

The help for "Only copy filtered cells" says Cells were filtered by AutoFilters, standard filters or advanced filters.Result= Only the visible cells of the selection are copied, deleted, moved, or formatted.

What am I doing wrong?

edit retag flag offensive close merge delete


Works fine for me. Which LibreOffice version and platform anyway?

erAck gravatar imageerAck ( 2019-11-07 13:30:14 +0100 )edit

Please add to your question the information in Menu/Help/About LibreOffice version and operating system.

m.a.riosv gravatar imagem.a.riosv ( 2019-11-07 23:20:56 +0100 )edit