Bug 117206 - Inserting rows extremely slow, scrolling is also slow
Summary: Inserting rows extremely slow, scrolling is also slow
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
6.0.3.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-04-24 11:03 UTC by lopeonline
Modified: 2018-04-24 16:36 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Very simple single sheet Calc ODS spreadsheet containing <690 rows with occasional comments (31.69 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-04-24 11:03 UTC, lopeonline
Details

Note You need to log in before you can comment on or make changes to this bug.
Description lopeonline 2018-04-24 11:03:41 UTC
Created attachment 141589 [details]
Very simple single sheet Calc ODS spreadsheet containing <690 rows with occasional comments

I've been using this spreadsheet for about 5 years. It was totally fine on a previous version of LibreOffice (I'm not sure the exact version, maybe v5 or v4) when I was using Ubuntu 14.04.

But it's become absolutely unusably slow.

My computer is extremely fast at 4.3Ghz, and libreoffice Calc is taking about 5 minutes just to insert a row in a tiny little spreadsheet.

Please help!!!
Comment 1 lopeonline 2018-04-24 11:07:39 UTC
Some other details.
As I mentioned, my computer is extremely fast 4.3Ghz 4th gen i5. 32GB 2400mhz dual channel DDR3 RAM, SSD etc.
Running Ubuntu 16.04 4.13 kernel.
Comment 2 lopeonline 2018-04-24 11:11:42 UTC
To reproduce bug
-----------------
* Scroll up/down in spreadsheet
* Insert a row
* etc
Comment 3 Xavier Van Wijmeersch 2018-04-24 12:58:54 UTC
no repro, maybe a corrupt user profile, try to reset the user profile.
Inserting rows or scrolling is fast.

Version: 6.0.5.0.0+
Build ID: d1407aac59f3f218a311452fc7dcb7692fdf5285
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group
Comment 4 lopeonline 2018-04-24 16:32:31 UTC
THANK YOU
THANK YOU
THANK YOU

I can work again!

You were right. The problem was a corrupt user profile.
Sorry to be the retard guy who ignored the instructions about corrupt user profile.
I thought "What does inserting a row have to do with my user profile" but clearly I know nothing about the user profile.
And I didn't realize how easy it was to reset the user profile to factory settings. Next time Calc so much as farts I will reset the user profile.

Ah, what a relief!!!
You've made my day!

Have an awesome day Xavier!
Comment 5 lopeonline 2018-04-24 16:36:26 UTC
Adding a row takes about 200ms (guess)
Scrolling is instant.
Hovering over comments gives a specific delay (I would love to set it to zero, do you know how to do it), but when I've recently hovered over a cell's comment and hover again, it shows instantly.