Bug 90200 - EDITING: Undo does not reverse changed references
Summary: EDITING: Undo does not reverse changed references
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.1.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-03-24 16:01 UTC by (OPTIONAL) Real Name:
Modified: 2015-03-26 03:28 UTC (History)
2 users (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 (OPTIONAL) Real Name: 2015-03-24 16:01:03 UTC
1. Cut a table, which is linked to by a formula.
2. Insert the table at another position in any table in the current file.
3. All formulas linking to the table are updated.
The bug starts here
4. Press ctrl+z twice.
5. All formulas linking to the table are now pointing to the temporary position the table had and are effectively broken

manual WORKAROUND if your target area was empty:
manually cut and paste the table to previous position

this will leave any overwritten contet effectively deleted or all reverences invalidaded.

manual WORKAROUND when target area was not empty and needs to be restored:
ctrl+z twice after overwritting,
then cut the temporary area the table had,
copy it to your tables position and overwrite it's content,
ctrl+z twice
everything is now restored

when this is fixed none of the workarounds above should be used, 
because it's an extremely ugly solution that will break if undo is ever changed properly
Comment 1 (OPTIONAL) Real Name: 2015-03-24 16:04:05 UTC
*content effectively deleted --. all refenrences invalidated part was refering to the fact that if you don't reverse it manually that way they will be invalidated
Comment 2 A (Andy) 2015-03-24 19:28:56 UTC
For me not reproducible with LO 4.4.1.2., Win 8.1

On which operating system have you reproduced this issue?
Comment 3 raal 2015-03-24 21:46:42 UTC
I can not confirm with Version: 4.4.3.0.0+
Build ID: 5151160704492a2c438daa70acef1c8a87d6de55
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-4-4, Time: 2015-03-22_01:39:25

Please attach testing file with table and formulas.
Comment 4 raal 2015-03-24 21:50:53 UTC
Also install actual version of LO and test with this version. 4.3.1 is old.
http://www.libreoffice.org/download/

I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided and you tested with actual version of LO.
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Comment 5 (OPTIONAL) Real Name: 2015-03-26 03:28:46 UTC
ok, this bug also was fixed already it seems, after updating I cannot reproduce it anymore