[Libreoffice-bugs] [Bug 104865] FILTER : Calc Macro hangs when CopyOutputData = True

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #21 from Luboš Luňák <l.lunak at collabora.com> ---
(In reply to Xisco Faulí from comment #17)
> (In reply to Luboš Luňák from comment #16)
> > 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?

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).

-- 
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/20200702/5e4beed5/attachment.htm>