When i select all cells on sheet (1000 rows, 15 colomns) and try to change font, even if didn't save any changes, Calc becomes very slow.
file extention .xls
@Igor : please provide a sample document where you see the problem, otherwise we can not know whether it is the document format, the cell contents, or some other problme that is causing the slowdown.
Created attachment 118618 [details] example sheet
Version: 5.0.1.2 Build ID: 81898c9f5c0d43f3473ba111d7b351050be20261 Locale : fr-FR (fr.UTF-8) Can not reproduce. 1) Open Excel sheet attached to current bug report. 2) Select all cells in sheet by clicking in upper leftmost corner outside of sheet 3) Click on font dropdown menu, the font list displays with previews where available. 4) Select a font to apply to all cells. 5) Cells get updated with chosen font display. We need more information, and detailed steps as to how you are able to reproduce the problem/
Which version of OSX are you using ? How many fonts / font families are installed on your system ?
Created attachment 118709 [details] video
OSX 10.10.5, 233 fonts installed. Program freezes after activating font chooser. Added small video.
Hi Igor, Thanks, I understand now what you are referring to, and can reproduce the behaviour. Confirming. This rings a bell, so might be a duplicate of an existing bug report.
How to reproduce : 1) Open Excel sheet attached to current bug report. 2) Select all cells in sheet by clicking in upper leftmost corner outside of sheet 3) Click on font dropdown menu, the font list displays with previews where available. 4) Select a font from the list to apply to all cells. 5) Now try selecting any cell with the mouse cursor >> Calc becomes very slow to respond, cells or cell selections get made that the user didn't actually select, the whole document becomes unresponsive.
** 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.1.5 or 5.2.1 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-20160920
I'm still seeing slowness following directions per comment #9 Was not like this is in LO 3.3, so inherited from OOo Version: 6.2.0.0.alpha0+ Build ID: b292a27698e85fd9d60c03613c3b0c67835c4dc1 CPU threads: 2; OS: Mac OS X 10.12.6; UI render: default; TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2018-06-06_23:25:55 Locale: en-US (en_US.UTF-8); Calc: group threaded
After-change slowness reproduced on Linux as well. Arch Linux 64-bit Version: 6.2.0.0.alpha0+ Build ID: bd394492c165d27c96a44495d9ca694a242acb8f CPU threads: 8; OS: Linux 4.17; UI render: default; VCL: gtk3; Locale: fi-FI (fi_FI.UTF-8); Calc: group threaded Built on July 11th 2018
Bisected with Linux 42max. Blamed commit has been blamed for several other similar issues. This might be considered a dupe... commit 06271499c829a52c702c2c6dc8f99c2ec9c46fd3 Author: Matthew Francis <mjay.francis@gmail.com> Date: Sat Sep 5 20:42:38 2015 +0800 source-hash-bcc51fb2ebdf77a1cc089857775fd742085b45b6 commit bcc51fb2ebdf77a1cc089857775fd742085b45b6 Author: Noel Power <noel.power@suse.com> AuthorDate: Thu Aug 29 17:15:33 2013 +0100 Commit: Noel Power <noel.power@suse.com> CommitDate: Thu Aug 29 21:42:05 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.
Dear Igor, 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 with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. 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) from 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: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
It's slower than Excel, and switching toolbar mode while having selected all cells take 10-15 seconds, so something is definitely wonky Version: 6.4.0.0.alpha0+ Build ID: 54028dc503fc08eb12e287919d5e2850cff05b73 CPU threads: 4; OS: Mac OS X 10.14.6; UI render: default; VCL: osx; TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2019-07-31_01:48:19 Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded
(In reply to Alex Thurgood from comment #9) > How to reproduce : > > 1) Open Excel sheet attached to current bug report. > 2) Select all cells in sheet by clicking in upper leftmost corner outside of > sheet > 3) Click on font dropdown menu, the font list displays with previews where > available. > 4) Select a font from the list to apply to all cells. > > 5) Now try selecting any cell with the mouse cursor >> Calc becomes very > slow to respond, cells or cell selections get made that the user didn't > actually select, the whole document becomes unresponsive. No problem anymore, could others please re-test? Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 9c930c4f3109d123c0831d0fcecf9c8b32e5bbc7 CPU threads: 2; OS: Windows 10.0 Build 19042; UI render: default; VCL: win Locale: fi-FI (fi_FI); UI: en-US Calc: threaded
I'll go ahead and close this - another bug blaming the same commit is gone: bug 78254
Also tested on Linux and no problem either Version: 7.2.0.0.alpha0+ / LibreOffice Community Build ID: dc4b4137520645495d1a7ead9744f515f53e5c84 CPU threads: 8; OS: Linux 5.11; UI render: default; VCL: gtk3 Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded