| Summary: | MACRO (Cell references are broken): Delete row and sort => Formulas between worksheets don't update | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | janekptacijarabaci |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | major | ||
| Priority: | high | ||
| Version: | 4.1.3.2 release | ||
| Hardware: | All | ||
| OS: | All | ||
| See Also: |
https://bugs.freedesktop.org/show_bug.cgi?id=80314 https://bugs.freedesktop.org/show_bug.cgi?id=81542 |
||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 85490 | ||
| Attachments: | Test/Example - Loss of linking for cells (*.ods + screenshots). | ||
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! NOT ALSO in the version 4.1.4.2 (final release) Thanks for the update. Since we don’t have a specific patch, status is WORKSFORME. 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 |
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.