Problem description: Steps to reproduce: 1. Type 2 in A1 2. In A2 type '=A1*2' 3. The result returned in A2 is 4 4. Now delete the value in A1 and the value in A2 is not changed. 5. Pressing F9 will not update. Only CTRL+SHIFT+F9 is updating. Auto calculate is active. Current behavior: The value is not updated Expected behavior: The value should be updated Platform (if different from the browser): Browser: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:18.0) Gecko/18.0 Firefox/18.0
Reproducible for me under Win7.
Regression
Sorry for duplicated comments...
One for me. Is another case of the broadcaster lifetime problem. I have to spend some time to figure out again when they should be deleted and when the broadcaster has to be transfered to the temporary note cell.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=3fa50ac35b6a56ae9628b0310cbf0eb7b4634736 use correct cell for broadcasting, fdo#55059 The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "libreoffice-3-6": http://cgit.freedesktop.org/libreoffice/core/commit/?id=44946ef77dd14d139fc799a25c4e2b26c772ce9f&g=libreoffice-3-6 use correct cell for broadcasting, fdo#55059 It will be available in LibreOffice 3.6.3. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "libreoffice-3-6-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=7615e7ea047291f9c65ee32f4aaf615e2efbff21&g=libreoffice-3-6-2 use correct cell for broadcasting, fdo#55059 It will be available already in LibreOffice 3.6.2. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
*** Bug 55314 has been marked as a duplicate of this bug. ***
The value in A2 is updated,when changing the value in A1. If you delete the content in A1, A2 is not updated.
Sorry, The version was not updated. Works as supposed.
Tested for build: libreoffice-3-6~2012-10-19_19.11.54_LibO-Dev_3.6.4.0_Win_x86_install_en-US.msi Steps: 1. Type 2 in A1 2. In A2 type '=A1*2' 3. The result returned in A2 is 4 4. Deleting value in A1 results in value in A2 being set to 0, as should be.
Working in Version 3.6.2.2 (build-id: da8c1e6) A more nested example of the same problem. A B C 1 2 4 =A1/B1 2 5 =B1*C1 Value in B2 = 2 Now delete C1 ... B2 does not change, still shows value 2 Only when I actually enter C1, select the formula, delete it and press Enter ... then B2 is updated correctly. (Of course, same problem in masterbuild)
@Cor: You should know better than to reopen a bug report that has been verified. Your problem is totally different and needs a different fix. Please opne a new bug report for the new problem.
(In reply to comment #15) > @Cor: You should know better than to reopen a bug report that has been > verified. Your problem is totally different and needs a different fix. > Please opne a new bug report for the new problem. Please do not hit me ;-) Sorry, in my ignorance I assumed it was a sort of the same underling problem. New issue 56278