Re: [libreoffice-users] Slow Calc Macros

On 07/08/2011 17:39, Regina Henschel wrote:
> Hi Onyeibo,
>
> Perhaps 'undo' is the reason, that delete is slower than insert. But I
> don't know any way to disable 'undo' to test my guess.
>
> Kind regards
> Regina

Played around the code.  Seems COUNTIF's and COUNTBLANK's perform
expensive iterations so I replaced those. Now the deletion speed is
nearly same as the creation speed ... I wish I can get more speed though
:) I'd hate to run this in M$ Office and get a better performance with
VBA.  I hope that doesn't happen because I need to convince my employers
that Open-Source is the way forward.

Hmm, so LibreOffice stores strings in unicode. Interesting.  Why didn't
any of you guru-istic forerunners tell me I could use the terminal for
debugging?  This is so sweet. :)



-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted