Description: I am utilizing librecalc 7.3.7.2 on a Dell precision 7770, below are the specifics i9 12950 HZx24 32 GB dual video cards Ubuntu 22.04.2 LTS Version: 7.3.7.2 / LibreOffice Community Build ID: 30(Build:2) CPU threads: 24; OS: Linux 5.19; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.2 Calc: threaded I have been attempting to work with a workbook, which I have been utilizing for 8 years in excel 2010. The workbook was 6.7MB in size, and I have now reduced to 4.7 to get it to even function in Libre. It contains 4 worksheets, following details: worksheet rows columns 1 3361 GK 2 772 X 3 772 AO 4 892 AZ As I said this workbook was originally handled in excel, utilizing a i7 dell precision, (5 years old), Windows 10. I was starting to see some lag on that machine. I made the transition to Ubuntu, I have been utilizing linix on my servers not for 10 years, and I have started moving all my desktops to Ubuntu, got tired of Micosoft. I am also attempting to move all my MS office to Libre. This spreadsheet from the start has been very troublesome on this new machine within the Ubuntu and Libre environment. At times, I have waited up to 5 minutes after positioning the cursor to be able even enter anything in a cell. Watching the CPU usage in TOP, I have seen it go as high as 163%. Since I transitioned the workbook from excel to Libre and ODS, I decided to recreate the workbook and rewrite all of the formulas and links within the workbook. This has helped but the workbook is still very slow and I still see the Soffice+ module jump to over 100% CPU usage, just by position a cursor within the worksheet, and waiting before I can even make an entry or do anything. What is interesting is I have saved the workbook and moved it to a Dell precision T1700 I3-4160 3.6 Ghz 4 GB ram Windows 10 pro 64 bit machine. When I open it with Libre 7.5, I see almost no lag and it functions fine. If I save it in .xlsx format and open it on a Win10 machine with 2010 Excel, it runs fine. It is my guess that the issue is with Libre and Ubuntu 22.04 LTS. Last night, uninstalled and reinstalled my complete Libre package Please advise of how this can be rectified. Kent Steps to Reproduce: 1. rebuild workbook 2. reinstalled libre 3. Actual Results: program is slow, almost unusable within the Ubuntu 22.04LTS environment Expected Results: Function with out any slowdown and locking up Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Linux (All) OS is 64bit: yes Version: 7.3.7.2 / LibreOffice Community Build ID: 30(Build:2) CPU threads: 24; OS: Linux 5.19; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.2 Calc: threaded
Could you give a try to LO 7.4.6 by using this repo https://launchpad.net/~libreoffice/+archive/ubuntu/libreoffice-still or brand new 7.5.2 by using this repo: https://launchpad.net/~libreoffice/+archive/ubuntu/ppa ?
I will give the 7.5.2 first and let you know what occurs. Thank you for the response Kent
[Automated Action] NeedInfo-To-Unconfirmed
That help a little bit, but a very little bit. The system still hangs up, I waited 3 minutes, after positioning my cursor within the spreadsheet, and received a "force quit/wait" message. cpu usuage is still reporting 99 to 120%, and locks up all my spreadsheets I have open. Move the spreadsheets to office 2010, and I have not delay. Librecalc works great on smaller spreadsheets, but ones that are really having to do a lot of vlookups, matches, and with any size. It is following flat on its face. And this is on a i9 12,950 HZ machine
Ok thank you for the feedback. I got no hint here so uncc myself.
What I find interesting is that as I search the for a resolution to this issue, I have finding references to it going back to 2010. I have found numerous, attempts at different settings and how to make libre office to work on a linux computer, even into 2022, and I have tried most of these suggestions. I would think that over the last 13 years, someone would have attempted to correct this Bug. If you want sample spread sheets, I would be glad to send to you. Actually today, I created a new spread sheet, 8 columns, 700 rows. I cut and pasted an equations in, =if(e2="","",e2*d2). That locked the entire program up for 10 minutes. That equation was copied into all 700 rows. The only way I could get it to free up the system was to do a "pkill soffice.bin". stop the program, and restart. I then copied all of the data into a new spreadsheet, rewrote the equation, and saved under another name. Someone really needs to address this, because it basically makes librecalc, unusable.
Please attach an example document. Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the document.
Created attachment 187300 [details] zipped version of .ods file we have having issues with slow here is a copy of the spreadsheet we are having issues with. hopefully it is not to big. Kent
here is zipped version of the file, if you would like unzipped. please advise. thought it might be to big. Kent
(In reply to Buovjaga from comment #7) > Please attach an example document. > Set to NEEDINFO. > Change back to UNCONFIRMED after you have provided the document. any further information on the issues that I am having with Libra Calc. I uploaded the file that I was having issues with. It seems to be someplace in the links. I am back to now needing to utilize this spreadsheet. and it just took me 30 minutes, before it would accept a cursor. I am currently running 7.5.6.2 (x86_64). For large spreadsheets LIbra calc is unusable.
I confirm the poor performance, also on Windows. I tested with several old versions, back to 4.3. I don't think it's about the links as the linked files are not available. Also, breaking links via Edit - Links to external files did not help with the performance. Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: f5bcc34580d02f92af01963155f2d54776a5249b CPU threads: 2; OS: Windows 10.0 Build 22621; UI render: default; VCL: win Locale: en-US (en_FI); UI: en-US Calc: threaded