[Upstream] Insert into multiple selection not possible
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
LibreOffice |
Confirmed
|
Wishlist
|
|||
libreoffice (Ubuntu) |
Won't Fix
|
Wishlist
|
Unassigned |
Bug Description
Steps to Reproduce:
1) Open new spreadsheet.
2) Press Ctrl+C to copy contents of the A1 cell.
3) Hold Ctrl and select A3.
4) Press Ctrl+V to paste.
Actual Results:
"Insert into multiple selection not possible" info dialog.
Expected Results:
1) If there is one cell copied:
clipboard contents should be inserted into every selected cell.
2) If there are multiple cells it is questionable but I think the expected
result would be pasting only the first NxN cells where there is NxN adjacent
cells in the selection. And repeat pasting while the end of the adjacent region
is reached for the last one bigger than clipboard.
ProblemType: Bug
DistroRelease: Ubuntu 11.10
Package: libreoffice-calc 1:3.4.3-3ubuntu2
ProcVersionSign
Uname: Linux 3.0.0-13-generic i686
ApportVersion: 1.23-0ubuntu4
Architecture: i386
Date: Tue Nov 1 01:13:06 2011
SourcePackage: libreoffice
UpgradeStatus: No upgrade log present (probably fresh install)
Changed in libreoffice (Ubuntu): | |
status: | New → Confirmed |
Changed in df-libreoffice: | |
importance: | Unknown → Wishlist |
status: | Unknown → Confirmed |
Changed in df-libreoffice: | |
status: | Confirmed → Invalid |
Changed in df-libreoffice: | |
importance: | Wishlist → Unknown |
status: | Invalid → Unknown |
Changed in df-libreoffice: | |
importance: | Unknown → Wishlist |
status: | Unknown → Confirmed |
Support copying of a single range and pasting it to multiple ranges
Background: Excel supports e.g. copying A1, and pasting it to D3, D5, D9, but Calc doesn't support this operation yet. We should add this support.
Detailed requirement: When the destination ranges are exact multiple of the copied range geometry-wise, allow the paste, otherwise throw an error and abort the paste. For example, when the copied range is A1:A3, and the user wishes to paste it to B5:B10,E8:E13, the paste should proceed. If the user wishes to paste the same range to, say, B5:B11,E8:13, it should throw an error message and abort.
Code pointers: We should be able to add this enhancement just by modifying the code that does pasting. However, if needed, ScViewFunc: :CopyToClip( ) is where the copying of range to the clipboard instance takes place. ScViewFunc: :PasteFromClip( ) handles pasting of cells.
Skills: building, debugging, medium C++, ability to read and understand C++ code