[Libreoffice-bugs] [Bug 78254] Substantial performance deterioration by scroll through cells via macro in LibreOffice Calc

[bugzilla-daemon at bugs.documentfoundation.org]

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

Shane <shane at graduate.uwa.edu.au> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |shane at graduate.uwa.edu.au

--- Comment #15 from Shane <shane at graduate.uwa.edu.au> ---
I challenge whether this is truly of low importance and minor significance.
Perhaps it is because not too many people use complex macros? But for people
using any significant macros this represents a substantial obstacle to moving
to LibreOffice.

In my case I am trying to move to LibreOffice from OpenOffice but it has made
some of my automation unviable. If MS Office performance figures are so many
orders of magnitude better then one can only imagine it could also present a
major hurdle to uptake of LibreOffice for some MS Office users too.

If we know that a flood of GetOptimalHeightsInColumn calls seem to be the
culprit here is there any kind of workaround to improve scrolling speed in a
macro? 

I have tried 

ThisComponent.LockControllers
ThisComponent.addActionLock()

and

ThisComponent.CurrentController.Frame.ContainerWindow.setEnable(False)

and, without timing anything too accurately, none of these seem to have
improved performance of my macro at all - it always takes an unacceptably long
time in LibreOffice 5.4.3.2 compared to the same code running in OpenOffice
4.1.3 (which isn't fast but is tolerable)...

-- 
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/20171210/116d4e98/attachment-0001.html>