[Libreoffice-bugs] [Bug 144052] Calc hangs when I try insert a chart for 800000 cells

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=144052

--- Comment #5 from Mark Dunn <mark.dunn.and.sharon.king at gmail.com> ---
So to be clear.

I download: 
   
https://api.coronavirus.data.gov.uk/v2/data?areaType=region&metric=newCasesBySpecimenDateAgeDemographics&format=csv

every day, which as you say is unwieldy

I then select the sheet and "insert/pivot" to obtain a much more wieldy table
of cases (Area Name by Date by Age Group if you are interested) 

Currently that is 20 * 578 cells

It is a reasonable thing for calc to do quickly.

But sometimes I have missed "insert/pivot table" and hit "insert/chart" by
mistake. (I use "insert/chart" a lot in my work.)

It is the consequence of this very easy mistake which is the problem. Forcing
me to crash out of LibreOffice loses all the work in ALL documents for up to 10
minutes the last auto-save. In my case this is three spreadsheets and a
document.

It seems that miguelangelrv already knows that this will cause calc problems
with his developer-esque comment 
    "What can we expect?. A graph with 100000 points and seven data series."

If you do not know how to 
    a) keep the UI responsive and
    b) insert an asynchronous cancel
without affecting performance, then maybe you should query the user's intent
before embarking on an endless?! task. 

NOTE: Performing this same task on a slightly less powerful machine in Excel
2010 produced a chart in 4 seconds.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210831/15649b39/attachment.htm>