Apache OpenOffice (AOO) Bugzilla – Issue 7357
Paste into nonadjacent random cells
Last modified: 2017-05-20 11:01:03 UTC
Can only paste clipboard into multiple cells if selected adjacent to each other and selected in same row or column. Should be able to randomly select nonadjacent cells either individually or in groups and paste clipboard contents into them. Same applies to setting cell properties. This capability is available in Quattro Pro and Excel and frequently used by many of us. :-)
Hi Falko, 1 4 u Frank
Set to "NEW"
Copying multiple selections is _not_ supported in Excel. And in Quattro Pro I do not see any sensible way to actually use this selection when copied to clipboard (which is the reason why Excel and Oo.o do not support it I guess)
closed
Falko, This issue IS NOT about copying but rather PASTING as described in the issue summary and my initial problem description! I agree w/your assessment of COPYING which you've correctly stated is not supported in either Excel or Quattro Pro. However, pasting into multiple non-adjacent cells IS supported and is frequently used by the business community. Perhaps I should have been more clear and stated that a single cell is first copied onto the clipboard, then that info is pasted into the multiple selected cells. This happens for example when various cells throughout a spreadsheet contain the same text (eg, a person's name)and a fraction of them must be changed to a different common value. A search and replace would change all of them. It is frequently much faster to select the appropriate subset and paste the change into those cells only. It is accomplished by holding depressing the CTRL key while LEFT clicking w/mouse on the cells into which you want to paste. Afte hilighting the cells right clicking on any one of them opens a context menu which offers the paste operation. I hope this clarifies the nature of this issue and will persuade you to reopen it. I'm available for further clarification if necessary. Regards, John Gross :-)
Got it ;o) When making a mulitple selection of cells in Calc it must be possible to paste a value from the clipboard into all of the selected (non-adjacent) cell. MS Excel and Quattro Pro can do so.
started
Hello Niklas, please give approval for this evaluated OO.o 2.0 flagged issue. If you confirm with the target OO.o 2.0, then please keep it on your owner (or the owner of the concerning developer) for implementation. In case you want this issue for 'OOo Later', then please reset the target milestone. If you decline the issue finally, please set the resolution to 'Wontfix' (but do not close). In case of 'OOo Later' or 'Wontfix' please reset it on Bettina's owner. Thank you.
I also wish OO had this feature of being able to paste into randomly selected cells.
This is not on the list of features that we're going to do for 2.0. We need to focus on the enhancements from the PCD document.
*** Issue 51203 has been marked as a duplicate of this issue. ***
*** Issue 52314 has been marked as a duplicate of this issue. ***
*** Issue 58756 has been marked as a duplicate of this issue. ***
*** Issue 8096 has been marked as a duplicate of this issue. ***
issues 47754 and 78857 seem like duplicates of this issue
*** Issue 78857 has been marked as a duplicate of this issue. ***
Hi Niklas, these RFEs are in your ownership.
I think this issue also blocks issue 15522 (Tracking bug for Microsoft Office parity features). In Excel, filling multiple cells with identical data (values or formulas) by selecting cells, inserting data and hitting Ctrl+Return is an essential feature, and I miss it in OOo Calc.
Quattro Pro YES let us copy+paste from (& to) multiple independent selections cells/groups. Greetings.
*** Issue 97018 has been marked as a duplicate of this issue. ***
Set target and cc myself.
Are there any clue when we could copy+paste from/to multiple selections in OpenOffice Calc ? Or, important too, when we could set properties (borders for example) on multiple selections ? Greetings and congratulations for your work. It is excellent.
I see this has a target of 3.x set. Is it still in the works. Just wanted to make sure that it is still planned as it doesn't work yet in 3.1.1.
Cell formats (borders) work in 3.2 beta, see issue 50019. Pasting into a multiple selection is still open.
Please upgrade the importance of this enhancement. This is a serious inconvenience in usability. I do this *ALL* the time and simple things like this make it difficult for us in IBM to convince others that it is possible to migrate off Excel to AOO Calc.
Reset assigne to the default "issues@openoffice.apache.org".