Description: After cutting a row and pasting special of this row, with shifting cells down, the row before the one that has been cut contains corrupt data: any cells that referenced other cells in the same row will have there row-reference changed to the pasted row. Steps to Reproduce: Create a sheet as follows: ColA ColB Row1 1 =A1 displayed as 1 Row2 2 =A2 displayed as 2 Row3 3 =A3 displayed as 3 Row4 4 =A4 displayed as 4 Then cut Row3 and paste special with shifting cells down on Row1. This results in the following ColA ColB Row1 3 3 displayed as 3 Row2 1 =A2 displayed as 1 Row3 2 =A1 displayed as 3 Row4 Row5 4 =A5 displayed as 4 So Row3/ColB has been corrupted Actual Results: So Row3/ColB has been corrupted Expected Results: ColA ColB Row1 3 3 displayed as 3 Row2 1 =A2 displayed as 1 Row3 2 =A3 displayed as 2 Row4 Row5 4 =A5 displayed as 4 Reproducible: Always User Profile Reset: No Additional Info: Row3/ColB should contain =A3 not =A1 Some recent, older versions have the same bug, but it used to work before ?? See About info in attached file
Created attachment 190968 [details] About LibreOiifceCalc
Reproducible: Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: bc5c767e9aebadf12aa6a181a6ce066cbfff71ad CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: default; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
Is anybody looking at this bug? I find it a rather serious problem and the bug is still present in 7.6.6.3 (X86_64)
Selecting also paste formulas works fine. It never works, inherited from OpenOffice. Reproducible with all versions.