[Upstream] Insert into multiple selection not possible

Bug #884513 reported by Serhiy
10
This bug affects 1 person
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
ProcVersionSignature: Ubuntu 3.0.0-13.21-generic 3.0.6
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)

Revision history for this message
In , Björn Michaelsen (bjoern-michaelsen) wrote :

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

Revision history for this message
In , Serhiy (xintx-ua) wrote :

Steps to Reproduce:
1) Open new spreadsheet.
2) Press Ctrl+C to copy contents of the A1 cell.
3) Hold Shift 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.

Revision history for this message
Serhiy (xintx-ua) wrote :
Revision history for this message
In , Serhiy (xintx-ua) wrote :

(In reply to comment #0)
> 3) Hold Shift and select A3.
Sorry, not Shift but Ctrl.

description: updated
Robert Roth (evfool)
Changed in libreoffice (Ubuntu):
status: New → Confirmed
Revision history for this message
penalvch (penalvch) wrote :

, this is:
- a clearcut upstream issue.
- won't be fixed in LibreOffice Packaging.
Resolving as Won't Fix in LibreOffice Packaging. This does not mean the issue will not be cared about, but if it is cared about (even by Ubuntu/Canonical contributors), it is done upstream at LibreOffice.

libreoffice (Ubuntu) => Won't Fix

summary: - Insert into multiple selection not possible
+ [Upstream] Insert into multiple selection not possible
Changed in libreoffice (Ubuntu):
importance: Undecided → Wishlist
status: Confirmed → Won't Fix
Changed in df-libreoffice:
importance: Unknown → Wishlist
status: Unknown → Confirmed
Revision history for this message
In , Serhiy (xintx-ua) wrote :

*** This bug has been marked as a duplicate of bug 38822 ***

Revision history for this message
In , Serhiy (xintx-ua) wrote :

*** Bug 42456 has been marked as a duplicate of this bug. ***

Revision history for this message
In , Serhiy (xintx-ua) wrote :

It looks like Kohei Yoshida made this possible:
http://wiki.documentfoundation.org/ReleaseNotes/3.5#Calc

Changed in df-libreoffice:
status: Confirmed → Invalid
penalvch (penalvch)
Changed in df-libreoffice:
importance: Wishlist → Unknown
status: Invalid → Unknown
Changed in df-libreoffice:
importance: Unknown → Wishlist
status: Unknown → Confirmed
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.