Bug 49205 - EDITING: Pasting range into autofiltered fields results in "Insert into multiple selection not possible"
Summary: EDITING: Pasting range into autofiltered fields results in "Insert into multi...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.5.2 release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Blocks: AutoFilter
  Show dependency treegraph
Reported: 2012-04-26 23:03 UTC by mahfiaz
Modified: 2021-06-14 23:00 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Example document for easy testing. (8.36 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-04-17 05:29 UTC, mahfiaz
some tests copy/paste with discontinuos ranges (11.34 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-05-19 06:11 UTC, b.

Note You need to log in before you can comment on or make changes to this bug.
Description mahfiaz 2012-04-26 23:03:30 UTC
Problem description: 
Cannot paste into autofiltered range, because selection is not uniform.

Steps to reproduce:
1. Make a list of repeating numbers in one column such as 1, 2, 3, 4, 1, 2, 3, 4. 
2. Now use autofilter to filter out everything but ones.
3. Let's say you want to copy there your two lines of data from somewhere else. But you cannot, Libreoffice says you cannot paste into multiple selections.

Expected behavior:
Being able to paste into autofiltered sheet to visible fields.

Platform (if different from the browser): 
Browser: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:11.0) Gecko/20100101 Firefox/11.0
Comment 1 bfoman (inactive) 2012-07-17 12:59:21 UTC
Checked with:
Build ID: own W7 debug build
Windows 7 Professional SP1 64 bit

In your example I could paste into filtered fields using Ctrl+V. I just received "cells contain data" warning. However paste commands in right-menu or toolbar buttons are disabled.
Comment 2 mahfiaz 2012-09-06 21:01:00 UTC
LibO 3.6.1, still the same. If you test it just make sure the range you are pasting into contains at least a row, which is filtered out.
Easiest is to copy everything and then paste it into the same place.
Comment 3 mahfiaz 2016-04-17 05:29:19 UTC
Created attachment 124421 [details]
Example document for easy testing.

Still an issue in
Comment 4 mahfiaz 2019-03-30 17:26:59 UTC
Still same in

The error message in Calc is of course much better than Excel 2016-s way of pasting in hidden cells at random (some cells get new content, some don't, visible ones usually do).
Comment 6 b. 2020-05-19 06:11:48 UTC
Created attachment 160989 [details]
some tests copy/paste with discontinuos ranges

misleading ... or improved? 

from the title/subject and the sample and test one could get the impression it's generally impossible to paste data into discontinuos areas ... 

at least with ver and the opposite is true, it is even possible to copy from one discountinuos area to other discountinuos areas, see attached sheet, cases S, U, Y, Z, only some simple cases are blocked, see yellow highlighting in attached sheet, 

why? was a developer 'unusually careful' not to produce errors by automatic extend of the target area? in other cases this is generously accepted, 

of course, a security warning would be desirable beforehand,  

there are! some flaws, see red highlighting in attached sheet, 

the request from this bug works if you select A2:A6 instead of only A2 as target for pasting, maybe that caused the norepro comment #1, 

i'd suggest: 

- enable pasting to 'small targets', 

- replace the option 'yes' from the dialog 'The content of the clipboard is bigger than the range selected. - Do you want to insert it anyway?' by a selection: 
A: 'shrink' - copy partial data to small target area, 
B: 'extend' - copy full clipboard to automatically extended target range, 

not only for copying to autofiltered ranges but in general if target < source in width or height,
Comment 7 stragu 2021-06-14 23:00:31 UTC
In example document attachment 124421 [details] :

1. Copy B15:B16
2. Paste on A2
Result: "Insert into multiple selection not possible"
I agree that this is not a good error message for this case, as the user has clearly not selected non-contiguous cell ranges, but only one single cell.


1. Copy B15:B16
2. Select range A2:A6
3. Paste
Result: this works. Only the visible values are replaced by 2s.
Interestingly, this case seemingly corresponds more to a "multiple selection" than the previous case.
Note that multi-selecting the same cells one by one instead (with Ctrl + Click), and pasting, will result in the first error message: "Insert into multiple selection not possible".

In my opinion, the main issue described here is that the first error message is not suitable, as there is not multiple selection. A solution would be to either:
- Use a more relevant error message, along the lines of: "It is unclear from selected area where the data should be pasted."
- Or, better: the paste should behave exactly like when selecting the range: it works by bypassing the rows that are not visible.

Tested with:

Version: / LibreOffice Community
Build ID: bb54d6d8241a06a6772052b77b67d6a4f686426c
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-06-11_20:14:38
Calc: threaded

(Title of report was "EDITING: Pasting to autofiltered fields", so changed to something more descriptive)