Description: Hello, When I open the file in LibreOffice Calc, whether as ODS or XLSX it hangs up when opening and I need to wait while it is frozen. Then when I want to change the sheet to another, it simply hangs and I need to wait for so long again. Saving the file is a nightmare as it hangs to the point that sometimes I need to kill the LibreOffice Calc or simply restart. I really hate to say this, but when I use MS Office 2019 Pro Plus 64Bit, it just opens, asks to update from linked sources, I answer yes, in a wink it updates, then it all works super convenient. Saving the document is as fast as everything else with MS Office Excel. Good to know: I use LibreOffice 6.4.1.2 LibreOffice runs on Solus Linux 4.1 The file reads from 3 linked source files of data. The file has many calculations in each row. The file has almost 1,000 rows. I tried to create the file in ODS format, the same result. Create it in XLSX format, again the same. I tried to have the source files as ODS and then XLSX still the same. Until this problem is solved, I switched to Excel as I cannot afford the loss of time. My PC specs: Intel® Core™ i7-8550U CPU @ 1.80GHz × 8 CPU 8 GiB RAM SSD 256 GB Drive Intel® UHD Graphics 620 (Kabylake GT2) GPU I am ready to test any configuration, send more info, or try alpha or beta releases. Thanks for a great product. Khaldoun Steps to Reproduce: 1. Download the ZIP file with Main file and Data sources files. All files are in XLSX format. ZIP File link: xyz 2. Place all files: Sub-All.xlsx, Ren-All.xlsx, Unsub-All.xlsx, and "Main.xlsx" in the same folder. 3. Open the "Main.xlsx" file in Calc. 4. Wait until the file is opened, then try to work on it. Actual Results: The file is very very slow and it is actually not usable. Expected Results: The file should open quickly and perform normally. Reproducible: Always User Profile Reset: No Additional Info: The file should load fast. Hate to see Excel doing better and be forced to use it instead of LibreOffice.
Please give a try to 6.4.3. If you still reproduce this, please attach an example file sanitized (see https://wiki.documentfoundation.org/QA/Bugzilla/Sanitizing_Files_Before_Submission) Finally, you must know that if there are a lot of comments, it will slow down LO. This point needs a big refactoring.
The files are located in Google Drive at: https://drive.google.com/file/d/1d50stEIinqSNTeYGX59gZzoSM9B-Tali/view?usp=sharing This is the main file and the 3 linked source files. They should be in the same folder. I am sure you can figure it out if need to fix the links.... let me know if any furthter details are needed.
Hello, I appreciate to confirm when the file is downloaded in order to close the share link to the file.
(In reply to Julien Nabet from comment #1) > Please give a try to 6.4.3. > If you still reproduce this, please attach an example file sanitized (see > https://wiki.documentfoundation.org/QA/Bugzilla/ > Sanitizing_Files_Before_Submission) > > Finally, you must know that if there are a lot of comments, it will slow > down LO. This point needs a big refactoring. I will try this. I will install 6.4.3 on Windows and give it a try. Thanks.
(In reply to Khaldoun from comment #3) > Hello, I appreciate to confirm when the file is downloaded in order to close > the share link to the file. Zip file retrieved. On pc Debian x86-64 with master sources updated today, I confirm it's long to just open Main.xlsx file
(In reply to Julien Nabet from comment #5) > (In reply to Khaldoun from comment #3) > > Hello, I appreciate to confirm when the file is downloaded in order to close > > the share link to the file. > > Zip file retrieved. > > On pc Debian x86-64 with master sources updated today, I confirm it's long > to just open Main.xlsx file Thanks for confirmation. I will close the drive link.
Version: 7.0.0.0.alpha1+ (x64) Build ID: 30356cdb3581bc9e9118ef3dd2f3162d9256c3b6 CPU threads: 4; OS: Windows 10.0 Build 19608; UI render: Skia/Raster; VCL: win; Locale: es-ES (es_ES); UI: en-US Calc: CL Half a minute to open Main. But there are a couple of linked files not available. Lot of formulas with VLOOKUP on linked files. 45 charts. For me takes to much show the charts when selecting one or going to their sheet.
Created attachment 160893 [details] Flamegraph (gen rendering) Here's a Flamegraph retrieved on pc Debian x86-64 with master sources updated today + gen rendering.
Noel: thought you might be interested in this one. It's about slowliness for opening xlsx file and not related to comments. I attached a Flamegraph. Also, I used gen rendering to avoid all accessibility stuff with gtk3. If needed, I can attach other Flamegraph in order to: - test a patch - test another action delay (when switching between sheets, save as another file...)
(In reply to m.a.riosv from comment #7) > Version: 7.0.0.0.alpha1+ (x64) > Build ID: 30356cdb3581bc9e9118ef3dd2f3162d9256c3b6 > CPU threads: 4; OS: Windows 10.0 Build 19608; UI render: Skia/Raster; VCL: > win; > Locale: es-ES (es_ES); UI: en-US Calc: CL > > Half a minute to open Main. > But there are a couple of linked files not available. > Lot of formulas with VLOOKUP on linked files. > 45 charts. > > For me takes to much show the charts when selecting one or going to their > sheet. I provided all linked files. Can you provide more info?
I am receiving a request to access the sample files I provided from Willem Jan Harkink (wj.harkink@gmail.com)
(In reply to Khaldoun from comment #11) > I am receiving a request to access the sample files I provided from Willem > Jan Harkink (wj.harkink@gmail.com) Is he from LibreOffice team?
(In reply to Khaldoun from comment #4) > (In reply to Julien Nabet from comment #1) > > Please give a try to 6.4.3. > > If you still reproduce this, please attach an example file sanitized (see > > https://wiki.documentfoundation.org/QA/Bugzilla/ > > Sanitizing_Files_Before_Submission) > > > > Finally, you must know that if there are a lot of comments, it will slow > > down LO. This point needs a big refactoring. > > I will try this. I will install 6.4.3 on Windows and give it a try. Thanks. I tried 6.4.3 and it is still as slow as in 6.4.1.2
Hello, I can share directly the documents with wj.harkink@gmail.com if you confirm he is part of the LibreOffice community. Thanks you K
Hello LIbreOffice team... Is there any requirement from my side? Is there any consideration for this issue to be analyzed and a root cause is identified. I am confident that fixing such an issue means a serious advantage for LibreOffice. I am sure you know better. Looking for your answer. Regards, K
This is a problematic report because the test file is not publicly available like it should be. If you can't share it as-is, then anonymise it and verify the problem still exists: https://wiki.documentfoundation.org/QA/Bugzilla/Sanitizing_Files_Before_Submission#Sanitize_file_text
Hello, Thanks for the feedback.. Yes, I agree it is a problematic report. But this is the only reason to have Windows+Office on my machine! I believe this can be the situation for many many more people. So: - Will work on setting up an anonymized copy. - Also, because the main file is reading from other source data files, then placing the files in a wrong way can make the reported issue irreproducable. Given the file is very slow, arranging for an anonymized version is going to take some time. Not less than a week. Also, to make sure the main file reads properly from the linked data files, I need to know your system (or the system of the person who will work on this). Is it Windows? Linux? Mac? This issue is the only reason I still have Windows+Office on my machine! Looking for your reply Regards, K
Update The issue is still exists on version: Version: 7.1.1.2 / LibreOffice Community Build ID: 10(Build:2) CPU threads: 8; OS: Linux 5.11; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
(In reply to Khaldoun from comment #17) > Also, to make sure the main file reads properly from the linked data files, > I need to know your system (or the system of the person who will work on > this). Is it Windows? Linux? Mac? You don't need to worry about this detail :) Thanks for considering the anonymisation. If you want to confirm every important bit of info is cleaned, you can email the files to me before making them public.
Just updating that this issue is still there as I tested the same file on 7.1.4.2
Version must correspond to the earliest one, not the newest one.
If I'm not wrong, there is no sample file to test with.
I set Needinfo for anonymized file from reporter or Julien.
Dear Khaldoun, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Dear Khaldoun, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-FollowUp