https://bugs.freedesktop.org/show_bug.cgi?id=82295
Priority: medium
Bug ID: 82295
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: EDITING: functions do not recalculate after undo
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: edleij...@engineer.com
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.3.0.4 release
Component: Spreadsheet
Product: LibreOffice
Problem description:
When deleting a value of a cell that is used in a function, the function result
is correctly updated. However when undo is applied, the value in the cell is
restored but the function result is not updated. Pressing F9 to recalculate
does not change the result, only editing the function by removing and re-typing
one character gives correct results again.
The behaviour is correct when a cell is cut, but not when its contents are
deleted...
Steps to reproduce:
1. create a spreadsheet with values 1 to 10 in a row
2. add a max() function (e.g. =max(A1:A10) ). Works also with min() and
average() functions, I have not tested other functions.
3. delete the value from the cell containing value 10 (cell A10)
4. the result of the max() function is now correctly recalculated to "9"
5. now press undo / CTRL+Z
6. the result of the max() function remains at "9" while it should be 10.
Current behavior:
Function is not recalculated after pressing undo following a delete action.
Expected behavior:
Function(s) should recalculate
Operating System: Windows 7
Version: 4.3.0.4 release
--
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
