[Libreoffice-bugs] [Bug 69977] freeze/crash when creating a diagram from many thousand cells

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #20 from Heiko Tietze <heiko.tietze at documentfoundation.org> ---
(In reply to Noel Grandin from comment #19)
> (*) several of our chart2 types (e.g. pie) should not allow more than X
> categories before just putting all remaining data into a "remaining" category

Sounds reasonable but not so easy to implement unless the data is sorted.
Otherwise you end up with 10x 0.1% plus 99% in the remaining category.

> (*) possibly we should choose Data Range before choosing Chart Type

Sure, naturally the first step. Not sure it solves the issue however. Most
users may just click over this step.

> (*) if choosing a really large data range, the user should be warned that
> the chart may be slow

That's what we do in similar situations. For instance recently for bug 134779.

> (*) if the user does not explicitly choose a Data Range before opening the
> chart wizard, we should only select the currently visible page or some other
> small subset of the data

Error-prone, people are used to get everything selected.

> (*) some of the internals of the chart wizard should just "do nothing" or
> add some warning message if presented with too much data e.g. if the user
> does something that ends up creating > 1000 tick marks, just display a
> single tick that says "too may ticks"

> (*) there are definitely some bugs here e.g. the tick creation logic is
> supposed to self-limit by increasing the tick-interval until the ticks stop
> overlapping, but that is not happening here

Thought we have this Automatic function. What I have in mind is the minor
interval (set to 2 in the example at comment 0). But changing this to 10 has no
effect and is always reverted to automatic.


(*) another option is to kick the can down the road: a pie chart with 5k
entries is done within <5s on my machine; the maximum of 100k takes a bit
longer...

-- 
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/20210201/0371fa03/attachment.htm>