Summary: | LibreCalc gets slower when progressing through large spreadsheets | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Brian P <vannerwinner> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | normal | CC: | 79045_79045, brhengineers, himajin100000, miguelangelrv |
Priority: | medium | Keywords: | perf |
Version: | 7.0.5.2 release | ||
Hardware: | All | ||
OS: | Windows (All) | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 136524 | ||
Attachments: | Example ss showing problem |
Description
Brian P
2021-04-06 08:25:02 UTC
Please test with a clean profile, Menu/Help/Restart in Safe Mode. If it doesn't work, please attach a sample file with the steps to reproduce the issue. Thank you for your prompt response. I have reset my Profile and initially it did improve responsiveness. (I thought I had tried this before but realise now that I put it into SafeMode which made no difference.) Several days further on and it is now starting to get a bit lumpy again. I am working on row 2700 of my current sheet, so about half-way through. If it is OK with you I will continue as is for now and see if response deteriorates further as I work on the piece. It could be another week or so before I finish checking it all, but if it becomes too slow I will send you a copy of the file. Is that OK? Brian [Automated Action] NeedInfo-To-Unconfirmed Created attachment 171182 [details]
Example ss showing problem
I can confirm that the change of Profile effect was temporary and that the lumpy, sticky behaviour has continued when editing the file from mid-point onwards (there are about 5400 rows). Working on the early part of the sheet is absolutely fine, but the further I progress the more stodgy response is. In particular when saving changes, the Save seems to take several seconds and a few more for the Save icon to change back. But it is all aspects that are affected: scrolling, editing fields, highlighting a row, changing font colour etc. Sometines these are OKish, sometimes not. Saving is always sluggish. I think the problem is happening because I freeze the first three rows of the sheet as these contain heading and column width limit information. When I was preparing a copy of the original file to send these rows were not Frozen and I couldn't undestand why this behaviour wasn't happening in the copy file. Then I tried doing a SaveAs of the work-in-progress file and the stodginess was there. May be a red herring of course ... Confirmed. Version: 7.0.5.2 (x64) Build ID: 64390860c6cd0aca4beafafcfd84613dd9dfb63a CPU threads: 4; OS: Windows 10.0 Build 21296; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: threaded Version: 7.1.3.0.0+ (x64) / LibreOffice Community Build ID: 436573acb76714ae9b0ccb8e664911b9696269f4 CPU threads: 4; OS: Windows 10.0 Build 21296; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: threaded Resetting the format for the whole sheet [ctrl-M] solves the issue. Thank you for this workaround, which has speeded things up nicely. Fortunately the formatting changes that it undid were easily redone, or were no longer needed. Presumably it will progressively get slower again as I work further into the sheet? I have a similar problem with version 7.2.4 except that I find it happens when editing a set of about 20 Calc files,each about 250k in size, one at a time. After about the 10th file Calc starts to become progressively unresponsive. Even a file save after editing 5 cells in one row can take 10-12 seconds to complete whereas initially it is almost instantaneous. |