Bug 77870

Summary: EDITING: Wrong formula behaviour when un-doing cell dragging
Product: LibreOffice Reporter: Paolo <e-paul>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WORKSFORME    
Severity: normal CC: miguelangelrv
Priority: medium    
Version: 4.2.0.4 release   
Hardware: Other   
OS: Windows (All)   
Whiteboard: BSA
Crash report or crash signature: Regression By:

Description Paolo 2014-04-24 06:46:38 UTC
Problem description: 

Steps to reproduce:
1. fill in a few cells with numbers
2. create simple formula referring to cells (e.g. sum)
3. drag cells with numbers. Formula still evaluates correctly
4. un-do (ctrl-z) cells drag operation Cells are brought back to the starting coordinates but formula does not evaluate anymore. 

Current behavior:
Formula's cell references are not updated correctly to the starting point when un-doing cell dragging.

Expected behavior:
Because it is an un-do operation, also the formula should be changed to the original cell references.
              
Operating System: Windows 7
Version: 4.2.0.4 release
Comment 1 m_a_riosv 2014-04-26 17:49:34 UTC
Hi Paolo, thanks for reporting.

Reproducible with:
Win7x64Ultimate
Version: 4.2.0.4 Build ID: 05dceb5d363845f2cf968344d7adab8dcfb2ba71
Version: 4.2.2.1 Build ID: 3be8cda0bddd8e430d8cda1ebfd581265cca5a0f
Versión: 4.2.3.3 Id. de compilación: 882f8a0a489bc99a9e60c7905a60226254cb6ff0

But works for me with:
Version: 4.2.4.1 Build ID: d4c441391e20647b3d2e8dde4d20aa868e77e515
Version: 4.3.0.0.alpha1+ Build ID: b08754f3358992387ea0eec7957745f4667ea7eb
   TinderBox: Win-x86@39, Branch:master, Time: 2014-04-26_00:32:11

I think there was a similar bug what I can find now.

As it is solved for releases in production, changed to resolved-worksforme, please if you are not agree, or you find it again for 4.2.4.1 or higher please reopen it.