https://bugs.freedesktop.org/show_bug.cgi?id=76431
Priority: medium Bug ID: 76431 Assignee: libreoffice-bugs@lists.freedesktop.org Summary: EDITING: computed cells content not refreshed when changing source values Severity: normal Classification: Unclassified OS: Linux (All) Reporter: nathael.paj...@ed3l.fr Hardware: Other Whiteboard: BSA Status: UNCONFIRMED Version: 4.1.5.3 release Component: Spreadsheet Product: LibreOffice Created attachment 96145 --> https://bugs.freedesktop.org/attachment.cgi?id=96145&action=edit The file with the bug. Hi, I have some computed cells content which is not refreshed when changing source values, even when using F9 or the Tools->Cell content menu. Automatic computing is checked, and checking/unchecking it does not fix the problem. Formula is "=Bilan.D57" Same formula in another cell gives the right result (copy of source cell) Even when using "copy paste" of formula from cell where it's not working. This happens only when the value in the source cell (Bilan.D57) is modified due to changes in the current sheet, and I made no changes in other sheets since opening the document. Value in cell "Bilan.D57" is a computed value and is OK when I go to sheet "Bilan". The value is not updated if I switch to another sheet and come back with no modifications made on the other sheet. If I do so, the value is updated on the next modification on current sheet. The value is updated again as soon as I make a modification in another sheet which changes the source cell value (Bilan.D57), you can try for example Mars.P17 Cell with the problem is 'Compte ED3L'.H3 In the attached file it displays 0,00 while Bilan.D57 is 1986,17 In the attached file you can modify cells in sheet 'Compte ED3L' collumns E and F, these should modify the amount in H3 It changes the amount in "Bilan.D57" but not in H3 of current sheet. Thanks. Operating System: Debian Version: 4.1.5.3 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