Copy visible cell only

[micheal]

I want to copy cell or column when hidden one or much column.
If copy in filter, it right
If hidden columns or rows, it fail
i try extension “copy visible cell” but not working in version 3.5.3, libreoffice to exit when i click button copy visible cell.

How to copy visible cell???
why microsoft excell easy copy visible cell but libreoffice calc verry difficult???

[chimak111]

I have reported a similar problem here.

The solution that works for me is to use the code snippet provided by Villeroy here as a macro. A little more discussion is here.

[luyu]

Following LibreOffice extension serves that purpose:

Copy only visible cells

[chimak111]

OP claims to have tried that extension but feels it doesn’t work in 3.5.3.

[luyu]

I somehow missed or misunderstood that part. Thanks for pointing it out.