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.