Created attachment 132284 [details] Test .ODS file with bug Hi, In an calc file (with filter and freeze column is enable) if i select a column (click in the header) the selection is very slow, like a delay of 1 second. Same problem also appear when i select a few columns with my mouse (left click down and move the mouse to the right) The document become unusable. And with a real production file with something like 30 columns and 1000 rows, all freeze for many seconds.. Please see my test file in attachment with different tabs. Tabs: Test-1 -> freeze column enable / Filter disable -> RESULT: OK Test-2 -> freeze column enable / Filter enable -> RESULT: FAIL Test-3 -> freeze column disable / Filter enable -> RESULT: OK Appear on: 5.1.x 5.2.x 5.3.x (not tested) I'm on Ubuntu 16.04 / i7 / 8Go RAM. I'm not tested if this problem appear on Windows too but i suppose that yes. Thanks, Michael
I can't reproduce. Version: 5.3.2.1 (x64) Build ID: 7f6693c08cc110b9721245fc4bd4f1712e0c086c CPU Threads: 4; OS Version: Windows 6.19; UI Render: default; Layout Engine: new; Locale: es-ES (es_ES); Calc: group
Created attachment 132309 [details] Video for bug 106872 Hi, Just made a little video (.mp4) with my problem. See the second tabs. It exist a big delay when selecting columns or just click and sometimes it become unusable (gray screen) and cpu overload for some seconds... Version: 5.2.5.1 Build ID: 1:5.2.5~rc1-0ubuntu1~xenial0 Threads CPU : 4; Version de l'OS :Linux 4.8; UI Render : par défaut; VCL : gtk2; Locale : fr-CH (fr_CH.UTF-8); Calc: group
Reproducing your steps I can't reproduce. Please test on/off OpenCL on Menu/Tools/Options/LibreOffice/View
I tested on 3 different pc on Linux (ubuntu 16.04). Problem is the same. More tests: - I just tested the new release 5.3.2.2 on Ubuntu 16.04 and problem persist. - I just tested (5.2.6.2) on Windows 10 and this problem is not present. So it appear only on linux? I have not tested on Mac. Enable/Disable OpenCL or OpenGL change nothing. ***** FAIL ****** Version: 5.2.5.1 Build ID: 1:5.2.5~rc1-0ubuntu1~xenial0 Threads CPU : 4; Version de l'OS :Linux 4.8; UI Render : par défaut; VCL : gtk2; Locale : fr-CH (fr_CH.UTF-8); Calc: group Version: 5.3.1.2 Build ID: 1:5.3.1-0ubuntu1~xenial0 Threads CPU : 4; Version de l'OS :Linux 4.8; UI Render : par défaut; VCL : gtk3; Moteur de mise en page : nouveau; Locale : fr-CH (fr_CH.UTF-8); Calc: group Version: 5.3.2.2 Build ID: 1:5.3.2~rc2-0ubuntu1~xenial0 Threads CPU : 4; Version de l'OS :Linux 4.8; UI Render : par défaut; VCL : gtk2; Moteur de mise en page : nouveau; Locale : fr-CH (fr_CH.UTF-8); Calc: group ***** OK ****** Version: 5.2.6.2 (x64) Build ID: a3100ed2409ebf1c212f5048fbe377c281438fdc Threads CPU : 2; Version de l'OS :Windows 6.19; UI Render : par défaut; Locale : fr-CH (fr_CH); Calc: group
Created attachment 132637 [details] Callgrind output from 5.4 I repro with GTK3, but not with KDE4. Arch Linux 64-bit, KDE Plasma 5 Version: 5.4.0.0.alpha0+ Build ID: d69e6321fbb2c9f5b4d30890074a230ee6b39d2d CPU threads: 8; OS: Linux 4.10; UI render: default; VCL: gtk3; Locale: fi-FI (fi_FI.UTF-8); Calc: group Built on April 17th 2016
I suspect this GTK bug to also block all cell calculation in my sheet after some minutes / hours of usage. We have an inventory file of products (~2000 x ~30), with autofilter, freeze rows and columns enable. We play a lot with autofilter / standard filter. After long minutes of usage (add / remove filter, scroll, update cell values, hide or show columns...) all calculated cell (SUM) are no more refreshed and updated even if i press F9 for recalculation.. The only solution is to restart libreoffice and repoen my file. This is a very dangerous situation... Anyway.. if someone can fix this bug #106872 quickly, i would be happy ;)
Surely doing a hard recalc solves your calculation issues. [Shift+Ctrl+F9]
I think this is an accessibility enabled libreoffice vs a non accessibility enabled libreoffice rather than gtk3 vs gtk2. There seems to be a very excessive amount of selection tracking going on and the filtering is expensive when querying the selection via accessibility
There's also an irony in that the results of the slow filtering are all thrown away as we're only interested in shapes at this point
Caolán McNamara committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=998e3d5cef63cb9c512737bce65519f5a86ba019 Related: tdf#106872 amount of a11y selection listeners constantly grows It will be available in 6.0.0. 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.
Caolán McNamara committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=221dae68df80298e81e6e6549636f3528f5c8bc3 Related: tdf#106872 factor out getting selected shapes It will be available in 6.0.0. 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.
Above only stops things getting worse over time. https://gerrit.libreoffice.org/#/c/40496/ is my suggestion to skip all the slow path by just querying for selected shapes rather than all selection which causes the slow down when there is a filter in place
Caolán McNamara committed a patch related to this issue. It has been pushed to "libreoffice-5-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=1d9a30bac4ba69ddee34f40427ba24a4d83a1f72&h=libreoffice-5-4 Related: tdf#106872 amount of a11y selection listeners constantly grows It will be available in 5.4.1. 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.
Caolán McNamara committed a patch related to this issue. It has been pushed to "libreoffice-5-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=09716380e12ac2b7119afff20033ce2e7929ebd8&h=libreoffice-5-3 Related: tdf#106872 amount of a11y selection listeners constantly grows It will be available in 5.3.6. 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.
Caolán McNamara committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=192d97cdf091af08a492416824918ea447bfb16f Resolves: tdf#106872 only request selected shapes It will be available in 6.0.0. 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.
Caolán McNamara committed a patch related to this issue. It has been pushed to "libreoffice-5-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=1e796e4471ceb577b6a5bd577b2571231ae6fcf1&h=libreoffice-5-4 Resolves: tdf#106872 only request selected shapes It will be available in 5.4.1. 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.
Caolán McNamara committed a patch related to this issue. It has been pushed to "libreoffice-5-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=5e2ffa0b2eb7623d0c9ed37c30caea1452810646&h=libreoffice-5-3 Resolves: tdf#106872 only request selected shapes It will be available in 5.3.6. 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.