Bug 71519 - Calc: Add option with warning for pasting selection/visible cells to filtered part of table (instead of "insert into multiple selection not possible")
Summary: Calc: Add option with warning for pasting selection/visible cells to filtered...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.3.0 release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL: https://help.libreoffice.org/Calc/Onl...
Whiteboard: BSA
: 84389 (view as bug list)
Depends on:
Blocks: Paste Calc-UX
  Show dependency treegraph
Reported: 2013-11-12 03:26 UTC by Plavozont
Modified: 2019-02-19 19:10 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Copy/Pasting inside the filter (8.80 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-11-12 08:58 UTC, Plavozont

Note You need to log in before you can comment on or make changes to this bug.
Description Plavozont 2013-11-12 03:26:14 UTC
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.

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: release
Comment 1 Cor Nouws 2013-11-12 08:26:18 UTC
HI Plavozont,

thanks for describing the issue.

To be sure that we test in the same way as you, can you pls provide a test file?
Comment 2 Plavozont 2013-11-12 08:58:29 UTC
Created attachment 89073 [details]
Copy/Pasting inside the filter

Copy Range A4:A22 and paste it into B4
Comment 3 Cor Nouws 2013-11-12 21:31:07 UTC
(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?

Comment 4 Plavozont 2013-11-20 17:22:21 UTC
Yes, set this as an enhancement
Comment 5 Ady 2013-11-21 02:05:52 UTC Comment hidden (obsolete)
Comment 6 Timur 2018-02-21 11:49:03 UTC
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.
Comment 7 Timur 2018-02-21 11:49:19 UTC
*** Bug 84389 has been marked as a duplicate of this bug. ***