Moving a sheet with a chart based on a datarange to a different tab position takes 30 seconds until moved an still unusable for 40 seconds afterwards
Steps to Reproduce:
1. Open the attached file
2. Move sheet 2 before 500k formula sheet
30 seconds before sheet moved..
Click the sheet it hangs again
10 seconds and usable after move
User Profile Reset: No
Build ID: c344de1b9985b6ca10b354e24151d0bdf92dc20e
CPU threads: 2; OS: Linux 5.3; UI render: default; VCL: x11
Locale: en-US (en_US.UTF-8); UI: en-US
but not in
Created attachment 161782 [details]
3abe790c27b619aa5e9848f34b152069527473bf is the first bad commit
Author: Matthew Francis <firstname.lastname@example.org>
Date: Thu May 28 21:13:02 2015 +0800
Author: Markus Mohrhard <email@example.com>
AuthorDate: Thu Apr 17 02:02:15 2014 +0200
Commit: Markus Mohrhard <firstname.lastname@example.org>
CommitDate: Thu Apr 17 02:08:59 2014 +0200
limit the range shrinking in charts to really large ranges, fdo#70609,
Also improves the situation for fdo#55697.
It is just the fist step to a better algorithm.
Created attachment 161783 [details]
about 15/15 sec. here,
set to new as improvements would be nice, but not a 'big issue'
Build ID: 6a03b2a54143a9bc0c6d4c7f1...
CPU threads: 8; OS: Linux 4.19; UI render: default; VCL: gtk3;
Locale: de-DE (en_US.UTF-8); UI: en-US
The same commit causes a delay in removing the sheet (18 seconds vs 32 seconds). And quite a bump in memory usage while deleting. 420 MB versus 1100 MB peak
1. Cut the Chart on sheet 2
2. Wait 60 seconds.. prior 20 seconds
Notice also the file opening time -> Slower
Memory usage showing grah
745 MB after the commit
227 MB before the commit
Adding CC: to Markus Mohrhard
Bug 70609 comment 2
So the shrinking of data ranges is hurting us here. I was never a big fan of this feature but it seems that we finally need a proper solution for the problem.
The problem is that the content is not yet imported and we are already importing the chart so shrinking to the used data range is wrong.
I'll limit the feature for now to cases where it won't hurt us too much and will think about proper solutions.