[Libreoffice-bugs] [Bug 131204] Exceptionally slow SORTING

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #5 from Colin <that.man.colin at gmail.com> ---
(In reply to m.a.riosv from comment #4)
> I think it's in relation with references in other places to data in the
> sorted range, e.g. Payout.AN FREQUENCY function, a lot of calculation needs
> to be done while sorting.

Does change control identify anything that has changed in the FREQUENCY
function since the previous release?

The data has been accumulated and maintained weekly for eight years. Whilst
loading from startup had sometimes been a cause for concern, the increased
functionality of the various analyses, as the volume of data increased or new
analytical functions (& sheets)were added, has never caused a slowdown of this
magnitude.

Perhaps it should also be noted that I misinterpreted the upload file metrics
and systematically removed all sheets except first and last. I then trimmed the
analyses on the last sheet so just the source numbers were maintained (the
larger font data and concatenation beneath). I then had to remove over 350 data
rows in sheet one. An insignificant change in sorting speed was observed.

Would it be pertinent to run a comparative test on an earlier version of Calc?

-- 
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/20200307/5239fc7a/attachment.htm>