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: 220.127.116.11 release
I can confirm this bug also on LibreOffice 18.104.22.168 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.
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.
and it's already in the 4.2 branch.
Tested again with:
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 22.214.171.124 still persists.
Another way to reproduce it:
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 126.96.36.199.0+
Build ID: 52613b9b632721ebb5167a4d9529c242a0b907da
TinderBox: Win-x86@42, Branch:libreoffice-4-3, Time: 2014-06-23_07:41:56
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
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.
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:
Build ID: 32eddb3f48fcea0a052401a8a5dc075c7847f1c5
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-4-2, Time: 2014-07-02_08:19:58
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-188.8.131.52 and libreoffice-bin-184.108.40.206 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
220.127.116.11, 18.104.22.168, 4.4.0.alpha1
font preview activated
create a spreadsheet
open font drop down
close drop down, open and chose another front
and some more
I experience no delay..
On Windows 7, 32 bits
font preview activated
create a spreadsheet
select A1:T20000 *** FILL IT *** with aleatory content
open font drop down
I experience delay..
Created attachment 112513 [details]
There is still an issue present in at least 22.214.171.124 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
- Interface should be as responsive as before (4) - e.g. scrolling, clicking between cells, selecting a cell range
- Interface is much slower than before. Saving and reloading the file resets the speed to normal
Created attachment 112516 [details]
Video capture from 126.96.36.199
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)
Building from source confirms that the slowdown started at the below commit
Adding Cc: to email@example.com; Could you possibly take a look at this? Thanks
Author: Noel Power <firstname.lastname@example.org>
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
*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
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 188.8.131.52(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)
** 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)
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!
I tested this again with:
- Calc 184.108.40.206 on Debian 9.3 (stretch)
- Calc 220.127.116.11 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: 18.104.22.168.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