On 07/08/2011, Regina Henschel <[email protected]> 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. Regards Onyeibo -- For unsubscribe instructions e-mail to: [email protected] 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
