Bug 38822

Summary: [EasyHack] Support copying of a single range and pasting it to multiple ranges
Product: LibreOffice Reporter: Björn Michaelsen <bjoern.michaelsen>
Component: CalcAssignee: Kohei Yoshida <kohei>
Status: RESOLVED FIXED    
Severity: enhancement CC: chris, kohei, robinson.libreoffice, serhiy.int
Priority: medium Keywords: difficultyInteresting, easyHack, skillCpp, skillDebug, topicDebug
Version: unspecified   
Hardware: All   
OS: All   
See Also: https://launchpad.net/bugs/884513
https://bugs.documentfoundation.org/show_bug.cgi?id=84389
Whiteboard:
Crash report or crash signature: Regression By:

Description Björn Michaelsen 2011-06-30 08:05:47 UTC 
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
Comment 1 Сергій Загорія 2012-02-14 10:22:53 UTC 
*** Bug 42456 has been marked as a duplicate of this bug. ***
Comment 2 Сергій Загорія 2012-02-14 10:32:18 UTC 
It looks like Kohei Yoshida made this possible:
http://wiki.documentfoundation.org/ReleaseNotes/3.5#Calc
Comment 3 Björn Michaelsen 2012-02-14 17:04:02 UTC 
@Kohei: Could you check if your fixes cover the full scope of this EasyHack (and close if they do)?
Comment 4 Kohei Yoshida 2012-02-14 17:04:57 UTC 
Yes, this is completed.
Comment 5 Robinson Tryon (qubit) 2015-12-15 23:24:17 UTC Comment hidden (obsolete)