https://bugs.freedesktop.org/show_bug.cgi?id=85282
Bug ID: 85282
Summary: Wrong references after column suppression
Product: LibreOffice
Version: 4.3.1.2 release
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: jumbo4...@yahoo.fr
Description: part of reference in a formula is not updated after row
suppression, if new cell location is inside reference
Step to reproduce:
1. Create new spreadsheet
2. In H1, insert formula =SUM(C1:G1)
3. Suppress columns A through E in one shot (select them, right click, delete
selected columns)
Expected behavior:
As expected, formula is now in C1.
But formula should be updated to =SUM(A1:B1) as it is with LibO 4.1.6.2
Observed behavior:
Formula in C1 is now =SUM(C1:B1) which is wrong and should deliver an error
(circular reference)
Bug reproduced with:
- Version: 4.2.0.4 Build ID: 05dceb5d363845f2cf968344d7adab8dcfb2ba71
- Version: 4.2.6.2 Build ID: 185f2ce4dcc34af9bd97dec29e6d42c39557298f
- Version: 4.2.8.0.0+
Build ID: da2accb41f902c82436075dc9d0b85a6d7588fa1
TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-10-15_23:40:10
- Version: 4.3.0.0.beta1 Build ID: b7cfa1eab1cb1e94f71d6df6612b73f231d0bf92
- LibO 4.3.1.2
- LibO 4.3.2.2
- LibO 4.3.3.1
- Version: 4.3.4.0.0+
Build ID: 77c6ce66696a997269b9fe4dfed1dc2e51ecd00e
TinderBox: Win-x86@42, Branch:libreoffice-4-3, Time: 2014-10-17_16:12:56
- Master Version: 4.4.0.0.alpha1+
Build ID: a8c24b25fd9fb21097a08a22797bf61b59099ea1
TinderBox: Win-x86@42, Branch:master, Time: 2014-10-21_06:31:17
So resolution of bug 80284 does not solve this one.
Bug NOT reproduced with:
- LibO 4.1.6.2
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
