Problem description: 

Steps to reproduce:
1. take 2 tables with prices for fruits for june and july
2. filter only oranges of different varieties in both tables
3. assume that we have 50 oranges of different varieties in both tables(i mean the lists match each other)
4. we need to replace prices for july with the prices for june
5. it seems that this is only a matter of selecting the column in the filtered table with the prices for june and pasting it into the filtered table for july

Current behavior:
LibreOffice says this is impossible
Microsoft Excel would paste it as if the july table had no filter

Expected behavior:
I see 2 tables, no matter they have hidden rows or columns, I should have an apportunity to work with them like with a normal tables.

Comments:
The solution for this situation is ether to copy 50 times each price separately(this is about 150 keypresses) or to write a complexed formula(this is a lot of keypresses too), but it looks intuitively like a copy/paste operation. Please implement this feature, I know you care about users, not about marketing like Microsoft, so please take care of me))
Operating System: Windows XP
Version: 4.1.2.3 release