Download it now!
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 treegraph
 
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

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