Re: [libreoffice-users] Slow Calc Macros

Hi Onyeibo,
twohot schrieb:
> On 07/08/2011, Regina Henschel<rb.henschel@t-online.de>  wrote:
> > Hi,
> >
> > Onyeibo Oku schrieb:
> > > I did a python macro that adds sheets, renames them and fills in some
> > > formula in select cells. It also has a portion that deletes the
> > > sheets.
> > >
> > > I find that the sheet creation runs faster although there's more
> > > lines of code running. Whereas the sheet removal macro is just 2lines
> > > and runs 3-5times slower. Both routines use 'FOR' loops (the creating
> > > routine even has a nested loop).
> > >
> > > What could be responsible? Does calc recalculate for each removed
> > > sheet? Can that feature be toggled off via macro just before the
> > > removal loops ...and toggled back on?
> >
> > If you delete a sheet in the UI, then an undo object is generated. Does
> > this happen in your macro too?
> >
> > Kind regards
> > Regina
>
> Yes.
>
> You can undo almost everything done with a macro ... So far, I've been
> able to undo all changed made by my macros. I haven't come across an
> incomplete redo yet.

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

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