Bug 119362 - Very slow horizontal scrolling when wrapping is enabled
Summary: Very slow horizontal scrolling when wrapping is enabled
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.7.2 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Scrolling-PageUpDown
  Show dependency treegraph
 
Reported: 2018-08-19 14:39 UTC by shitpoet
Modified: 2019-03-01 09:35 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
ODS file that causes LibreOfice Calc to freeze on scrolling (24.48 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-08-19 14:41 UTC, shitpoet
Details
one possible explanation for freezing (363.17 KB, image/png)
2018-08-19 18:37 UTC, BogdanB
Details
after modifing a little the file it loading much faster (18.70 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-08-19 18:38 UTC, BogdanB
Details
Video showing how I succeded speeding the file loading to the right columns (1.38 MB, video/mp4)
2018-08-20 05:52 UTC, BogdanB
Details

Note You need to log in before you can comment on or make changes to this bug.
Description shitpoet 2018-08-19 14:39:13 UTC
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
Comment 1 shitpoet 2018-08-19 14:41:29 UTC
Created attachment 144303 [details]
ODS file that causes LibreOfice Calc to freeze on scrolling
Comment 2 shitpoet 2018-08-19 14:42:01 UTC
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
Comment 3 shitpoet 2018-08-19 14:43:42 UTC
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.
Comment 4 Telesto 2018-08-19 16:59:06 UTC
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
Comment 5 BogdanB 2018-08-19 18:37:25 UTC
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
Comment 6 BogdanB 2018-08-19 18:38:03 UTC
Created attachment 144310 [details]
after modifing a little the file it loading much faster

after modifing a little the file it loading much faster
Comment 7 shitpoet 2018-08-19 20:10:17 UTC
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?
Comment 8 BogdanB 2018-08-19 21:10:47 UTC
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.
Comment 9 shitpoet 2018-08-19 22:15:10 UTC
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.
Comment 10 BogdanB 2018-08-20 05:52:45 UTC
Created attachment 144317 [details]
Video showing how I succeded speeding the file loading to the right columns