CINXE.COM

<!DOCTYPE html> <html class="client-nojs" lang="en" dir="ltr"> <head> <meta charset="UTF-8"/> <title>Information and resources for LibreOffice macros - The Document Foundation Wiki</title> <script>document.documentElement.className="client-js";RLCONF={"wgBreakFrames":false,"wgSeparatorTransformTable":["",""],"wgDigitTransformTable":["",""],"wgDefaultDateFormat":"dmy","wgMonthNames":["","January","February","March","April","May","June","July","August","September","October","November","December"],"wgRequestId":"a32e5be5e65e577323cd5f22","wgCSPNonce":false,"wgCanonicalNamespace":"","wgCanonicalSpecialPageName":false,"wgNamespaceNumber":0,"wgPageName":"Macros","wgTitle":"Macros","wgCurRevisionId":759111,"wgRevisionId":759111,"wgArticleId":7244,"wgIsArticle":true,"wgIsRedirect":false,"wgAction":"view","wgUserName":null,"wgUserGroups":["*"],"wgCategories":["Documentation","Macros"],"wgPageContentLanguage":"en","wgPageContentModel":"wikitext","wgRelevantPageName":"Macros","wgRelevantArticleId":7244,"wgIsProbablyEditable":false,"wgRelevantPageIsProbablyEditable":false,"wgRestrictionEdit":[],"wgRestrictionMove":[],"wgVector2022PreviewPages":[],"wgULSAcceptLanguageList":[], "wgULSCurrentAutonym":"English","wgInternalRedirectTargetUrl":"/Macros","wgSmjUseCdn":false,"wgSmjUseChem":true,"wgSmjDisplayMath":[],"wgSmjExtraInlineMath":[],"wgSmjScale":1,"wgSmjEnableMenu":true,"wgSmjDisplayAlign":"left","wgTranslatePageTranslation":"source","wgULSPosition":"personal","wgULSisCompactLinksEnabled":true};RLSTATE={"skins.vector.user.styles":"ready","site.styles":"ready","user.styles":"ready","skins.vector.user":"ready","user":"ready","user.options":"loading","ext.translate":"ready","ext.translate.tag.languages":"ready","mediawiki.ui.button":"ready","skins.vector.styles":"ready","skins.vector.icons":"ready","mediawiki.ui.icon":"ready","ext.translate.edit.documentation.styles":"ready","ext.uls.pt":"ready"};RLPAGEMODULES=["mediawiki.action.view.redirect","ext.SimpleMathJax","site","mediawiki.page.ready","skins.vector.js","skins.vector.es6","mediawiki.misc-authed-pref","ext.translate.edit.documentation","ext.uls.compactlinks","ext.uls.interface"];</script> <script>(RLQ=window.RLQ||[]).push(function(){mw.loader.implement("user.options@12s5i",function($,jQuery,require,module){mw.user.tokens.set({"patrolToken":"+\\","watchToken":"+\\","csrfToken":"+\\"});});});</script> <link rel="stylesheet" href="/load.php?lang=en&modules=ext.translate%7Cext.translate.edit.documentation.styles%7Cext.translate.tag.languages%7Cext.uls.pt%7Cmediawiki.ui.button%2Cicon%7Cskins.vector.icons%2Cstyles&only=styles&skin=vector-2022"/> <script async="" src="/load.php?lang=en&modules=startup&only=scripts&raw=1&skin=vector-2022"></script> <meta name="ResourceLoaderDynamicStyles" content=""/> <link rel="stylesheet" href="/load.php?lang=en&modules=site.styles&only=styles&skin=vector-2022"/> <meta name="generator" content="MediaWiki 1.39.11"/> <meta name="format-detection" content="telephone=no"/> <meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=yes, minimum-scale=0.25, maximum-scale=5.0"/> <link rel="apple-touch-icon" href="/logo.svg"/> <link rel="icon" href="/favicon.ico"/> <link rel="search" type="application/opensearchdescription+xml" href="/opensearch_desc.php" title="The Document Foundation Wiki (en)"/> <link rel="EditURI" type="application/rsd+xml" href="https://wiki.documentfoundation.org/api.php?action=rsd"/> <link rel="license" href="https://creativecommons.org/licenses/by-sa/3.0/"/> <link rel="alternate" type="application/atom+xml" title="The Document Foundation Wiki Atom feed" href="/index.php?title=Special:RecentChanges&feed=atom"/> <link rel="alternate" type="application/rss+xml" title="The Document Foundation Wiki RSS feed" href="/index.php?title=Special:RecentChanges&feed=rss"/> </head> <body class="skin-vector skin-vector-search-vue mediawiki ltr sitedir-ltr mw-hide-empty-elt ns-0 ns-subject page-Macros rootpage-Macros skin-vector-2022 action-view skin--responsive vector-feature-language-in-header-enabled vector-feature-language-in-main-page-header-disabled vector-feature-language-alert-in-sidebar-disabled vector-feature-sticky-header-disabled vector-feature-sticky-header-edit-disabled vector-feature-table-of-contents-disabled vector-feature-visual-enhancement-next-disabled"><div class="mw-page-container"> <span id="top-page"></span> <a class="mw-jump-link" href="#content">Jump to content</a> <div class="mw-page-container-inner"> <input type="checkbox" id="mw-sidebar-checkbox" class="mw-checkbox-hack-checkbox" > <header class="mw-header"> <div class="mw-header-aside"> <label id="mw-sidebar-button" class="mw-checkbox-hack-button mw-ui-icon mw-ui-button mw-ui-quiet mw-ui-icon-element" for="mw-sidebar-checkbox" role="button" aria-controls="mw-panel" data-event-name="ui.sidebar" tabindex="0" title="Main menu"> <span>Toggle sidebar</span> </label> <a href="/Special:MyLanguage/Main_Page" class="mw-logo"> <span class="mw-logo-container"> <strong class="mw-logo-wordmark">The Document Foundation Wiki</strong> </span> </a> </div> <div class="mw-header-content"> <div id="p-search" role="search" class="vector-search-box-vue vector-search-box-collapses vector-search-box-show-thumbnail vector-search-box-auto-expand-width vector-search-box"> <a href="/Special:Search" title="Search The Document Foundation Wiki [f]" accesskey="f" class="mw-ui-button mw-ui-quiet mw-ui-icon mw-ui-icon-element mw-ui-icon-wikimedia-search search-toggle"> <span>Search</span> </a> <div> <form action="/index.php" id="searchform" class="vector-search-box-form"> <div id="simpleSearch" class="vector-search-box-inner" data-search-loc="header-moved"> <input class="vector-search-box-input" type="search" name="search" placeholder="Search The Document Foundation Wiki" aria-label="Search The Document Foundation Wiki" autocapitalize="sentences" title="Search The Document Foundation Wiki [f]" accesskey="f" id="searchInput" > <input type="hidden" name="title" value="Special:Search"> <input id="mw-searchButton" class="searchButton mw-fallbackSearchButton" type="submit" name="fulltext" title="Search the pages for this text" value="Search"> <input id="searchButton" class="searchButton" type="submit" name="go" title="Go to a page with this exact name if it exists" value="Go"> </div> </form> </div> </div> <nav class="vector-user-links" aria-label="Personal tools" role="navigation" > <div id="p-vector-user-menu-overflow" class="vector-menu mw-portlet mw-portlet-vector-user-menu-overflow vector-user-menu-overflow" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"><li id="ca-uls" class="user-links-collapsible-item mw-list-item active"><a href="#" class="uls-trigger mw-ui-button mw-ui-quiet"><span class="mw-ui-icon mw-ui-icon-wikimedia-language mw-ui-icon-wikimedia-wikimedia-language"></span> <span>English</span></a></li></ul> </div> </div> <div id="p-personal" class="vector-menu mw-portlet mw-portlet-personal vector-user-menu vector-user-menu-logged-out vector-menu-dropdown" title="More options" > <input type="checkbox" id="p-personal-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-p-personal" class="vector-menu-checkbox" /> <label id="p-personal-label" for="p-personal-checkbox" class="vector-menu-heading mw-ui-button mw-ui-quiet mw-ui-icon mw-ui-icon-element mw-ui-icon-ellipsis mw-ui-icon-wikimedia-ellipsis" > <span class="vector-menu-heading-label">Personal tools</span> </label> <div class="vector-menu-content"> <div class="vector-user-menu-create-account"><a href="/index.php?title=Special:CreateAccount&returnto=Macros" class="vector-menu-content-item user-links-collapsible-item" title="You are encouraged to create an account and log in; however, it is not mandatory"><span class="mw-ui-icon mw-ui-icon-userAdd mw-ui-icon-wikimedia-userAdd"></span> <span>Create account</span></a></div> <div class="vector-user-menu-login"><a href="/index.php?title=Special:UserLogin&returnto=Macros" class="vector-menu-content-item vector-menu-content-item-login" title="You are encouraged to log in; however, it is not mandatory [o]" accesskey="o"><span class="mw-ui-icon mw-ui-icon-logIn mw-ui-icon-wikimedia-logIn"></span> <span>Log in</span></a></div> <ul class="vector-menu-content-list"></ul> </div> </div> </nav> </div> </header> <div class="vector-sidebar-container vector-sidebar-container-no-toc"> <div id="mw-navigation"> <nav id="mw-panel" class="mw-sidebar" aria-label="Site" role="navigation"> <div id="p-navigation" class="vector-menu mw-portlet mw-portlet-navigation vector-menu-portal portal" > <div id="p-navigation-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Navigation</span> </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"><li id="n-mainpage-description" class="mw-list-item"><a href="/Special:MyLanguage/Main_Page" title="Visit the main page [z]" accesskey="z"><span>Main page</span></a></li><li id="n-getinvolved-description" class="mw-list-item"><a href="/Special:MyLanguage/Get_Involved"><span>Get Involved</span></a></li><li id="n-recentchanges" class="mw-list-item"><a href="/Special:RecentChanges" title="A list of recent changes in the wiki [r]" accesskey="r"><span>Recent changes</span></a></li><li id="n-randompage" class="mw-list-item"><a href="/Special:Random" title="Load a random page [x]" accesskey="x"><span>Random page</span></a></li><li id="n-donate-description" class="mw-list-item"><a href="https://www.libreoffice.org/donate/?pk_campaign=wiki"><span>Support LibreOffice!</span></a></li></ul> </div> </div> <div id="p-editinghelp" class="vector-menu mw-portlet mw-portlet-editinghelp vector-menu-portal portal" > <div id="p-editinghelp-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Editing the wiki</span> </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"><li id="n-helppage-description" class="mw-list-item"><a href="https://www.mediawiki.org/wiki/Special:MyLanguage/Help:Contents" rel="nofollow"><span>Help resources</span></a></li></ul> </div> </div> <div id="p-tb" class="vector-menu mw-portlet mw-portlet-tb vector-menu-portal portal" > <div id="p-tb-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">Tools</span> </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"><li id="t-whatlinkshere" class="mw-list-item"><a href="/Special:WhatLinksHere/Macros" title="A list of all wiki pages that link here [j]" accesskey="j"><span>What links here</span></a></li><li id="t-recentchangeslinked" class="mw-list-item"><a href="/Special:RecentChangesLinked/Macros" rel="nofollow" title="Recent changes in pages linked from this page [k]" accesskey="k"><span>Related changes</span></a></li><li id="t-specialpages" class="mw-list-item"><a href="/Special:SpecialPages" title="A list of all special pages [q]" accesskey="q"><span>Special pages</span></a></li><li id="t-print" class="mw-list-item"><a href="javascript:print();" rel="alternate" title="Printable version of this page [p]" accesskey="p"><span>Printable version</span></a></li><li id="t-permalink" class="mw-list-item"><a href="/index.php?title=Macros&oldid=759111" title="Permanent link to this revision of this page"><span>Permanent link</span></a></li><li id="t-info" class="mw-list-item"><a href="/index.php?title=Macros&action=info" title="More information about this page"><span>Page information</span></a></li></ul> </div> </div> </nav> </div> </div> <div class="vector-sitenotice-container"> <div id="siteNotice"></div> </div> <input type="checkbox" id="vector-toc-collapsed-checkbox" class="mw-checkbox-hack-checkbox"> <div class="mw-table-of-contents-container"> <div class="vector-sticky-toc-container mw-sticky-header-element"> </div> </div> <div class="mw-content-container"> <main id="content" class="mw-body" role="main"> <a id="top"></a> <header class="mw-body-header"> <div id="p-lang-btn" class="vector-menu mw-portlet mw-portlet-lang vector-menu-dropdown" > <input type="checkbox" id="p-lang-btn-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-p-lang-btn" class="vector-menu-checkbox mw-interlanguage-selector " aria-label="This article exist only in this language. Add the article for other languages" /> <label id="p-lang-btn-label" for="p-lang-btn-checkbox" class="vector-menu-heading mw-ui-progressive mw-portlet-lang-heading-0 mw-ui-button mw-ui-quiet" > <span class="mw-ui-icon mw-ui-icon-language-progressive mw-ui-icon-wikimedia-language-progressive"></span><span class="vector-menu-heading-label">Add languages</span> </label> <div class="vector-menu-content"> <ul class="vector-menu-content-list"></ul> <div class="after-portlet after-portlet-lang"><span class="uls-after-portlet-link"></span></div> </div> </div> <h1 id="firstHeading" class="firstHeading mw-first-heading">Information and resources for LibreOffice macros</h1> </header> <nav class="vector-article-toolbar" aria-label="Tools" role="navigation"> <div class="mw-article-toolbar-container"> <div id="left-navigation"> <div id="p-associated-pages" class="vector-menu mw-portlet mw-portlet-associated-pages vector-menu-tabs" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"><li id="ca-nstab-main" class="selected mw-list-item"><a href="/Macros" title="View the content page [c]" accesskey="c"><span>Page</span></a></li><li id="ca-talk" class="mw-list-item"><a href="/Talk:Macros" rel="discussion" title="Discussion about the content page [t]" accesskey="t"><span>Discussion</span></a></li></ul> </div> </div> <div id="p-variants" class="vector-menu mw-portlet mw-portlet-variants emptyPortlet vector-menu-dropdown" > <input type="checkbox" id="p-variants-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-p-variants" class="vector-menu-checkbox" aria-label="Change language variant" /> <label id="p-variants-label" for="p-variants-checkbox" class="vector-menu-heading " > <span class="vector-menu-heading-label">English</span> </label> <div class="vector-menu-content"> <ul class="vector-menu-content-list"></ul> </div> </div> </div> <div id="right-navigation" class="vector-collapsible "> <div id="p-views" class="vector-menu mw-portlet mw-portlet-views vector-menu-tabs" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"><li id="ca-view" class="selected mw-list-item"><a href="/Macros"><span>Read</span></a></li><li id="ca-viewsource" class="mw-list-item"><a href="/WikiAction/edit/Macros" title="This page is protected.
You can view its source [e]" accesskey="e"><span>View source</span></a></li><li id="ca-history" class="mw-list-item"><a href="/WikiAction/history/Macros" title="Past revisions of this page [h]" accesskey="h"><span>View history</span></a></li></ul> </div> </div> <div id="p-cactions" class="vector-menu mw-portlet mw-portlet-cactions emptyPortlet vector-menu-dropdown vector-has-collapsible-items" title="More options" > <input type="checkbox" id="p-cactions-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-p-cactions" class="vector-menu-checkbox" /> <label id="p-cactions-label" for="p-cactions-checkbox" class="vector-menu-heading " > <span class="vector-menu-heading-label">More</span> </label> <div class="vector-menu-content"> <ul class="vector-menu-content-list"><li id="ca-more-view" class="selected vector-more-collapsible-item mw-list-item"><a href="/Macros"><span>Read</span></a></li><li id="ca-more-viewsource" class="vector-more-collapsible-item mw-list-item"><a href="/WikiAction/edit/Macros"><span>View source</span></a></li><li id="ca-more-history" class="vector-more-collapsible-item mw-list-item"><a href="/WikiAction/history/Macros"><span>View history</span></a></li></ul> </div> </div> </div> </div> </nav> <div id="bodyContent" class="vector-body" data-mw-ve-target-container> <div class="mw-body-subheader"> <div class="mw-indicators"> </div> <div id="siteSub" class="noprint">From The Document Foundation Wiki</div> </div> <div id="mw-content-text" class="mw-body-content mw-content-ltr" lang="en" dir="ltr"><div class="mw-parser-output"><div class="plainlinks" style="background: black; padding: 1px 5px; border-width: 0 0 6px 0; border-style: solid; border-image: linear-gradient(to left, #0369A3, #18a303) 1; font-size: 88%; font-variant: all-small-caps; font-weight: bolder;"> <p><a class="external text" href="https://www.documentfoundation.org/"><span style="color:#fff; padding:0px 10px">TDF</span></a> <a class="external text" href="https://www.libreoffice.org/"><span style="color:#fff; padding:0px 10px">LibreOffice</span></a> <a rel="nofollow" class="external text" href="https://www.documentliberation.org/"><span style="color:#fff; padding:0px 10px">Document Liberation Project</span></a> <a class="external text" href="https://planet.documentfoundation.org/"><span style="color:#fff; padding:0px 10px">Community Blogs</span></a> <a class="external text" href="https://translations.documentfoundation.org/languages/en"><span style="color:#fff; padding:0px 10px">Weblate</span></a> <a class="external text" href="https://nextcloud.documentfoundation.org/"><span style="color:#fff; padding:0px 10px">Nextcloud</span></a> <a class="external text" href="https://redmine.documentfoundation.org"><span style="color:#fff; padding:0px 10px">Redmine</span></a> <a class="external text" href="https://ask.libreoffice.org"><span style="color:#fff; padding:0px 10px">Ask LibreOffice</span></a> <a class="external text" href="https://www.libreoffice.org/donate/"><span style="color:#fff; padding:0px 10px">Donate</span></a> </p> </div> <div class="lang" style="background: rgba( 0, 0, 0, 0.75 ); border:none; border-radius: 0 0 5px 5px; font-size: 105%; margin: 0; box-shadow: 0 2px 3px rgb(0, 0, 0, 0.1)"><ul> <li class="lang_main"><a href="/Special:MyLanguage/Main_Page" title="Special:MyLanguage/Main Page"><span style="color:#fff;">Wiki Home</span></a> </li> <li><a href="/Special:MyLanguage/Development" title="Special:MyLanguage/Development"><span style="color:#fff;">Development</span></a> </li> <li><a href="/Special:MyLanguage/Design" title="Special:MyLanguage/Design"><span style="color:#fff;">Design</span></a> </li> <li><a href="/Special:MyLanguage/QA" title="Special:MyLanguage/QA"><span style="color:#fff;">QA</span></a> </li> <li><a href="/Special:MyLanguage/Events" title="Special:MyLanguage/Events"><span style="color:#fff;">Events</span></a> </li> <li><a href="/Special:MyLanguage/Documentation" title="Special:MyLanguage/Documentation"><span style="color:#fff;">Documentation</span></a> </li> <li><a href="/Special:MyLanguage/Website" title="Special:MyLanguage/Website"><span style="color:#fff;">Website</span></a> </li> <li><a href="/Special:MyLanguage/Language" title="Special:MyLanguage/Language"><span style="color:#fff;">Localization</span></a> </li> <li><a href="/Special:MyLanguage/Accessibility" title="Special:MyLanguage/Accessibility"><span style="color:#fff;">Accessibility</span></a> </li> <li><a href="/Special:MyLanguage/Marketing" title="Special:MyLanguage/Marketing"><span style="color:#fff;">Marketing</span></a> </li> <li><a href="/Special:MyLanguage/Diversity" title="Special:MyLanguage/Diversity"><span style="color:#fff;">Diversity</span></a> </li> <li><a href="/Special:MyLanguage/Help:Editing" title="Special:MyLanguage/Help:Editing"><span style="color:#fff;">Wiki Help</span></a> </li> </ul></div> <div class="lang" style="background: none; border: none; font-stretch: condensed; margin-bottom: 0"><ul> <li class="lang_main"><a href="/Special:MyLanguage/Macros" title="Special:MyLanguage/Macros"><span style="color:#023f62; border-bottom:2px solid #023f62;">Macros</span></a> </li> <li><a href="/Special:MyLanguage/Macros/General" title="Special:MyLanguage/Macros/General"><span style="color:#023f62">General Macros</span></a> </li> <li><a href="/Special:MyLanguage/Macros/Writer" title="Special:MyLanguage/Macros/Writer"><span style="color:#023f62">Macros for Writer</span></a> </li> <li><a href="/Special:MyLanguage/Macros/Calc" title="Special:MyLanguage/Macros/Calc"><span style="color:#023f62">Macros for Calc</span></a> </li> <li><a href="/Special:MyLanguage/Macros/Impress" title="Special:MyLanguage/Macros/Impress"><span style="color:#023f62">Macros for Impress</span></a> </li> <li><a href="/Special:MyLanguage/Macros/Draw" title="Special:MyLanguage/Macros/Draw"><span style="color:#023f62">Macros for Draw</span></a> </li> <li><a href="/Special:MyLanguage/Macros/Base" title="Special:MyLanguage/Macros/Base"><span style="color:#023f62">Macros for Base</span></a> </li> <li><a href="/Special:MyLanguage/Macros/Math" title="Special:MyLanguage/Macros/Math"><span style="color:#023f62">Macros for Math</span></a> </li> <li><a href="/Special:MyLanguage/Macros#Documentation" title="Special:MyLanguage/Macros"><span style="color:#023f62; border-bottom:2px solid #023f62;">Basic/Python</span></a> </li> </ul></div> <p><br /> </p> <div class="mw-pt-languages noprint" lang="en" dir="ltr"><div class="mw-pt-languages-label">Other languages:</div><ul class="mw-pt-languages-list"><li><a href="/Macros/de" class="mw-pt-progress mw-pt-progress--complete" title="Makroprogrammierung in LibreOffice (89% translated)" lang="de" dir="ltr">Deutsch</a></li> <li><span class="mw-pt-languages-ui mw-pt-languages-selected mw-pt-progress mw-pt-progress--complete" lang="en" dir="ltr">English</span></li> <li><a href="/Macros/es" class="mw-pt-progress mw-pt-progress--complete" title="Información y recursos para macros con LibreOffice (89% translated)" lang="es" dir="ltr">español</a></li> <li><a href="/Macros/fr" class="mw-pt-progress mw-pt-progress--stub" title="Bienvenue sur les pages Macros francophones (19% translated)" lang="fr" dir="ltr">français</a></li> <li><a href="/Macros/it" class="mw-pt-progress mw-pt-progress--complete" title="Macro (100% translated)" lang="it" dir="ltr">italiano</a></li> <li><a href="/Macros/pl" class="mw-pt-progress mw-pt-progress--med" title="Informacje i zasoby dotyczące makr LibreOffice (52% translated)" lang="pl" dir="ltr">polski</a></li> <li><a href="/Macros/pt-br" class="mw-pt-progress mw-pt-progress--complete" title="Macros (89% translated)" lang="pt-BR" dir="ltr">português do Brasil</a></li> <li><a href="/Macros/ru" class="mw-pt-progress mw-pt-progress--med" title="Макросы (41% translated)" lang="ru" dir="ltr">русский</a></li> <li><a href="/Macros/uk" class="mw-pt-progress mw-pt-progress--complete" title="Макроси (100% translated)" lang="uk" dir="ltr">українська</a></li> <li><a href="/Macros/fa" class="mw-pt-progress mw-pt-progress--stub" title="ماکروها (19% translated)" lang="fa" dir="rtl">فارسی</a></li> <li><a href="/Macros/ja" class="mw-pt-progress mw-pt-progress--complete" title="LibreOfficeマクロの情報源 (96% translated)" lang="ja" dir="ltr">日本語</a></li></ul></div> <div class="contentgrid" style="margin: 0 auto 1em; display: grid; grid-template-columns: repeat(auto-fit, minmax(310px, 1fr)); grid-gap: 10px; grid-auto-rows: minmax(350px, auto); width: auto;"> <div class="portal-box" style="display: flex; flex-direction: column;"> <div style="background-image: linear-gradient(#fff, #ccf4c6); border-bottom: 1px solid white; padding: 3px 15px; font-size: 1.2em; color: #18a303; font-weight: bold; text-shadow: #fff 0px 1px 1px;">Documentation for macro writers and users</div> <div style="border: 1px solid #92e285; box-shadow: 0px 1px 3px #ddedc9; padding: 5px 15px 20px; background: #fff; flex-grow:1"> <h3><span id="Andrew.27s_Macros"></span><span class="mw-headline" id="Andrew's_Macros">Andrew's Macros</span></h3> <p>A chronicle of information on the basic macro language with example scripts by Andrew Pitonyak. </p> <ul><li><a rel="nofollow" class="external text" href="https://www.pitonyak.org/oo.php">www.pitonyak.org</a> (<a rel="nofollow" class="external text" href="https://www.pitonyak.org/OOME_3_0.odt">as ODT</a>, as <a rel="nofollow" class="external text" href="https://www.pitonyak.org/OOME_3_0.pdf">PDF</a>)</li></ul> <h3><span class="mw-headline" id="LibreOffice_Basic_Guides">LibreOffice Basic Guides</span></h3> <ul><li><a href="/Special:MyLanguage/Macros/Basic_reference" title="Special:MyLanguage/Macros/Basic reference">Basic Programmer's reference</a></li> <li><a href="/images/d/dd/BasicGuide_OOo3.2.0.odt" class="internal" title="BasicGuide OOo3.2.0.odt">OO.o Basic Programmer's guide</a> (odt, <a rel="nofollow" class="external text" href="https://wiki.openoffice.org/w/images/c/c1/BasicGuide_OOo3.2.0.pdf">pdf</a>) <ul><li><a rel="nofollow" class="external text" href="https://web.archive.org/web/20090330112102/http://dlc.sun.com/pdf/819-1326/819-1326.pdf">StarOffice 8 Programmierhandbuch für BASIC 8</a>, 2005 in german (<a rel="nofollow" class="external text" href="https://web.archive.org/web/20090306185036/http://dlc.sun.com/pdf/819-0439/819-0439.pdf">in English</a>)</li> <li><a rel="nofollow" class="external text" href="https://docs.oracle.com/cd/E19064-01/so7/817-3924/817-3924.pdf">StarOffice 7 Office Suite - Basic Programmierhandbuch</a>, 2003 in german (<a rel="nofollow" class="external text" href="https://docs.oracle.com/cd/E19064-01/so7/817-1826/817-1826.pdf">in English</a>)</li></ul></li> <li><a href="/Documentation/BASIC_Guide" title="Documentation/BASIC Guide">LibreOffice Basic Guide</a> <ul><li><a rel="nofollow" class="external text" href="https://wiki.openoffice.org/wiki/Documentation/BASIC_Guide">OO.o historic Basic Guide website</a></li></ul></li> <li><a rel="nofollow" class="external text" href="https://www.debugpoint.com/libreoffice-basic-macro-tutorial-index/">LibreOffice Basic Macro Tutorials</a></li> <li><a rel="nofollow" class="external text" href="https://www.openoffice.org/api/basic/man/tutorial/tutorial.pdf">StarOffice (Basic) programmer's Tutorial, May 2000</a></li></ul> <h3><span class="mw-headline" id="LibreOffice_API">LibreOffice API</span></h3> <p>LibreOffice scripts make use of the LibreOffice API , documentation is available at: </p> <ul><li><a class="external text" href="https://api.libreoffice.org">api.libreoffice.org</a></li> <li><a href="/Documentation/DevGuide/LibreOffice_Developers_Guide" title="Documentation/DevGuide/LibreOffice Developers Guide">LibreOffice Developer's Guide</a> <ul><li><a rel="nofollow" class="external text" href="https://wiki.openoffice.org/w/images/d/d9/DevelopersGuide_OOo3.1.0.pdf">Historic OpenOffice.org 3.1 Developer's Guide</a></li></ul></li> <li><a class="external text" href="https://help.libreoffice.org/latest/en-US/text/sbasic/shared/03/lib_ScriptForge.html?DbPAR=BASIC">ScriptForge Library</a></li> <li><a rel="nofollow" class="external text" href="https://flywire.github.io/lo-p/index.html">LibreOffice Programming</a></li></ul> <h3><span class="mw-headline" id="Python_as_a_macro_language">Python as a macro language</span></h3> <p>It is possible to use python as a macro language, more details can be found at this page here: </p> <ul><li><a rel="nofollow" class="external text" href="https://wiki.openoffice.org/wiki/Python_as_a_macro_language">Python as a macro language</a></li></ul> <h3><span class="mw-headline" id="LibreOffice_Python_Guides">LibreOffice Python Guides</span></h3> <ul><li><a href="/Special:MyLanguage/Macros/Python_Guide" title="Special:MyLanguage/Macros/Python Guide">Python Programmer's guide</a></li> <li><a href="/Special:MyLanguage/Macros/Python_Design_Guide" title="Special:MyLanguage/Macros/Python Design Guide">Designing & Developing Python applications</a></li></ul> </div> </div> <div class="portal-box" style="display: flex; flex-direction: column;"> <div style="background-image: linear-gradient(#fff, #ccf4c6); border-bottom: 1px solid white; padding: 3px 15px; font-size: 1.2em; color: #18a303; font-weight: bold; text-shadow: #fff 0px 1px 1px;">Tools - Collections</div> <div style="border: 1px solid #92e285; box-shadow: 0px 1px 3px #ddedc9; padding: 5px 15px 20px; background: #fff; flex-grow:1"> <h3><span id="Toma.C5.BE.27s_Development_Tools"></span><span class="mw-headline" id="Tomaž's_Development_Tools">Tomaž's Development Tools</span></h3> <ul><li>Since LibreOffice 7.2, an object inspector tool is included, found under <code>Tools -> Development Tools</code> (see <a class="external text" href="https://wiki.documentfoundation.org/ReleaseNotes/7.2#Core_.2F_General">release notes</a>).</li> <li>The tool is similar to the X-Ray and MRI extensions mentioned below.</li> <li>Read more in Tomaž's blog posts: <a rel="nofollow" class="external text" href="https://tomazvajngerl.blogspot.com/2021/01/built-in-xray-like-uno-object-inspector.html">part1</a> <a rel="nofollow" class="external text" href="https://tomazvajngerl.blogspot.com/2021/03/built-in-xray-like-uno-object-inspector.html">part2</a> <a rel="nofollow" class="external text" href="https://tomazvajngerl.blogspot.com/2021/03/built-in-xray-like-uno-object-inspector_24.html">part3</a></li></ul> <h3><span class="mw-headline" id="Extensions">Extensions</span></h3> <ul><li><a rel="nofollow" class="external text" href="https://web.archive.org/web/20221202175301/https://berma.pagesperso-orange.fr/">X-Ray</a> (via the WayBackMachine) Basic macro is displaying API objects and is exploring their content. It also displays most Basic datatypes. Its integration of API documentation for services, interfaces, properties and methods is limited to OpenOffice.</li> <li><a class="external text" href="https://extensions.libreoffice.org/extensions/apso-alternative-script-organizer-for-python">Alternative Python script organizer (apso)</a> helps managing Python modules as LibreOffice or OpenOffice libraries.</li> <li><a rel="nofollow" class="external text" href="https://extensions.openoffice.org/en/project/mri-uno-object-inspection-tool">MRI</a> It is not always clear at design time which services a UNO object actually supports. MRI (My Reflection and Introspection) displays the properties, methods, services, interfaces which are provided by an object variable (<a rel="nofollow" class="external text" href="https://github.com/hanya/MRI/releases/latest">latest release</a>).</li></ul> <h3><span id="Lanedo_Labs_.28archived.29"></span><span class="mw-headline" id="Lanedo_Labs_(archived)">Lanedo Labs (archived)</span></h3> <ul><li><a rel="nofollow" class="external text" href="https://web.archive.org/web/*/http://labs.lanedo.com/libreoffice/spreadsheet-population/">Spreadsheet Population</a></li> <li><a rel="nofollow" class="external text" href="https://web.archive.org/web/*/http://labs.lanedo.com/libreoffice/mailmerge/">Mail Merge</a></li></ul> <h3><span class="mw-headline" id="Code_Snippets">Code Snippets</span></h3> <p>A set of code snippets in Basic covering many parts of LibreOffice: </p> <ul><li><a href="/Macros/Basic_Primitives" title="Macros/Basic Primitives">Primitives in Basic</a></li></ul> <p>The OpenOffice CodeSnippet website had a collection of macros in various scripting languages: </p> <ul><li><a rel="nofollow" class="external text" href="http://codesnippets.services.openoffice.org">http://codesnippets.services.openoffice.org</a> <ul><li>Note - the site is down, but the page is still available through the <span class="plainlinks"><a rel="nofollow" class="external text" href="https://en.wikipedia.org/wiki/Wayback_Machine">Wayback Machine</a>⁠<img alt="Wikipedia logo v3.svg" src="/images/a/a7/Wikipedia_logo_v3.svg" decoding="async" loading="lazy" width="12" height="12" /></span> at <a rel="nofollow" class="external text" href="https://web.archive.org/web/20121229130246/http://codesnippets.services.openoffice.org/index.xml">archive.org</a>.</li></ul></li></ul> </div> </div> </div>   </div> <div class="printfooter" data-nosnippet="">Retrieved from "<a dir="ltr" href="https://wiki.documentfoundation.org/index.php?title=Macros&oldid=759111">https://wiki.documentfoundation.org/index.php?title=Macros&oldid=759111</a>"</div></div> <div id="catlinks" class="catlinks" data-mw="interface"><div id="mw-normal-catlinks" class="mw-normal-catlinks"><a href="/Special:Categories" title="Special:Categories">Categories</a>: <ul><li><a href="/Category:Documentation" title="Category:Documentation">Documentation</a></li><li><a href="/Category:Macros" title="Category:Macros">Macros</a></li></ul></div></div> </div> </main> </div> <div class="mw-footer-container"> <footer id="footer" class="mw-footer" role="contentinfo" > <ul id="footer-info"> <li id="footer-info-credits">This page was last edited 11:03, 6 July 2024 by <a href="/WikiAction/edit/User:Mikekaganski?redlink=1" class="new mw-userlink" title="User:Mikekaganski (page does not exist)"><bdi>Mike Kaganski</bdi></a>. Based on work by <a href="/User:Bantoniof" class="mw-userlink" title="User:Bantoniof"><bdi>B.Antonio Fernández</bdi></a> and <a href="/User:Beluga" class="mw-userlink" title="User:Beluga"><bdi>Ilmari Lauhakangas</bdi></a> and <a href="/WikiAction/credits/Macros" title="Macros">others</a>.</li> <li id="footer-info-copyright">Please note that all contributions to The Document Foundation Wiki are considered to be released under the <a href="https://creativecommons.org/licenses/by-sa/3.0/">Creative Commons Attribution-ShareAlike 3.0 Unported License</a>, unless otherwise specified. This does not include the source code of LibreOffice, which is licensed under the GNU Lesser General Public License (<a href="https://www.libreoffice.org/download/license/">LGPLv3</a>). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our <a href="/TradeMark_Policy">trademark policy</a> (see <a href="/Project:Copyrights">Project:Copyrights</a> for details). LibreOffice was based on OpenOffice.org.<br/>If you do not want your writing to be edited mercilessly and redistributed at will, then do not submit it here.</li> </ul> <ul id="footer-places"> <li id="footer-places-privacy"><a href="/Project:Privacy_Policy">Privacy policy</a></li> <li id="footer-places-about"><a href="/Project:About">About The Document Foundation Wiki</a></li> <li id="footer-places-disclaimer"><a href="/Project:General_disclaimer">Imprint</a></li> </ul> <ul id="footer-icons" class="noprint"> <li id="footer-copyrightico"><a href="https://creativecommons.org/licenses/by-sa/3.0/"><img src="/resources/assets/licenses/cc-by-sa.png" alt="the <a href="https://creativecommons.org/licenses/by-sa/3.0/">Creative Commons Attribution-ShareAlike 3.0 Unported License</a>, unless otherwise specified. This does not include the source code of LibreOffice, which is licensed under the <a href="https://www.libreoffice.org/download/license/">Mozilla Public License v2.0</a>. "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our <a href="/TradeMark Policy">trademark policy</a> (see <a href="/Project:Copyrights">Project:Copyrights</a> for details). LibreOffice was based on OpenOffice.org.<br/>If you do not want your writing to be edited mercilessly and redistributed at will, then do not submit it here." width="88" height="31" loading="lazy"/></a></li> <li id="footer-poweredbyico"><a href="https://www.mediawiki.org/"><img src="/resources/assets/poweredby_mediawiki_88x31.png" alt="Powered by MediaWiki" srcset="/resources/assets/poweredby_mediawiki_132x47.png 1.5x, /resources/assets/poweredby_mediawiki_176x62.png 2x" width="88" height="31" loading="lazy"/></a></li> </ul> </footer> </div> </div> </div> <script>(RLQ=window.RLQ||[]).push(function(){mw.config.set({"wgPageParseReport":{"limitreport":{"cputime":"0.081","walltime":"0.096","ppvisitednodes":{"value":935,"limit":1000000},"postexpandincludesize":{"value":16689,"limit":2097152},"templateargumentsize":{"value":7012,"limit":2097152},"expansiondepth":{"value":9,"limit":100},"expensivefunctioncount":{"value":0,"limit":100},"unstrip-depth":{"value":0,"limit":20},"unstrip-size":{"value":1950,"limit":5000000},"timingprofile":["100.00% 76.494 1 -total"," 11.74% 8.984 1 Template:Menu.Macros"," 8.12% 6.208 1 Template:TopMenu"," 7.94% 6.076 1 Template:Menu"," 7.67% 5.870 9 Template:SubMenuEntryAlternative"," 5.60% 4.286 9 Template:MenuEntryAlternative"," 4.37% 3.339 2 Template:Portal_box"," 3.55% 2.717 12 Template:MenuEntry"," 2.69% 2.059 1 Template:Wikipedia"," 2.09% 1.597 9 Template:TopMenuEntry"]},"cachereport":{"origin":"wiki","timestamp":"20250221163518","ttl":1209600,"transientcontent":false}}});});</script>  <script type="text/javascript"> var _paq = _paq || []; _paq.push(["disableCookies"]); _paq.push(["trackPageView"]); _paq.push(["enableLinkTracking"]); (function() { var u = (("https:" == document.location.protocol) ? "https" : "http") + "://"+"piwik.documentfoundation.org/"; _paq.push(["setTrackerUrl", u+"piwik.php"]); _paq.push(["setSiteId", "44"]); var d=document, g=d.createElement("script"), s=d.getElementsByTagName("script")[0]; g.type="text/javascript"; g.defer=true; g.async=true; g.src=u+"piwik.js"; s.parentNode.insertBefore(g,s); })(); </script>   <noscript><img src="https://piwik.documentfoundation.org/piwik.php?idsite=44&rec=1" style="border:0" alt="" /></noscript>  <script>(RLQ=window.RLQ||[]).push(function(){mw.config.set({"wgBackendResponseTime":158,"wgHostname":"wiki"});});</script> </body> </html>