Description: The horizontal scrolling (either my mouse or by keyboard arrows) is very slow in Calc when a specific cell with long (over 8k chars) html-like text becomes visible. The app freezes for several seconds. Steps to Reproduce: 1. Open attached file in LibreOffice 5.3, 6.1 or 6.2-alpha 2. Scroll to the right using keyboard to a column AE ("*Description") Actual Results: The app freezes for several seconds (around 7 seconds on my laptop). While the app is frozen the screen is distorted (partly scrolled). When the app becomes responsive again, it correctly draws the screen. Expected Results: Scrolling to the right without freezes, like with other cells. Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Linux (All) OS is 64bit: yes
Created attachment 144303 [details] ODS file that causes LibreOfice Calc to freeze on scrolling
The text from About dialog: Version: 6.2.0.0.alpha0+ Build ID: f61af646c5c3fe7e50aea01ede6a9d7ea53380f2 CPU threads: 4; OS: Linux 4.12; UI render: default; VCL: gtk2; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2018-08-19_06:33:19 Locale: en-US (C.UTF-8); Calc: threaded
I tried to install/uninstall LibreOffice, to start in Safe Mode, to reset to factory settings, to disable OpenGL, automatic recalculation and many other settings accessible from Options dialog.
Repro with Version: 6.2.0.0.alpha0+ Build ID: c0fdcece6b886912618deee9656cb2d169a9b999 CPU threads: 4; OS: Windows 6.3; UI render: default; TinderBox: Win-x86@42, Branch:master, Time: 2018-08-12_00:35:45 Locale: en-US (nl_NL); Calc: CL and with LibreOffice 3.5.7.2 Build ID: 3215f89-f603614-ab984f2-7348103-1225a5b
Created attachment 144309 [details] one possible explanation for freezing This is the image with text from a single cell from "AF". So LibreOffice is loading a lot of text in every cell. After I modified the file now is loading faster. Version: 6.1.1.0.0+ Build ID: 5a56b72413d5f555c854e36d3bd2fd50ec21644c CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk2; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:libreoffice-6-1, Time: 2018-08-15_02:45:13 Locale: ro-RO (ro_RO.UTF-8); Calc: group threaded
Created attachment 144310 [details] after modifing a little the file it loading much faster after modifing a little the file it loading much faster
I confirm that with last upload https://bugs.documentfoundation.org/attachment.cgi?id=144310 by BogdanB LibreOffice freezes much less or not freezes at all while scrolling. I notice only a slight delay when I select AF column itself now. Can you tell me please what you changed in the file?
I made text easier to read. Space betwen text and border larger, and also Wrap all the text from that sheet. I could make a video tomorrow with changes.
Maybe you mean that you UNwrapped all the text? I disabled checkbox "Wrap text automatically" (Format cells dialog) and my original sheet became much faster too. It seems like it is as fast as yours now.
Created attachment 144317 [details] Video showing how I succeded speeding the file loading to the right columns
Dear shitpoet, 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 https://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
still repro in Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 722ec600e85cca2e94e82e69f8d13773061172b9 CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); UI: en-US Calc: threaded really text wrap disabling does a scrolling much faster without any delay
*** This bug has been marked as a duplicate of bug 144515 ***