Copy visible cells in calc

Well i see there is a extension for that, but it is not working on version 6.
And why should we use extension for something so essential to calc. I think it should be implemented in the newer versions. Until then i would be most grateful if somebody shows me how to do this operation.

Sorry i use the latest version on windows 7 64 and i confirm that extension is not working for me, not copying anything i have tried to install it 3 times already i see it in menu but does not copy anything for me.
I have tried also second method that you have said and i cant make it work either. i have 2 columns in my sheet with names and numbers i have used sumtotal to have the sums of all equal names and wanted to copy result to another table but i am unable to do so. Result in sheet 2 was only A1 and B1.
Please help.

i have tried to lower security for macros and still the addon is not working for me in 6.2.1

Have you set up the configuration to run the macros, Menu/Tools/Options/LibreOffice/Security, if no that, test with Menu/Help/Restart in Safe mode to try with a clean profile.

First the extension “Copy only visible cells” works fine for me with the latest Version:

Other that you can do is using the standard filter to copy filtered data to other place.

There is an old bug request for that “Copy only visible cells”

that copy technique is what i needed, thanks

for deletion…

Please edit your question or use the comments, this is not an answer.

You have “Склад” = 1. But on the screenshot, it looks like your “Склад” is a text field - so possibly no rows could satisfy the condition; so only heading is copied. You need to remove the first operator (set Field name to None).

But anyway, the Standard filter would only keep filter criteria, not the manually hidden rows.

The easiest way without having to install anything is to copy the filtered data after filtering it exactly as you want, then when you paste it into another sheet choose “paste special” and select “Skip empty cells” in the bottom left Options, you only have to check it once, it remembers (you still have to paste special every time, but you don’t have to re-check the box).