Issue 127854 - Very slow horizontal scrolling in Calc
Summary: Very slow horizontal scrolling in Calc
Status: CLOSED DUPLICATE of issue 67412
Alias: None
Product: Calc
Classification: Application
Component: viewing (show other issues)
Version: 4.1.5
Hardware: PC Linux 64-bit
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needhelp
Depends on:
Blocks:
 
Reported: 2018-08-19 15:14 UTC by shitpoet
Modified: 2018-08-27 19:05 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
ODS file that causes OpenOffice Calc to freeze on scrolling (19.13 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-08-19 15:14 UTC, shitpoet 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description shitpoet 2018-08-19 15:14:35 UTC 
Created attachment 86488 [details]
ODS file that causes OpenOffice Calc to freeze on scrolling

Calc freezes while scrolling in table with long (over 8k characters) cell, when the cell becomes visible. When the cell is out of view, Calc scrolls ok.

Steps to reproduce:
1. Open attached ODS document in Calc 4.15.
2. Scroll to the right using keyboard arrows or using mouse and scrollbar to column AE (named "*Description").

What happens:
Calc freezes for about 10 seconds, after than it renders the screen correctly and works well. 

What was expected to happen:
Scrolling to the right without freezes, just like with other columns.

Some text from About dialog:
AOO415m1(Build:9789)  -  Rev. 1817496
2017-12-11 15:46 - Linux x86_64

My system is Debian 9.5 stable 64 bit, version of OpenOffice is 4.15 stable (downloaded from official site).

By the way I have the exactly same bug in LibreOffice 5 (default in Debian 9.3 stable), LibreOffice 6.1 release and latest at the moment LibreOffice 6.2-alpha. So the bug is common for both projects.
Comment 1 shitpoet 2018-08-19 15:17:30 UTC 
I tried to disable OpenGL, JRE and unchecked many checkboxes in Calc options, but nothing helped.
Comment 2 oooforum (fr) 2018-08-20 08:15:33 UTC 
I was not able to reproduce this freeze with AOO 4.1.5 and Win7.
I can reach AE column with no problem. 
But I see that AE cells contains 168 characters and take a bit of time to  displayed.
Are you sure to have sufficient memory resource?
Comment 3 Keith N. McKenna 2018-08-20 15:29:33 UTC 
I cannot confirm with the following configurations:

Intel (R) Pentium(R) CPU 4405U @2.10GHz, 2112MHz, 2(Core(s) 4 Logical Processors
Total Physical Memory 8.00 GB
Operating System: Windows 10 Home OS Build 10.0.16299.371 Version 1803
Apache Open Office:
AOO415m1(Build:9789)  -  Rev. 1817496
2017-12-11 17:25
Additional Language Packs: None

and

System Configuration:
Processor: Intel Core i5 CPU M560 @2.67GHz
Installed Memory: 2.00 GB (1.6 usable)
Operating System: Windows 7 Home Premium 64 bit

Apache Open Office:
AOO420m1(Build:9800)  -  Rev. 1820587
Rev.1820587
Language: en_US
Additional Language Packs: None

I agree with oooForum(fr) that you may have a memory resource issue.

Would one of our volunteers using a Linux 64 bit system please test to be sure it is not a Linux only problem.
Comment 4 shitpoet 2018-08-20 17:22:56 UTC 
I'm sorry, I was talking about column AF (not AE) with name '*Description`, and as I wrote it has more than 8 000 characters. 

BTW, the bug was reproduced in LibroOffice bug tracker - https://bugs.documentfoundation.org/show_bug.cgi?id=119362, and it seems to be related to wrapping of long text, because when I unchecked checkbox "Wrap text" in "Format cells" dialog, the freezes go away. (Through a small delay is still there when focus the cell, but not when I just scroll to it.)
Comment 5 oooforum (fr) 2018-08-27 08:59:02 UTC 
Already reported

*** This issue has been marked as a duplicate of issue 67412 ***