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.
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.
[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:
more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
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.
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.