Created attachment 81992 [details] Screenshot after enter the formula. Win7x64 Ultimate Version: 4.2.0.0.alpha0+ Build ID: 6f86d931b4266d00fec75c0124ac9fc3026a4f1b TinderBox: Win-x86@6, Branch:master, Time: 2013-07-02_23:36:17 In a new spreadsheet. Menu/Tools/Cell contents - Disable AutoCalculate In any cell enter: =+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1 Cell remains in blank, do not show the formula result, and the part of the formula over other cells while editing, it is not cleared. Works as always in: Version 4.0.4.2 (Build ID: 9e9821abd0ffdbc09cd8c52eaa574fa09eb08f2)
I reproduced this bug. Confirmed bug in Version: 4.2.0.0.alpha0+ Build ID: 6372309a0d285f4a176dbcded3f18b72220e123 Confirmed not a bug in Version 4.0.4.2 (Build ID: 9e9821abd0ffdbc09cd8c52eaa574fa09eb08f2) Used WIN 8 x86_64
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=2212051e792cb5f51f4191afe83c85fc3730a087 resolved fdo#66564 calculate formula cell once if AutoCalc disabled 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.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=039dadf3b48484ba5d1fc71de5561288e6b7c5cb&h=libreoffice-4-2 resolved fdo#66564 calculate formula cell once if AutoCalc disabled It will be available in LibreOffice 4.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 65191, looks a dupe like a of this one?
Yup, but please don't remove the target from Whiteboard ;-)
*** Bug 65191 has been marked as a duplicate of this bug. ***
Pending review for 4-1 at https://gerrit.libreoffice.org/6964 for 4-1-4 at https://gerrit.libreoffice.org/6965
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-4-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=b0a18ae31de70fbd44bf9677ff0f9d01aad5588f&h=libreoffice-4-1 resolved fdo#66564 calculate formula cell once if AutoCalc disabled It will be available in LibreOffice 4.1.5. 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.
Thanks Eike.
Works fine in: Version: 4.2.0.0.beta2+ Build ID: 039dadf3b48484ba5d1fc71de5561288e6b7c5cb TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2013-12-06_22:54:58
Works also in: Version: 4.1.5.0.0+ Build ID: cb4225144f1fff44f9bb972fe06f51524da11b8 Version: 4.3.0.0.alpha0+ Build ID: c6fe5c6f371328cb6cf61d68f016a04f8b635a48 TinderBox: Win-x86@39, Branch:master, Time: 2013-12-08_02:58:23
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-4-1-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=549310b41fe732283d82dbd3eb313f3c93f15de8&h=libreoffice-4-1-4 resolved fdo#66564 calculate formula cell once if AutoCalc disabled It will be available already in LibreOffice 4.1.4. 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.
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.