[Libreoffice-bugs] [Bug 151876] Slow Chart Render open, cpu spike, and view if data point is more than 1000 data point in Calc

2022-11-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=151876

Jérôme  changed:

   What|Removed |Added

 Blocks||136524


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=136524
[Bug 136524] [META] Performance/hang/lag/high CPU issues
-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 151876] Slow Chart Render open, cpu spike, and view if data point is more than 1000 data point in Calc

2022-11-09 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=151876

--- Comment #11 from p...@world3.net ---
Created attachment 183498
  --> https://bugs.documentfoundation.org/attachment.cgi?id=183498=edit
Another demonstration document

I have the same issue. Core i7 2700k with 32GB RAM and an SSD. Opening the file
is slow, clicking on the graph to edit it hangs for several minutes.

Version: 7.1.1.2 (x64) / LibreOffice Community
Build ID: fe0b08f4af1bacafe4c7ecc87ce55bb426164676
CPU threads: 8; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 151876] Slow Chart Render open, cpu spike, and view if data point is more than 1000 data point in Calc

2022-11-05 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=151876

--- Comment #10 from Benyamin Limanto  ---
(In reply to m.a.riosv from comment #8)
> Created attachment 183424 [details]
> Ods file

But it's usable after the ods loaded, which is nice, just the file is big, very
big, 300kb to 5mb ah... Thanks for sharing!

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 151876] Slow Chart Render open, cpu spike, and view if data point is more than 1000 data point in Calc

2022-11-05 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=151876

--- Comment #9 from Benyamin Limanto  ---
(In reply to m.a.riosv from comment #8)
> Created attachment 183424 [details]
> Ods file

Sadly it's worst here, 15-20 minutes waiting to load, and unresposive sadly..
hmm :/ 

My computer is i7-2640m, 12gb ram, and SATA SSD with speed of 550mb read write,
hmm... 

For now I will spin KVM with Excel first, anyway the ods open fast in Other
office, but not in libre :/

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 151876] Slow Chart Render open, cpu spike, and view if data point is more than 1000 data point in Calc

2022-11-04 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=151876

--- Comment #8 from m.a.riosv  ---
Created attachment 183424
  --> https://bugs.documentfoundation.org/attachment.cgi?id=183424=edit
Ods file

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 151876] Slow Chart Render open, cpu spike, and view if data point is more than 1000 data point in Calc

2022-11-04 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=151876

Julien Nabet  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 Ever confirmed|0   |1
 CC||er...@redhat.com,
   ||noelgran...@gmail.com

--- Comment #7 from Julien Nabet  ---
Let's put this one to NEW since we can reproduce the slowness.

Eike/Noel: perhaps you may find some ways to improve perf from the Flamegraph.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 151876] Slow Chart Render open, cpu spike, and view if data point is more than 1000 data point in Calc

2022-11-04 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=151876

--- Comment #6 from Julien Nabet  ---
Created attachment 183404
  --> https://bugs.documentfoundation.org/attachment.cgi?id=183404=edit
Flamegraph

Here's a Flamegraph retrieved on pc Debian x86-64 with master sources updated
today + gen rendering.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 151876] Slow Chart Render open, cpu spike, and view if data point is more than 1000 data point in Calc

2022-11-04 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=151876

--- Comment #5 from Benyamin Limanto  ---
(In reply to m.a.riosv from comment #4)
> Created attachment 183401 [details]
> Sample file modified chart ranges
> 
> Seems calc doesn't like column ranges in chart ranges.
> Charts have column ranges, but calc doesn't treat them like that and doesn't
> shortcut to analyze at then end of the data.
> Changed in the sample file, the chart ranges to  rows, runs very
> smoothly.
> 
> It also makes load and save near instantly. And problem with the original
> sample, at load & save it's also in ods format.

Could you share the resulted ods file? I want to try here, thanks. Because last
time I tried to create a brand new ods file using that method, it ends up like
the xlsx, so I think it's the same problem. thanks.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 151876] Slow Chart Render open, cpu spike, and view if data point is more than 1000 data point in Calc

2022-11-03 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=151876

m.a.riosv  changed:

   What|Removed |Added

 CC||miguelangelrv@libreoffice.o
   ||rg

--- Comment #4 from m.a.riosv  ---
Created attachment 183401
  --> https://bugs.documentfoundation.org/attachment.cgi?id=183401=edit
Sample file modified chart ranges

Seems calc doesn't like column ranges in chart ranges.
Charts have column ranges, but calc doesn't treat them like that and doesn't
shortcut to analyze at then end of the data.
Changed in the sample file, the chart ranges to  rows, runs very smoothly.

It also makes load and save near instantly. And problem with the original
sample, at load & save it's also in ods format.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 151876] Slow Chart Render open, cpu spike, and view if data point is more than 1000 data point in Calc

2022-11-03 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=151876

Telesto  changed:

   What|Removed |Added

 CC||serval2...@yahoo.fr

--- Comment #3 from Telesto  ---
A flamegraph would be nice

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 151876] Slow Chart Render open, cpu spike, and view if data point is more than 1000 data point in Calc

2022-11-03 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=151876

Telesto  changed:

   What|Removed |Added

   Keywords||perf
 CC||tele...@surfxs.nl
Version|7.4.2.3 release |7.1.0.1 rc
 OS|Linux (All) |All

--- Comment #2 from Telesto  ---
Confirm slowness with
Version: 7.5.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 9cd0f4c2d25462feba0ffcbd906c199273821243
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: nl-NL (nl_NL); UI: en-US
Calc: CL threaded

and with 7.1

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 151876] Slow Chart Render open, cpu spike, and view if data point is more than 1000 data point in Calc

2022-11-03 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=151876

--- Comment #1 from Benyamin Limanto  ---
Created attachment 183391
  --> https://bugs.documentfoundation.org/attachment.cgi?id=183391=edit
The sample xlsx

This is the sample xlsx, could be tested by any LO version

-- 
You are receiving this mail because:
You are the assignee for the bug.