Bug 90363 - Too slow handling of spreadsheet with charts with gradient/transparency formatting of data series
Summary: Too slow handling of spreadsheet with charts with gradient/transparency forma...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.0.0 beta1
Hardware: x86 (IA32) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Chart-Data
  Show dependency treegraph
 
Reported: 2015-03-31 09:32 UTC by Cor Nouws
Modified: 2017-08-14 06:40 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
First test file (168.90 KB, image/jpeg)
2015-03-31 09:33 UTC, Cor Nouws
Details
Scond test file (56.28 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-03-31 09:34 UTC, Cor Nouws
Details
First test file (the right one!) ods with chart with gradients (85.87 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-04-01 13:13 UTC, Cor Nouws
Details
video showing the slowww behavior (4.99 MB, video/ogg)
2015-04-11 14:15 UTC, Cor Nouws
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Cor Nouws 2015-03-31 09:32:36 UTC
I'll attach two spreadsheets with data, formulas and some charts
It is way too slow in 4.4-versions.

Open the First file (see it nearly freeze)

On sheet 2, select one cell in B4-19 of E4-19
Type a four or five digit number and type Enter
   > number appears slow
Type up or down to go to other cells
   > also very slow
Then moving to another cell with Right ... slow ..


Then I tried to change the formatting. See the Second file.
Removing the gradient/transparency formatting of data series makes it work fast again.

In my experience, with without OpenCL makes no difference
Comment 1 Cor Nouws 2015-03-31 09:33:52 UTC
Created attachment 114486 [details]
First test file
Comment 2 Cor Nouws 2015-03-31 09:34:22 UTC
Created attachment 114487 [details]
Scond test file
Comment 3 raal 2015-04-01 13:02:38 UTC
Hello,
first file is printscreen -  should be .ods file?
Comment 4 Cor Nouws 2015-04-01 13:13:27 UTC
Created attachment 114523 [details]
First test file (the right one!) ods with chart with gradients

better test file.
Sorry for posting the wrong one.
Comment 5 raal 2015-04-01 17:41:17 UTC
Version: 4.4.3.0.0+
Build ID: 3eba5eb1774ab621a1f0f4dcc7e82cce6c025b0a
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-4-4, Time: 2015-03-27_09:07:12

First file
Open without problem. No problem when typing numbers. But scrolling the sheet is slow.

Second file
Scrolling is fast.
Comment 6 A (Andy) 2015-04-03 13:17:24 UTC
(In reply to Cor Nouws from comment #0)
> I'll attach two spreadsheets with data, formulas and some charts
> It is way too slow in 4.4-versions.
> 
> Open the First file (see it nearly freeze)

For me not reproducible with LO 4.4.1.2, Win 8.1, no freeze


> On sheet 2, select one cell in B4-19 of E4-19
> Type a four or five digit number and type Enter
>    > number appears slow

A very short delay (milliseconds) is reproducible with LO 4.4.1.2, Win 8.1.  This could be a bit faster, but for me personal with this specific test file and my OS and LO version it is probably not a real bug, more an enhancement.  But if it is in Linux or with a larger file a bigger problem, then I could understand this.


> Type up or down to go to other cells
>    > also very slow
> Then moving to another cell with Right ... slow ..

For me not reproducible with LO 4.4.1.2, Win 8.1


> Then I tried to change the formatting. See the Second file.
> Removing the gradient/transparency formatting of data series makes it work
> fast again.

The short delay from above is no longer recognizable.
Comment 7 Buovjaga 2015-04-10 13:16:36 UTC
Nothing unusual observed.

Win 7 Pro 64-bit, Version: 4.4.2.2
Build ID: c4c7d32d0d49397cad38d62472b0bc8acff48dd6
Locale: fi_FI

Ubuntu 14.10 64-bit 
Version: 4.4.2.2
Build ID: 40m0(Build:2)
Locale: en_US
Comment 8 Cor Nouws 2015-04-11 12:55:13 UTC
Hi raal,

(In reply to raal from comment #5)
> No problem when typing numbers. 

Did you try typing in the range that is the source for the charts?
Comment 9 Cor Nouws 2015-04-11 14:15:03 UTC
Created attachment 114739 [details]
video showing the slowww behavior
Comment 10 Cor Nouws 2015-04-11 14:15:47 UTC
confirming myself - proof given with video. And yes, I tested with a clean userprofile too
Comment 11 raal 2015-04-12 08:03:21 UTC
(In reply to Cor Nouws from comment #8)
> Hi raal,
> 
> (In reply to raal from comment #5)
> > No problem when typing numbers. 
> 
> Did you try typing in the range that is the source for the charts?

Yes, as in your video. I don't see this in master on my PC.
Version: 4.5.0.0.alpha0+
Build ID: b024e36ddb3b53163d7a01f6f7b5aadb7a858cd9
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-03-31_09:12:20
Comment 12 Cor Nouws 2015-04-12 16:03:07 UTC
(In reply to raal from comment #11)

> > Did you try typing in the range that is the source for the charts?
> 
> Yes, as in your video. 

thanks!
(By the way I shouldn't have asked it, since for me typing in an empty cell is just as sluggish. Sorry)

> I don't see this in master on my PC.
> Version: 4.5.0.0.alpha0+
> Build ID: b024e36ddb3b53163d7a01f6f7b5aadb7a858cd9
> TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time:
> 2015-03-31_09:12:20

I do have the problem in my most recent daily (2015-03-30, didn't install the March 31)
Version: 4.5.0.0.alpha0+
Build ID: 9efd80ac32a80656ed6482df69615227d12bc6d9
TinderBox: Linux-rpm_deb-x86@45-TDF, Branch:master, Time: 2015-03-30_16:43:31
Locale: nl_NL

So maybe the problem is bound to the 32 bits on Linux?
Comment 13 tommy27 2016-04-16 07:23:40 UTC Comment hidden (obsolete)
Comment 14 QA Administrators 2017-05-22 13:23:55 UTC Comment hidden (obsolete)
Comment 15 Cor Nouws 2017-08-14 06:40:44 UTC
works fine in Version: 6.0.0.0.alpha0+
Build ID: 368b583b992f2e9cad46c2362c9529a07c36d7a9
CPU threads: 4; OS: Linux 4.10; UI render: default; VCL: gtk2; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2017-08-10_02:55:46
Locale: nl-NL (nl_NL.UTF-8); Calc: group  :)