Ask Your Question

Paste only to visible cells into filtered column in Calc

asked 2018-06-10 21:20:40 +0200

singularity gravatar image

updated 2018-06-10 21:36:54 +0200

Hi all!

It might be a very causal situation. I want to paste some date into filtered column. Of course it is a somehow tricky. LO gives a warning "Insert into multiple selection not possible"

Is there a way how I can paste into visible cells only omitting cells hidden by filter?

All comments are appreciated Thnx

edit retag flag offensive close merge delete


jondo gravatar imagejondo ( 2019-07-18 16:23:11 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2020-05-24 17:18:14 +0200

newbie-02 gravatar image


i did a short investigation in this issue some days ago, if i'm right it's very easy possible, just some simple cases are blocked, and some others are buggy, dunno why ...


edit flag offensive delete link more

answered 2018-06-10 22:01:40 +0200

singularity gravatar image

updated 2018-06-10 22:02:16 +0200

Ok, problem solved by this extension Enhanced "Paste" command for spreadsheet documents Hope it will help others

edit flag offensive delete link more


I installed that extension, but Paste behaves as before, and I can't find any new menu entries. It's listed among my installed extensions, but where is it in the interface? The instructions link leads to a page with login.

Andreas1974 gravatar imageAndreas1974 ( 2018-09-19 15:35:46 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-06-10 21:20:40 +0200

Seen: 1,118 times

Last updated: May 24