Summary: | Poor performance for ODS with frozen rows and columns | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Kent <kentth2> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | major | CC: | buzea.bogdan, ilmari.lauhakangas |
Priority: | medium | Keywords: | perf |
Version: | 4.3.0.4 release | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 109182 | ||
Attachments: | zipped version of .ods file we have having issues with slow |
Description
Kent
2023-04-19 15:03:08 UTC
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 |