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
LibreOffice says this is impossible
Microsoft Excel would paste it as if the july table had no filter
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.
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: 18.104.22.168 release
thanks for describing the issue.
To be sure that we test in the same way as you, can you pls provide a test file?
Created attachment 89073 [details]
Copy/Pasting inside the filter
Copy Range A4:A22 and paste it into B4
(In reply to comment #2)
> Copy Range A4:A22 and paste it into B4
Thanks - I confirm the behaviour.
I see that it's like that since OOo times.
Work around: copy B4:B22 before pasting.
therefore: could you agree that we set his as enhancement?
Yes, set this as an enhancement
(In reply to comment #4)
> Yes, set this as an enhancement
Well, you could have done it yourself. I'm setting it now and changing Summary accordingly.
Copying selection or multiple cells can be made to another sheet or to the current sheet if you paste selected cells where some cells are not hidden by filter.
Behavior was changed in old Bug 38822, but it's not explained in documentation.
If this option can be added then we would need a warning that for example only visible cells will be copied.
When I tested for Bug 84389 I also saw different behavior for MSO.
Anyway, this remains like and enhancement but it may stay open for a long time.
*** Bug 84389 has been marked as a duplicate of this bug. ***