Bug 38281

Summary:	EDITING Enable pasting one line/word from clipboard to multiple cells at once
Product:	LibreOffice	Reporter:	Steve Edmonds <steve>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	enhancement	CC:	cno, heiko.tietze, sasha.libreoffice
Priority:	medium
Version:	unspecified
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	102593, 108252

Description Steve Edmonds 2011-06-14 01:21:14 UTC

When pasting to multiple cells (a range) of an item not copied from calc (i.e. a number copied from another application) only the top cell receives data. If the data was copied from a cell (a cell was copied as opposed to the contents of a cell) then the data pastes to all cells.


1. Enter say the digit 9 into a cell.  Click into the cell, copy. Select 5 cells and paste. 9 pastes into all 5  cells.

2. Now in your email, select a word or number and copy. Select 5  cells and paste. The word only pastes into the top 1 of the 5  cells.

It would be nice if the behavior in 2 was the same as in  1. This would be an enhancement over the current situation in LO and Excel.

Comment 1 Tom 2011-06-14 03:07:30 UTC

Hi :)
Confirmed in Ubuntu 10.04 with LibreOffice 3.3.2 (from the PPAs).  It also happens the same in Excel but it's inconsistent internally.  

The same thing happens when trying to copy from other apps, such as Writer.  The value is only posted to the top cell of the selection.  
Regards from
Tom :)

Comment 2 Björn Michaelsen 2011-12-23 12:22:05 UTC Comment hidden (obsolete)

[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1

more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html

Comment 3 sasha.libreoffice 2012-02-29 05:05:45 UTC

Reproduced in 3.5.0 on Fedora 64 bit
I agree that it is inconsistency. In Writer we can select some cell in table and paste text there, it appears in all selected cells. In Calc only in first cell.

Comment 4 Heiko Tietze 2021-04-09 09:42:58 UTC

Same behavior in Writer, if you copy the cell pasting into multiple selected cells duplicates. Pasting content from external tools such as an editor gives an error in Writer but alike Calc pastes into the first cell only.