Bug 165570 - [EDITING] Drag and drop while there is data in last row (row 1048576)
Summary: [EDITING] Drag and drop while there is data in last row (row 1048576)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.7.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-03-04 17:54 UTC by LeroyG
Modified: 2025-03-14 11:28 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Sample file to test. (7.92 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-03-04 17:54 UTC, LeroyG 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description LeroyG 2025-03-04 17:54:40 UTC 
Created attachment 199604 [details]
Sample file to test.

You can't use drag and drop while holding Alt from any complete row (including row 1048576), when you have data in the last row (1048576) (formatting will be ignored and lost).

Drag and drop row 1048576 only will move cells until the last column with content (not formatting).

Drag and drop row 1048576 with Ctrl only will copy cells until the last column with content (not formatting).

Steps to reproduce:
1. Enter in the following cells:
A1048575: text1
A1048576: text2
B1048576: (some formatting, i.e., background color)
C1048576: text3
D1048576: (some formatting, i.e., background color)
2. Select row 1048576
3.a. Drag row 1048576 over row 1048574
3.b. Drag row 1048576 over row 1048574 and release while holding Alt


Actual results:
After 3.a. only cells A1048576:C1048576 are moved to row 1048574, formatting in D1048576 remains there.
After 3.b. (nothing).


Expected results:
After 3.a. complete row 1048576 is moved into row 1048574.
After 3.b. row 1048576 becomes row 1084574, and row 1048575 becomes 1048576.


Reproducible with:
Version: 24.2.7.2 (X86_64) / LibreOffice Community
Build ID: ee3885777aa7032db5a9b65deec9457448a91162
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win
Locale: es-MX (es_ES); UI: en-US
Calc: CL threaded
Comment 1 Jessica 2025-03-05 08:44:27 UTC 
Thank you for reporting the bug. I can confirm that the bug is present in


Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: a91494780bb59afe8c971003e6b809f1e66df050
CPU threads: 16; OS: Windows 11 X86_64 (build 22631); UI render: Skia/Vulkan; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: threaded

and also in 

Version: 25.2.1.2 (X86_64) / LibreOffice Community
Build ID: d3abf4aee5fd705e4a92bba33a32f40bc4e56f49
CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Vulkan; VCL: win
Locale: de-DE (de_DE); UI: en-GB
Calc: threaded

The bug of step 3a only happens on row 1048576. For other rows it is working.
Comment 2 LeroyG 2025-03-06 21:50:42 UTC 
Reproducible with:

Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 60(Build:1)
CPU threads: 4; OS: Linux 5.14; UI render: default; VCL: gtk3
Locale: es-MX (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 3 LeroyG 2025-03-13 21:14:49 UTC 
Reproducible with:

Version: 24.8.4.2 (X86_64) / LibreOffice Community
Build ID: 480(Build:2)
CPU threads: 4; OS: Linux 6.4; UI render: default; VCL: gtk3
Locale: es-MX (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 4 LeroyG 2025-03-14 11:28:34 UTC 
Reproducible with:

Versión: 6.4.7.2 (x64)
Id. de compilación: 639b8ac485750d5696d7590a72ef1b496725cfb5
Subprocs. CPU: 4; SO: Windows 10.0 Build 17763; Repres. IU: predet.; VCL: win; 
Configuración regional: es-AR (es_AR); Idioma de IU: es-ES
Calc: threaded