Bug 152004 - Calc EDITING : after pasting a block, pressing Shift-Ctrl-Down does not go bottom
Summary: Calc EDITING : after pasting a block, pressing Shift-Ctrl-Down does not go bo...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.6.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-11-11 11:16 UTC by nicduv
Modified: 2024-11-16 11:37 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description nicduv 2022-11-11 11:16:02 UTC
Description:
when a block of cells is copied to another location, if I press Shift-Ctrl-Down to go to the bottom of the pasted block, the selected cell does not land at the expected location

Steps to Reproduce:
1. copy a block of data, e.g. 10 rows with Ctrl-C
2. paste it somewhere (same sheet, or another sheet, or another file) with Ctrl-V
3. immediately press Shift-Ctrl-Down


Actual Results:
selection does not go the bottom of the pasted block. I have seen either not far enough (selection is still within the block) or too far (selection is quite a few rows below pasted block)

Expected Results:
Selection lands exactly at the last row of the pasted block. This is actually what happens if I first go down 1 cell with the Down key and then press Ctrl-Shift-Down.


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.3.6.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Ubuntu package version: 1:7.3.6-0ubuntu0.22.04.2
Calc: threaded
Comment 1 Rafael Lima 2022-11-11 14:21:32 UTC
Hi Nicolas, thanks for reporting.

When I copy and paste a range of cells, the pasted range is already selected right after Ctrl+V. So there's no need for Ctrl+Shift+Down to select the entire range.
Comment 2 kabilo 2022-11-11 14:32:40 UTC
Hi, ctrl-down doesn't work properly.
Comment 3 Rafael Lima 2022-11-11 14:36:25 UTC
(In reply to kabilo from comment #2)
> Hi, ctrl-down doesn't work properly.

I don' reproduce the problem. Can you please provide more information on what the problem really is?

So, when I paste the 10-row range, the pasted range is already selected. If you press Ctrl+Down it will move to the next range below the selected range (since it is already selected.
Comment 4 nicduv 2022-11-11 17:09:25 UTC
Hello
I created a block 2columns x 10 rows with some data in it in cells A1:B11.
Select them, copy, and paste at G6
Press Ctrl-Down (a previous comment was right, I apologise...), and selection cell comes to G11, whereas I expect it to come to G16
Or, even more funny :
Start with some data in A1:B11.
Select cell A1. press Shift-Control-Down then Shift-Control-Right. The block is now fully selected, and most highlighted cell is still A1.
Now press Ctrl-Down, and you land at row 1048566.
OK, let's go back to A11, and paste.
Then Ctrl-Down and you arrive in A33.
Copy once again the block in A23. Ctrl-Down lands in A55.
Comment 5 QA Administrators 2024-11-16 03:16:42 UTC Comment hidden (obsolete)
Comment 6 nicduv 2024-11-16 11:37:13 UTC
Hello

New test with this release:
Version: 24.2.6.2 (X86_64) / LibreOffice Community
Build ID: 420(Build:2)
CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Ubuntu package version: 4:24.2.6-0ubuntu0.24.04.1
Calc: threaded

The behaviour is different from my 2022 report.
Procedure 1 :
create a block 2columns x 10 rows with some data in it in cells A1:B11.
Select them, copy, and paste at G6
Press Ctrl-Down and you land in G1048567 (which is not the bottom of the sheet). I would expect to land in G15

Procedure 2
Start with some data in A1:B11.
Select cell A1. press Shift-Control-Down then Shift-Control-Right. The block is now fully selected, and most highlighted cell is still A1.
Now press Ctrl-Down, and you land at row 1048567.
OK, let's go back to A11, and paste.
Then Ctrl-Down and you arrive in A1048567.
Copy once again the block in A23. Ctrl-Down lands in A1048567.

I guess that row 1048567 is calculated as "max row - # of rows in selected block"