Ask Your Question
0

copy visible cell only [closed]

asked 2012-05-24 12:09:27 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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???

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-16 04:23:30.464636

2 Answers

Sort by » oldest newest most voted
1

answered 2012-05-24 17:22:25 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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.

edit flag offensive delete link more
0

answered 2012-05-24 14:11:32 +0200

luyu gravatar image

Following LibreOffice extension serves that purpose:

Copy only visible cells

edit flag offensive delete link more

Comments

1

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

chimak111 gravatar imagechimak111 ( 2012-05-24 17:08:38 +0200 )edit

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

luyu gravatar imageluyu ( 2012-05-24 19:19:36 +0200 )edit

Question Tools

Stats

Asked: 2012-05-24 12:09:27 +0200

Seen: 3,561 times

Last updated: May 24 '12