Bug 84389 - EDITING: copy - paste for a selection with hidden rows on the same sheet gives "insert into multiple selection not possible"
Summary: EDITING: copy - paste for a selection with hidden rows on the same sheet give...
Status: RESOLVED DUPLICATE of bug 71519
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords: needsDevAdvice
Depends on:
Blocks: Paste
  Show dependency tree / graph
 
Reported: 2014-09-27 08:52 UTC by Burak Ural
Modified: 2018-02-21 11:49 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Burak Ural 2014-09-27 08:52:10 UTC 
Problem description: 
Copying multip cells can not be made to current sheet , however it can be made to another sheet.
Steps to reproduce:
1. Have a sheet with lots of data which has duplicates in a column.
2. Use standart filter, set all criteria as none, click no duplicates.
3. Select all the visible cells, copy , go to an empty column, try to paste.

Current behavior:
You will have error , "insert into multiple selection not possible." if you paste to current sheet.
No error when pasting to another sheet.
Expected behavior:
The data in clipboard should be pasted into any sheet, current or not.
              
Operating System: Windows XP
Version: 4.3.1.2 release
Comment 1 Matthew Francis 2014-09-28 04:09:09 UTC 
Confirmed on OSX / LO 4.3.2.2

The described sequence of actions causes some rows to be hidden, but manually hiding rows instead of filtering doesn't have the same effect, so something else is going on here.


=> Platform: All
=> NEW
Comment 2 QA Administrators 2015-10-14 19:56:55 UTC Comment hidden (obsolete)
Comment 3 QA Administrators 2016-11-08 11:13:51 UTC Comment hidden (obsolete)
Comment 4 Zineta 2017-10-12 10:07:45 UTC 
LO 5.2.7;LO 6.0 and earlier
OS:Win 7
You will have error , "insert into multiple selection not possible." if you paste 
selected cells to cells where some cells are hidden by filter.

But if you skip hidden rows you can paste it to current sheet.
Also when select all filtered  column it can be pasted no matter if hidden rows exists.
Why not just check option copy results to, instead copy filtered cells?
Comment 5 Timur 2017-10-12 17:31:42 UTC 
1. Simple values to fill single column with label and row values:
label
A
B
C
A
B
D
A (try with and without this value)

2. Use standard filter, select values A / alternatively values  C and D
3. Select filtered cells and copy 
4. Go to an empty column from first to last visible row, try to paste

(In reply to Burak Ural from comment #0)

> Current behavior:
> No error when pasting to another sheet.
Because values are pasted consecutively. That's not a justification to have the same on the original sheet. 
> You will have error "insert into multiple selection not possible." if you
> paste to current sheet.
Sometimes. 
> Expected behavior:
> The data in clipboard should be pasted into any sheet, current or not.
Can't agree. MSO has somewhat different behavior but also doesn't always do it. 

I can't consistently say this is wrong behavior. Or not. 
If this error message is correct it would be useful to put some Help button there and write help, I couldn't find it. 

What I notice we lack documentation for new features. Look old Bug 38822, where is that behavior in help?
Comment 6 Zineta 2017-10-25 08:13:02 UTC 
Now it seems to be fixed.
No more error  message "insert into multiple selection not possible."
where some cells are hidden by filter.

Version: 6.0.0.0.alpha1+ (x64)
Build ID: 141279127b4c9ced4d86af245e1d780c473cd5bb
CPU threads: 2; OS: Windows 6.1; UI render: default; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2017-10-25_02:50:04
Comment 7 Timur 2018-02-21 11:49:19 UTC 

*** This bug has been marked as a duplicate of bug 71519 ***