<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:shane@graduate.uwa.edu.au" title="Shane <shane@graduate.uwa.edu.au>"> <span class="fn">Shane</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - Substantial performance deterioration by scroll through cells via macro in LibreOffice Calc"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=78254">bug 78254</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>shane@graduate.uwa.edu.au
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Substantial performance deterioration by scroll through cells via macro in LibreOffice Calc"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=78254#c15">Comment # 15</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Substantial performance deterioration by scroll through cells via macro in LibreOffice Calc"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=78254">bug 78254</a>
from <span class="vcard"><a class="email" href="mailto:shane@graduate.uwa.edu.au" title="Shane <shane@graduate.uwa.edu.au>"> <span class="fn">Shane</span></a>
</span></b>
<pre>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)...</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>