Bug 61344 - MACRO (Cell references are broken): Delete row and sort => Formulas between worksheets don't update
Summary: MACRO (Cell references are broken): Delete row and sort => Formulas between w...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.3.2 release
Hardware: All All
: high major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: 85490
  Show dependency tree / graph
 
Reported: 2013-02-23 12:24 UTC by janekptacijarabaci
Modified: 2014-12-04 16:55 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Test/Example - Loss of linking for cells (*.ods + screenshots). (78.72 KB, application/zip)
2013-02-23 12:24 UTC, janekptacijarabaci 		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 janekptacijarabaci 2013-02-23 12:24:11 UTC 
Created attachment 75406 [details]
Test/Example - Loss of linking for cells (*.ods + screenshots).

1) Open "test-loss-of-linking-for-cells.ods"
2) List1: Button "Delete Martin and Sort by Name"
3) List2: Loss of linking for cells: List1.B11 => List2.B11 (bad: value = 10, correctly: value = 0)
4) List2: Select: Sort by "Number" => Cell List2.B3 = List1.B11, but sort is broken

(After the second sort is OK...)

Thank you very much for the correction.
Comment 1 janekptacijarabaci 2013-02-25 11:58:11 UTC 
LibreOffice:
This bug is in version 4.0.1.1(RC1)+, but also in the eldest version 3.3.0.4.

OpenOffice:
This bug is in version 3.3.0beta1+, but NOT ALSO in the version 3.2.1!
Comment 2 janekptacijarabaci 2013-12-21 11:11:44 UTC 
NOT ALSO in the version 4.1.4.2 (final release)
Comment 3 retired 2013-12-21 14:44:55 UTC 
Thanks for the update. Since we don’t have a specific patch, status is WORKSFORME.
Comment 4 janekptacijarabaci 2013-12-22 08:11:46 UTC 
This bug is in version 4.1.3.2(RC2 + final release), but not also in the version 4.1.4.1(RC1)+.

I think probably likely to be corrected here:
https://bugs.freedesktop.org/show_bug.cgi?id=70815