https://bugs.documentfoundation.org/show_bug.cgi?id=158319

            Bug ID: 158319
           Summary: Data corruption in Calc after Cut and Paste Special of
                    a row
           Product: LibreOffice
           Version: 7.5.8.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

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

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to