Apache OpenOffice (AOO) Bugzilla – Issue 68569
Allow paste of external data into multiple cells
Last modified: 2013-08-07 15:12:27 UTC
1. Open a new Calc document. 2. Write "Test" in A1. 3. Copy cell A1, select B1-B10, paste. 4. "Test" gets pasted to all selected cells. 5. Open a new Writer document, type "Test", copy the word "Test". 6. Back to Calc, select C1-C10, paste. Expected: 7. "Test" gets pasted to all selected cells. Actual: 7. "Test" gets pasted to only one cell. Desired behavior: a warning is shown, saying that the selected range of cells does not match the clipboard contents; then all selected cells are filled. [Reported by Stefano and Flavio Aime on the Italian users mailing list]
*** Issue 68569 has been confirmed by votes. ***
This is also an Excel compatibility issue: Excel behaves as specified in this ENHANCEMENT.
IMHO we should keep it as is. But this is just my opinion. Requirements have to decide.