Problem description: Since 4.2, Calc becomes very slow after selecting some cells and activating the font chooser (for example to pick a font from the dropdown, or to type a font name). Verified on 4.2.3~rc3 under Ubuntu 12.04, Ubuntu 14.04, and Windows 7. Not tested on master yet, will do as soon as I have time. The effect increases with the size of the spreadsheet and the number of cells selected. In a spreadsheet with 200 rows and 15 columns, after doing Select All and opening the font dropdown, any operation like moving the cursor to another cell or selecting some rows makes Calc stop responding (taking 100% cpu) for seconds or even minutes. In a 26x26 spreadsheet (just a-z in rows and columns) it's less severe but still noticeable. Changing the font size doesn't trigger it. If I disable "Show preview of fonts" (Options - LibreOffice - View), it doesn't happen any more after quitting Calc and starting it again. (The option is enabled by default.) Bibisect points to bcc51fb2ebdf77a1cc089857775fd742085b45b6 ("add support for in-place style preview") as the first bad commit. Operating System: Ubuntu Version: 4.2.0.4 release
I can confirm this bug also on LibreOffice 4.2.1.1 under Windows 8.1 and Ubuntu Gnome 13.04 If I may, I'm of the opinion that the problem permeates deeper than just fonts formatting because doing about anything that involves Select > All slows down Calc to the point where it is becoming questionable whether it's really ready for production.
Since yagolf confirmed the bug (thanks!), changing from UNCONFIRMED to NEW.
This needs to be re-verified with a more recent 4.2 build.
Hi Kohei, The bug exists also in 4.2.4 RC2.
Try daily build. Release build is not to be used for QA purposes.
Even better would be the latest from the 4.2 branch.
Confirmed with libreoffice-4.2 daily build: libreoffice-4-2~2014-05-08_00.21.04 Seems to be fixed in master daily build: master~2014-05-07_23.36.18 I will try to find the responsible commit. There is no bibisect repository for 4.3 yet, right?
Huh. Weird. I did backport (what I think to be) the fix to 4.2 a week or so ago. As far as Calc is concerned, there isn't much difference between master and 4.2 branches.
(In reply to comment #7) > I will try to find the responsible commit. There is no bibisect repository > for 4.3 yet, right? Actually I don't know enough about bibisect to answer this. Sorry. Joel and Bjoern may know.
This commit is what I suspected to be the fix. http://cgit.freedesktop.org/libreoffice/core/commit/?h=libreoffice-4-2&id=9585ea8a3f10be60c42b671a07dfafd78f173e52 and it's already in the 4.2 branch.
Tested again with: libreoffice-4-2~2014-05-12_10.48.12_LibreOfficeDev_4.2.5.0.0_Linux_x86-64_deb master~2014-05-11_23.54.14_LibreOfficeDev_4.3.0.0.alpha1_Linux_x86-64_deb Actually, I don't think it's fixed, either on libreoffice-4-2 or on master. I don't know why I wrote that before. Easy to reproduce: 1. put some text in the first cell and copy-paste that to some rows and columns (e.g. 50x50) 2. select all, and change the font 3. scroll up and down With style previews enabled, after the font has been changed, scrolling is slow and there's a visible delay while cells are redrawn. With style previews disabled, scrolling is fast.
Reading #74555, I really do expect this to be a duplicate of it. It sounds exactly the same. But I checked carefully that I'm testing with a build that includes that change, and I'm definitely still experiencing the problem like I wrote in my previous comment.
Ok. Then this is perhaps something else.
(In reply to comment #13) > Ok. Then this is perhaps something else. Yes, in versión 4.2.5.2 still persists.
Another way to reproduce it: Edit->Select All Ctrl-M (Format->Clean Format) Then arrow keys move slowly
I hope this help to Kohei Yoshida in some way: How recuperate speed after change font in all cells: Simply go to combo box to change font and next press escape (with nothing selected) Calc then return to full speed!
Still in libreoficce 4.3.0 RC1. I suppose it's a flag not checked when select all is applicated, because change font without select cells fix the speed of calc.
please take a look at Bug 80429 - Calc slows down when you select all cells and change font it looks a very similar issue which I reproduced under Win7x64 in 4.2.x but not in 4.3.0.1.0+ Build ID: 52613b9b632721ebb5167a4d9529c242a0b907da TinderBox: Win-x86@42, Branch:libreoffice-4-3, Time: 2014-06-23_07:41:56 @gitzu can you retest with a more recent 4.3 build?
The original report was against Calc < 4.2.5.x I think this is just OK in 4.2.5 ad 4.3.0 See https://bugs.freedesktop.org/show_bug.cgi?id=80356#c2
Ok. let's mark this as RESOLVED WORKSFORME. feel free to reopen if somebody still reproduces this on recent 4.2.x or 4.3.x builds
I want to try if really the bug was corrected in recent versions, but Windows installers in Nightly Builds don't install. Example: libo-43~2014-06-25_00.02.29_LibreOfficeDev_4.3.0.1.0_Win_x86.msi
bad news... please open a new report about that 4.3.x install issue
(In reply to comment #20) > feel free to reopen if somebody still reproduces this on recent 4.2.x or > 4.3.x builds Reopening. Reproduced with: Version: 4.2.6.0.0+ Build ID: 32eddb3f48fcea0a052401a8a5dc075c7847f1c5 TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-4-2, Time: 2014-07-02_08:19:58 Version: 4.3.1.0.0+ Build ID: c482a2f87ef2a38d249c276924e071bbc714a07f TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-4-3, Time: 2014-07-01_23:55:39 on Ubuntu 14.04 64-bit. (In reply to comment #19) > See https://bugs.freedesktop.org/show_bug.cgi?id=80356#c2 I agree with that comment. It is better than it was but there is still a noticeable loss of performance after opening the font chooser, when previews are enabled. I think bug 80356 is a duplicate of this one (or vice versa), and both are a continuation of the issue that was partly fixed in bug 74555 and still partly exists.
confirm this bug. tested with LibreOffice_4.2.4_Win_x86.msi on windows xp, libreoffice-bin-4.2.3.3 and libreoffice-bin-4.2.6.3 on gentoo linux. disable "Show preview of fonts" solves problem.
Needs independent confirmation from QA team - moving to UNCONFIRMED. Thanks all
On Linux, Ubuntu, 32 bits 4.2.7.2, 4.3.3.2, 4.4.0.alpha1 font preview activated create a spreadsheet select A1:T20000 or A1:Y20000 open font drop down choose font close drop down, open and chose another front and some more I experience no delay..
On Windows 7, 32 bits 4.3.3.2 font preview activated create a spreadsheet select A1:T20000 *** FILL IT *** with aleatory content open font drop down choose font Navigate... I experience delay..
Created attachment 112513 [details] Test file
There is still an issue present in at least 4.4.0.2 and 4.5 master which does appear to date back to the range mentioned in comment 0 (which in the 43all bibisect repo is source-hash-bcc51fb2ebdf77a1cc089857775fd742085b45b6). Steps to reproduce: 1. Load the file from attachment 112513 [details] 2. Ensure "Tools - Options - LibreOffice - View - Font Lists - Show preview of fonts" is enabled 3. Select All 4. Change to another font Expected result: - Interface should be as responsive as before (4) - e.g. scrolling, clicking between cells, selecting a cell range Actual result: - Interface is much slower than before. Saving and reloading the file resets the speed to normal
Created attachment 112516 [details] Video capture from 4.4.0.2 The attached video capture shows the observed effect. Note that after font preview is enabled and the font changed, the selection is much less responsive. This effect is much more pronounced on a dbgutil build of 4.5 master (it hasn't become slower; this just seems to be a side effect of dbgutil)
commit bcc51fb2ebdf77a1cc089857775fd742085b45b6 Building from source confirms that the slowdown started at the below commit Adding Cc: to nopower@novell.com; Could you possibly take a look at this? Thanks Author: Noel Power <noel.power@suse.com> Date: Thu Aug 29 17:15:33 2013 +0100 add support for in-place style preview selecting a style in the styles dialog ( without double clicking ) will apply the style to the currently selected cell(s) You can with the keys navigate to other styles and they in turn will also be applied. Preview will end when you click back onto the document. *FIXME* - the styles dialog isn't really suitable for previewing, a new dialog ( possibly in the toolbar ) might be nicer ( see Excel ) *FIXME* - when there is a multiple selection the highlight colour (applied as a transparent overlay) is most annoying ( and is mixed with any background colour applied if part of a style ) see ( ScGridWindow::UpdateSelectionOverlay() ) However my puny attempts to make the selection use a transparent colour made all the borders of the selected cells dissappear. I guess maybe a box/border around each selected cell ( or group of cells ) would also work but I didn't try that Change-Id: I0950e79085ffb75f60ee961835665df0c230172f
Same thing happens on mac os x 10. When i select all cells on sheet with 1000 rows and 15 colomns and try to change font, even if didn't save any changes, Calc becomes very slow and it's becomes impossible to continue work.
version LO 5.0.1.2(In reply to Igor from comment #32) > Same thing happens on mac os x 10. When i select all cells on sheet with > 1000 rows and 15 colomns and try to change font, even if didn't save any > changes, Calc becomes very slow and it's becomes impossible to continue work.
Migrating Whiteboard tags to Keywords: (bibisected) [NinjaEdit]
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.4.1 or 5.3.6 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20170929
Hello, I tested this again with: - Calc 5.4.3.2 on Debian 9.3 (stretch) - Calc 5.3.7.2 on Windows 10 and following the instructions in comment #23. The behaviour does seem to have changed since I originally reported the bug. I no longer experience a lag of several seconds. However, Calc does still become noticeably less responsive after Select All (Ctrl-A) and changing the font. It's easy to see if you use the arrow keys to move around: immediately after opening the document, arrow key navigation is quite responsive; but after changing the font on the entire document, there is noticeable lag in redrawing the row/column indicators. Even though it's much better than it used to be, as the steps to reproduce still result in a visible change in UI performance, I'm leaving the status as open for now.
Doing a select all (range with data is A1:O351) and then font list, works instantaneous in Version: 6.1.0.0.alpha0+ Build ID: a9b202a6b7000e7af34f2a639ca207122a3968bf CPU threads: 4; OS: Linux 4.13; UI render: default; VCL: gtk2; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2017-12-26_23:09:36 Locale: nl-NL (nl_NL.UTF-8); Calc: group threaded