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

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

Anonymous

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

delete close flag offensive retag edit

2 Answers

Sort by » oldest newest most voted

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

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

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

chimak111
88 ● 1 ● 6

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.

link delete flag offensive edit

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

luyu
1038 ● 1 ● 8 ● 14

Following LibreOffice extension serves that purpose:

Copy only visible cells

link delete flag offensive edit

Comments

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

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

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

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

Resources

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

Stats

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

Seen: 387 times

Last updated: May 24 '12

copy visible cell only

2 Answers

Comments

Resources

Donate

Question tools

Stats

Related questions