<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED FIXED - FILTER : Calc Macro hangs when CopyOutputData = True"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=104865#c21">Comment # 21</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED FIXED - FILTER : Calc Macro hangs when CopyOutputData = True"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=104865">bug 104865</a>
from <span class="vcard"><a class="email" href="mailto:l.lunak@collabora.com" title="Luboš Luňák <l.lunak@collabora.com>"> <span class="fn">Luboš Luňák</span></a>
</span></b>
<pre>(In reply to Xisco Faulí from <a href="show_bug.cgi?id=104865#c17">comment #17</a>)
<span class="quote">> (In reply to Luboš Luňák from <a href="show_bug.cgi?id=104865#c16">comment #16</a>)
> > It does not, it's just busy copying all cells that do not equal the
> > criteria, which also all the empty cells in the sheet. If you add a
> > condition that the cell shouldn't be empty, it's fine.
>
> I see, should it be treat as a performance issue in another ticket?</span >
I don't understand BASIC scripting much, but AFAICT the macro checks the entire
sheet for cells that are not equal to the given strings. And empty cells also
are not equal to those strings. Since the macro asks to copy such data, LO ends
up copying pretty much the entire sheet.
I'd probably keep this as closed until an actual user complains (and explains
why LO shouldn't be slow in such a case).</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>