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
