https://bugs.freedesktop.org/show_bug.cgi?id=81559
Priority: medium
Bug ID: 81559
Assignee: [email protected]
Summary: EDITING: Undo function confuses formula calculation
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.2.5.2 release
Component: Spreadsheet
Product: LibreOffice
Problem description:
If I delete a cell content that is used in a formula of another cell and undo
the deletion the formula does not recalculate even if forced to do so with F9
or after reopening the document.
Steps to reproduce:
1. Open a new spreadsheet.
2. Type in 3 values in one column, e.g. 1,5,8 in A1 - A3
3. In cell A4 type: =SUM(A1:A3). The cell displays 14.
4. Now delete the contents of e.g. cell A2 (5). A4 correctly shows 9.
5. Now undo the deletion using the undo-function.
Current behavior:
A4 continues showing 9 but should be 14 again. Even if closing and reopening
the document or recalculating with F9 the wrong value stays until you reedit
one of the cells.
This is a showstopper since in large tables you cannot ensure correct values in
all formulas!
Expected behavior:
After undoing the deletion A4 should show 14 again.
Additional info: this error does not appear in OpenOffice.
Operating System: Windows 7
Version: 4.2.5.2 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
