Created attachment 159039 [details] Test xlsx file Steps to reproduce: 1. Open the attached xlsx document. 2. Try to click to second sheet tab (to switch to that tab). --> Very slow switching to the 2nd tab. After successful switch, the soffice.bin process eats 3.6 GB of my RAM, while my system RAM is 8 GB. 3. After successfully switched to the second tab, try to click some cells. --> Very slow navigating between between cells. Reproduced in Version: 7.0.0.0.alpha0+ Build ID: f6f37e3341f2a3ad292af1a923dbc33d81e439c9 CPU threads: 4; OS: Linux 5.5; UI render: default; VCL: gtk3; Locale: zh-CN (zh_CN.UTF-8); UI-Language: en-US Calc: threaded And in 6.3.5.2 Fedora 31 64. Step 2 and 3 is fast in MSO running in my VirtalBox WinXP guest machine with only 1 GB total RAM.
This issue was originally reported on the LibreOffice Chinese discussion forum: https://bbs.libreofficechina.org/forum.php?mod=redirect&tid=2421
Opening the file there is a message that it exceeds the columns number limits. And file crash LibreOffice when I try to go to the second sheet.
Trying loading the document is already quite slow, more than (for a 480KB file on pc with Ryzen 2600 + 32GB) real 0m16,036s user 0m15,769s sys 0m1,313s + I got this warning: Warning loading document ...: The data could not be loaded completely because the maximum number of columns per sheet was exceeded.
Created attachment 159095 [details] perf flamegraph (when loading the file) Here's a Flamegraph retrieved on pc Debian x86-64 with master sources updated today. It corresponds to loading only. I'll attach another Flamegraph about the switching part.
Created attachment 159096 [details] Flamegraph (when switching sheet) I must say that I use gtk3 so with all accessibility mechanism which seems to slow down things.
Tab switching is not very slow for me and memory use does not explode. Kevin: please re-test Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 9c930c4f3109d123c0831d0fcecf9c8b32e5bbc7 CPU threads: 2; OS: Windows 10.0 Build 19042; UI render: default; VCL: win Locale: fi-FI (fi_FI); UI: en-US Calc: threaded
(In reply to Buovjaga from comment #6) Switching to the 2nd tab is still slow for me in Version: 7.3.4.2 / LibreOffice Community Build ID: 30(Build:2) CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: zh-CN (zh_CN.UTF-8); UI: zh-CN Ubuntu package version: 1:7.3.4-0ubuntu0.22.04.1 Calc: threaded and Version: 7.4.0.0.beta1+ / LibreOffice Community Build ID: 6ea86593851c731e2e2b969e458255e4159c80d9 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: zh-CN (zh_CN.UTF-8); UI: zh-CN Calc: threaded