Launchpad has imported 41 comments from the remote bug at https://bugs.documentfoundation.org/show_bug.cgi?id=137248.
If you reply to an imported comment from within Launchpad, your comment will be sent to the remote bug automatically. Read more about Launchpad's inter-bugtracker facilities at https://help.launchpad.net/InterBugTracking. ------------------------------------------------------------------------ On 2020-10-04T18:13:53+00:00 Sorix-w wrote: Description: Problem: Since 7.0.2.x Calc has a problem with the automatic ReCalculation if contents/values are changed. Is there a new setting somewhere that can cause this? In the settings I have already deactivated the automatic recalculation and reactivated it again incl. restarting LO or the PC. See also ASK Libre Post: https://ask.libreoffice.org/de/question/269302/calc-automatische-berechnung-geht-nicht-mehr/ Actual Results: critical, because not automatically recalculated Expected Results: as in previous version, that all formulas (with activated function) are also reliably recalculated. Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: Version: 7.0.2.2 (x64) Build ID: 8349ace3c3162073abd90d81fd06dcfb6b36b994 CPU threads: 8; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: de-DE Calc: CL also Version: 7.1.0.0.alpha0+ (x64) Build ID: f266feaebea39668392e3a3830e20e4670344658 CPU threads: 12; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: en-GB Calc: CL Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/0 ------------------------------------------------------------------------ On 2020-10-04T18:15:15+00:00 Sorix-w wrote: Created attachment 166068 Demo File from Screenshot Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/1 ------------------------------------------------------------------------ On 2020-10-04T18:15:50+00:00 Sorix-w wrote: Created attachment 166069 Screenshot Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/2 ------------------------------------------------------------------------ On 2020-10-05T07:11:12+00:00 Telesto wrote: Thanks for reporting It's working fine on MacOS Version: 7.0.0.2 Build ID: c01aa64b6c3d89ebe5fe69c28c7adb24eb85249c CPU threads: 4; OS: Mac OS X 10.12.6; UI render: default; VCL: osx Locale: nl-NL (nl_NL.UTF-8); UI: en-US Calc: threaded Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/3 ------------------------------------------------------------------------ On 2020-10-05T09:16:36+00:00 Sorix-w wrote: (In reply to Telesto from comment #3) > Thanks for reporting > > It's working fine on MacOS > Version: 7.0.0.2 > Build ID: c01aa64b6c3d89ebe5fe69c28c7adb24eb85249c > CPU threads: 4; OS: Mac OS X 10.12.6; UI render: default; VCL: osx > Locale: nl-NL (nl_NL.UTF-8); UI: en-US > Calc: threaded you're right. it seems to be only from version 7.0.2.x and higher Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/4 ------------------------------------------------------------------------ On 2020-10-05T13:51:11+00:00 Uwe-8 wrote: Reproduced on: Version: 7.0.2.2, Build ID: 8349ace3c3162073abd90d81fd06dcfb6b36b994 CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: kf5 Locale: en-US (en_US.UTF-8); UI: en-US, Calc: threaded Steps to reproduce. - Add a new value into cell B1 of the attached file - Check value of cell B4 Result: Value of cell B4 doesn't change automatically, while B2 and B3 recalculate Expected Result: B4 autocalculates Reset user profile: Yes Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/5 ------------------------------------------------------------------------ On 2020-10-05T13:53:36+00:00 Uwe-8 wrote: Created attachment 166090 Testcase "Reproduce-Bug-137248.ods" File (as per comment) Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/6 ------------------------------------------------------------------------ On 2020-10-05T15:39:13+00:00 Telesto wrote: (In reply to Uwe Auer from comment #6) > Created attachment 166090 [details] > Testcase "Reproduce-Bug-137248.ods" File (as per comment) Repro Version: 7.1.0.0.alpha0+ (x64) Build ID: 7f16cabf00daa30e9284d2fb2494bd341352c25e CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win Locale: nl-NL (nl_NL); UI: en-US Calc: CL fine in Version: 7.0.0.0.beta1+ (x64) Build ID: 2891e91a513520d68ea2b8c59c14335861a15253 CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win Locale: nl-NL (nl_NL); UI: en-US Calc: CL Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/7 ------------------------------------------------------------------------ On 2020-10-05T21:10:49+00:00 Ming-v-hua wrote: *** Bug 137275 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/8 ------------------------------------------------------------------------ On 2020-10-06T20:35:21+00:00 Telesto wrote: Created attachment 166136 Bibisect log Bisected to: author Luboš Luňák <l.lu...@collabora.com> 2020-09-04 15:51:07 +0200 committer Luboš Luňák <l.lu...@collabora.com> 2020-09-10 11:15:47 +0200 commit 4f36f2ccab6286ec09480caea602c0fa19195736 (patch) tree 0d3156c2f322983fa30d3a6f4600be5102e2718e parent 3f620e74aa00e34f773d97e9480a6532d9e8863e (diff) detect if a cell still needs interpreting after Interpret() https://bugs.documentfoundation.org/attachment.cgi?id=51878 after hard-recalc asserts because of not having cell dependencies non-dirty for threaded calculation. This is because Interpret() actually sometimes returns without computing a value for the cell, e.g. when it backs out because of a need to do iteration. This is handled when Interpret() is called from InterpretTail(), but ScDependantsCalculator does not handle this and considers all cells interpreted, unless it detected a problem. We've already fixed a number of such bugs, and given that there are still problematic corner cases after all this time, add code simply detecting this generic problem and avoiding threading in that case, with a SAL_WARN. This does not fix the problem itself, but at least now it's handled. https://cgit.freedesktop.org/libreoffice/core/commit/?id=4f36f2ccab6286ec09480caea602c0fa19195736 Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/9 ------------------------------------------------------------------------ On 2020-10-06T20:36:12+00:00 Telesto wrote: Adding CC: to Luboš Luňák Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/10 ------------------------------------------------------------------------ On 2020-10-08T06:18:52+00:00 Telesto wrote: *** Bug 137312 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/11 ------------------------------------------------------------------------ On 2020-10-12T10:25:49+00:00 Ming-v-hua wrote: *** Bug 137415 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/12 ------------------------------------------------------------------------ On 2020-10-13T19:26:01+00:00 Eike Rathke wrote: This actually is a repaint problem, Pgdn and PgUp or Shift+Ctrl+R to redraw the grid displays the recalculated value. The commit mentioned somewhere forgets to (re)set a changed flag, a debug version in terminal displays sc/source/core/data/column4.cxx:1695: Internal error, cell 2!R3C3 failed running Interpret(), not allowing threading so it hits exactly that changed code. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/13 ------------------------------------------------------------------------ On 2020-10-13T21:13:40+00:00 Eike Rathke wrote: Taking. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/14 ------------------------------------------------------------------------ On 2020-10-13T21:16:35+00:00 Eike Rathke wrote: Or the dirty cell is interpreted during the next repaint.. however.. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/15 ------------------------------------------------------------------------ On 2020-10-14T09:21:20+00:00 Libreoffice-commits wrote: Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/59f86333f3fce091177d1cfb9363aa81686aa497 Resolves: tdf#137248 Fix wrong condition breaking non-group interpret It will be available in 7.1.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/16 ------------------------------------------------------------------------ On 2020-10-14T09:21:48+00:00 Eike Rathke wrote: Pending review https://gerrit.libreoffice.org/c/core/+/104289 for 7-0 Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/17 ------------------------------------------------------------------------ On 2020-10-14T14:34:56+00:00 Vlb1 wrote: Will this issue also be resolved for 7.0. *? Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/18 ------------------------------------------------------------------------ On 2020-10-14T17:35:14+00:00 Uwe-8 wrote: *** Bug 137467 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/19 ------------------------------------------------------------------------ On 2020-10-14T17:40:54+00:00 Telesto wrote: (In reply to VLB from comment #18) > Will this issue also be resolved for 7.0. *? Of course ;-). That's the essence of comment 17 Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/20 ------------------------------------------------------------------------ On 2020-10-15T07:56:24+00:00 Libreoffice-commits wrote: Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-0": https://git.libreoffice.org/core/commit/701008631ee257b4c7714ac9e2689c5ecc45bff8 Resolves: tdf#137248 Fix wrong condition breaking non-group interpret It will be available in 7.0.3. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/21 ------------------------------------------------------------------------ On 2020-10-16T07:35:10+00:00 Mikekaganski wrote: *** Bug 137518 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/22 ------------------------------------------------------------------------ On 2020-10-16T07:35:18+00:00 Mikekaganski wrote: *** Bug 137515 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/23 ------------------------------------------------------------------------ On 2020-10-16T07:35:37+00:00 Mikekaganski wrote: *** Bug 137521 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/24 ------------------------------------------------------------------------ On 2020-10-17T15:16:51+00:00 Aron Budea wrote: *** Bug 137557 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/25 ------------------------------------------------------------------------ On 2020-10-17T15:21:26+00:00 Aron Budea wrote: *** Bug 137552 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/26 ------------------------------------------------------------------------ On 2020-10-17T16:15:57+00:00 Aron Budea wrote: *** Bug 137557 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/27 ------------------------------------------------------------------------ On 2020-10-17T18:13:00+00:00 Aron Budea wrote: *** Bug 137540 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/28 ------------------------------------------------------------------------ On 2020-10-17T18:15:11+00:00 Aron Budea wrote: *** Bug 137493 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/29 ------------------------------------------------------------------------ On 2020-10-17T18:16:42+00:00 Aron Budea wrote: *** Bug 137060 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/30 ------------------------------------------------------------------------ On 2020-10-19T10:54:55+00:00 Andristf wrote: Downloaded 7.0.3 Build b6be59636a142f98970d39aadff8445e1d0c39b7 This fixed my problem with not automatically updating some cells. Many thanks Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/31 ------------------------------------------------------------------------ On 2020-10-19T11:11:13+00:00 Stefan-lange-ka-d wrote: see comment 4 of bug 137060 (succesful test with LOdev 7.0.3 and LOdev 7.1.0): The problem is solved by the patch! Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/32 ------------------------------------------------------------------------ On 2020-10-19T14:27:57+00:00 Xiscofauli wrote: Setting to VERIFIED Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/33 ------------------------------------------------------------------------ On 2020-10-19T17:45:03+00:00 Miguelangelrv wrote: *** Bug 137600 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/37 ------------------------------------------------------------------------ On 2020-10-19T17:54:01+00:00 Eike Rathke wrote: *** Bug 137599 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/39 ------------------------------------------------------------------------ On 2020-10-20T04:53:02+00:00 Ming-v-hua wrote: *** Bug 137606 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/41 ------------------------------------------------------------------------ On 2020-10-21T15:39:40+00:00 Xiscofauli wrote: *** Bug 137659 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/42 ------------------------------------------------------------------------ On 2020-10-22T14:19:25+00:00 Xiscofauli wrote: *** Bug 137565 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/43 ------------------------------------------------------------------------ On 2020-10-23T13:16:23+00:00 Eike Rathke wrote: *** Bug 137706 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/44 ------------------------------------------------------------------------ On 2020-10-23T16:52:20+00:00 Sorix-w wrote: the failure seems to be fixed for me, thx a lot ☺ AutoCalc is working for me. will do some more test under different scenarios. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Tested under: Version: 7.0.3.1 (x64) Build ID: d7547858d014d4cf69878db179d326fc3483e082 CPU threads: 12; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: de-DE Calc: CL ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1900454/comments/46 ** Changed in: df-libreoffice Status: Unknown => Fix Released ** Changed in: df-libreoffice Importance: Unknown => Critical -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1900454 Title: Calc doesn't recalculate formulas on cell content changes Status in LibreOffice: Fix Released Status in libreoffice package in Ubuntu: Fix Committed Bug description: libreoffice-calc 1:7.0.2-0ubuntu1 (Groovy) The problem is better explained via steps to reproduce: 1. Start calc; you'll get a new spreadsheet. 2. Fill in the following in cells A1-A3: A1: 1 A2: =A1+1 A3: =A1-1 As expected: A2 is calculated as 2, A3 is calculated as 0. 3. Change A1 to 2 and press enter. A2 is autocalculated to 3, but A3 remains at 0 (wrong!). Now for the fun part: switch to a different application so LibreOffice window loses focus, the put it back in focus. A3 is now recalculated to 1. (Partially taken from: https://ask.libreoffice.org/en/question/271324/calc-v7022-cell- autocalculate-not-working-while-window-has-focus/) To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1900454/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
