Johnny Rosenberg <gurus.knugum <at> gmail.com> writes:
Just don't never ever use the macro recorder. It's crap and will never be anything else. There is an alternative macro recorder somewhere to install that is slightly better, but the best thing to do (as far as I know) is to install (and use) xray and learn from others, maybe http://www.pitonyak.org/oo.php could be a good start. Kind regards Johnny Rosenberg
You're right Johnny R., the macro recorder catches and writes all dispatches with java-level naming, and so they're not documented in libreoffice's api help (I think...) The forum I named on the original message [0] lead me to the accurate instruction to copy sheets: oDoc.getSheets().copyByName( sOld, sNew, iNum ) which is documented in [1]. Doesn't cover the case of sheets from other books/files opened, but I think it will be enough pointing sOld and sNew spreadsheets objects to their container book. [0] http://www.oooforum.org/forum/viewtopic.phtml?t=44818 [1] http://api.libreoffice.org/common/ref/com/sun/star/sheet/XSpreadsheets.html -- 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