Issue 124729 - Second paste of copied selected area pastes to cell cursor position instead of overwriting selection
Summary: Second paste of copied selected area pastes to cell cursor position instead o...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: Mac All
: P3 Minor (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-04-22 23:33 UTC by realgrouchy
Modified: 2014-04-23 09:22 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

Attachments
Sample Document (16.89 KB, application/x-vnd.oasis.opendocument.spreadsheet)
2014-04-23 06:01 UTC, Rainer Bielefeld 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description realgrouchy 2014-04-22 23:33:56 UTC 
1. Open a new Calc document
2. Put text in A1, A2, B1, B2
3. Select cell range A1:B2 by clicking and dragging from A1 to B2
4. Copy cell range with cmd+c (do not cancel selection)
5. Paste cell range with cmd+v (do not cancel selection)
Result: Range pastes in same area, as expected.
6. Paste cell range again with cmd+v again
Result: Range pastes in range B2:C3 instead of A1:B2

This problem occurs for me when I type a formula into a cell, paste that formula into a selected cell range, then with the same range selected copy and paste the values of the cells. Instead of pasting into the selected range (which is difficult to identify the second time around), it starts the paste at the bottom-right cell instead of pasting overtop the still-selected area.
Comment 1 Rainer Bielefeld 2014-04-23 06:01:04 UTC 
Situation is a little different to reporters description.

Steps how to reproduce with attached sample document:
0. Open Document from AOO Start center
1. Click A16, with pushed left mouse button move mouse pointer to B17
   > A16:B17 becomes selected, Cell Cursor at B17
2. <control+c> for copy
3. <control+v> for paste
   > as expected selected area A16:B17 will be overwritten by it's 
   copied contents, no changes visible
4. <control+v> for paste
   Expected: as Step 3
   Actual: Pasted To B17:C18
    
The second paste will paste to an area with cell cursor position as top left cell of paste-range. You can check that fact by selecting B17:A16 (backwards) instead of A16:B17. Effect will not be visible.

Additional info:

(a) You also can reach a more extreme effect: Between step 2 and step 3 insert 
    a step 
2.1. 2 times click on F25 
     > selects -> deselects F25
       (A16:B17 keeps highlighted)

Step 3 will again overwrite selected area, step 4 will paste to F25:G26

(b) not a new effect, already visible with OOo 3.1.1, not visible with
    OOo 2.0.2
(c) I am tending to see observed behavior as a bug, but might be a feature?
(d) I do not observe the complained behavior with LobO 4.2
(e) Softmaker FreeOffice and Kingsoft behave completely different
Comment 2 Rainer Bielefeld 2014-04-23 06:01:43 UTC 
Created attachment 83255 [details]
Sample Document

See comment above how to use
Comment 3 Rainer Bielefeld 2014-04-23 09:22:46 UTC 
I can't imagine any application where current behavior might be a useful feature.