Re: [libreoffice-users] Slow Calc Macros

Do not know if this will aid you in the testing, but here goes.

1. Open Calc or  Write,
2. Go To:  Tools --> Option,
3. Select (expand): LibreOffice,
4. Select: Memory,
5. Under:  Undo,
6. Set 'Number of steps', to zero '0',
7. Click on the 'Ok' button,
8. Close LibreOffice,
9. Reopen LibreOffice,
10. Conduct test.

Reset to 'Number of steps', to zero '100' when done.

Please let us all know if this works for you.

On 8/13/2011 10:19 AM, Onyeibo Oku wrote:
> 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. :)

--


Joe Baker       
Systems / Network / Web Administration
IT Consulting
JEBWEBS at Gmail dot com

The information supplied herein is believed to be correct but the accuracy thereof is not 
guaranteed. The company and its employees cannot accept liability for any loss suffered in 
consequence of reliance on the information provided. Provision of this data does not obviate the 
need to make further appropriate inquiries, analysis and inspections. The information supplied is 
intended for the recipient only.




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