Document Event-Driven Macros

This section describes how to assign scripts to application, document or form events.

You can automatically execute a macro when a specified software event occurs by assigning the desired macro to the event. The following table provides an overview of document events and at what point an assigned macro is executed.

แƒ›แƒแƒ•แƒšแƒ”แƒœแƒ

An assigned macro is executed...

routine

แƒžแƒ แƒแƒ’แƒ แƒแƒ›แƒ˜แƒก แƒ“แƒแƒฌแƒงแƒ”แƒ‘แƒ

...after a LibreOffice application is started.

OnStartApp

แƒžแƒ แƒแƒ’แƒ แƒแƒ›แƒ˜แƒก แƒ“แƒแƒฎแƒฃแƒ แƒ•แƒ

...before a LibreOffice application is terminated.

OnCloseApp

แƒ“แƒแƒ™แƒฃแƒ›แƒ”แƒœแƒขแƒ˜ แƒจแƒ”แƒ˜แƒฅแƒ›แƒœแƒ

...New document created with File - New or with the New icon. Note that this event also fires when Basic IDE opens.

OnCreate

แƒขแƒ”แƒฅแƒกแƒขแƒฃแƒ แƒ˜ แƒ“แƒแƒ™แƒฃแƒ›แƒ”แƒœแƒขแƒ˜

...after a new document is created with File - New or with the New icon.

OnNew

แƒ“แƒแƒ™แƒฃแƒ›แƒ”แƒœแƒขแƒ˜แƒก แƒฉแƒแƒขแƒ•แƒ˜แƒ แƒ—แƒ•แƒ แƒ“แƒแƒกแƒ แƒฃแƒšแƒ“แƒ

...before a document is opened with File - Open or with the Open icon.

OnLoadFinished

แƒ“แƒแƒ™แƒฃแƒ›แƒ”แƒœแƒขแƒ˜แƒก แƒ’แƒแƒฎแƒกแƒœแƒ

...after a document is opened with File - Open or with the Open icon.

OnLoad

แƒ“แƒแƒ™แƒฃแƒ›แƒ”แƒœแƒขแƒ˜ แƒ“แƒแƒ˜แƒฎแƒฃแƒ แƒ”แƒ‘แƒ

...before a document is closed.

OnPrepareUnload

แƒ“แƒแƒ™แƒฃแƒ›แƒ”แƒœแƒขแƒ˜ แƒ“แƒแƒ˜แƒฎแƒฃแƒ แƒ

...after a document was closed. Note that the "Save Document" event may also occur when the document is saved before closing.

OnUnload

-no UI-

OnLayoutFinished

แƒฎแƒ”แƒ“แƒ˜ แƒจแƒ”แƒ˜แƒฅแƒ›แƒœแƒ

Document is displayed. Note that this event also happens when a document is duplicated.

OnViewCreated

แƒฎแƒ”แƒ“แƒ˜ แƒ“แƒแƒ˜แƒฎแƒฃแƒ แƒ”แƒ‘แƒ

Document layout is getting removed.

OnPrepareViewClosing

แƒฎแƒ”แƒ“แƒ˜ แƒ“แƒแƒ˜แƒฎแƒฃแƒ แƒ

Document layout is cleared prior to the document closure.

OnViewClosed

แƒ“แƒแƒ™แƒฃแƒ›แƒ”แƒœแƒขแƒ˜แƒก แƒแƒฅแƒขแƒ˜แƒ•แƒ˜แƒ แƒ”แƒ‘แƒ

...after a document is brought to the foreground.

OnFocus

แƒ“แƒแƒ™แƒฃแƒ›แƒ”แƒœแƒขแƒ˜แƒก แƒ“แƒ”แƒแƒฅแƒขแƒ˜แƒ•แƒ˜แƒ แƒ”แƒ‘แƒ

...after another document is brought to the foreground.

OnUnfocus

แƒ“แƒแƒ™แƒฃแƒ›แƒ”แƒœแƒขแƒ˜แƒก แƒจแƒ”แƒœแƒแƒฎแƒ•แƒ

...before a document is saved with File - Save or the Save icon, provided that a document name has already been specified.

OnSaveAs

แƒ“แƒแƒ™แƒฃแƒ›แƒ”แƒœแƒขแƒ˜ แƒจแƒ”แƒœแƒแƒฎแƒฃแƒšแƒ˜แƒ

...after a document is saved with File - Save or the Save icon, provided that a document name has already been specified.

OnSaveDone

แƒ“แƒแƒ™แƒฃแƒ›แƒ”แƒœแƒขแƒ˜แƒก แƒจแƒ”แƒœแƒแƒฎแƒ•แƒ แƒฉแƒแƒ•แƒแƒ แƒ“แƒ

Document could not be saved.

OnSaveFailed

แƒ“แƒแƒ™แƒฃแƒ›แƒ”แƒœแƒขแƒ˜แƒก แƒจแƒ”แƒœแƒแƒฎแƒ•แƒ แƒ แƒแƒ’แƒแƒ แƒช

...before a document is saved under a specified name (with File - Save As, or with File - Save or the Save icon, if a document name has not yet been specified).

OnSaveAs

แƒ“แƒแƒ™แƒฃแƒ›แƒ”แƒœแƒขแƒ˜แƒก แƒจแƒ”แƒœแƒแƒฎแƒฃแƒšแƒ˜แƒ แƒ แƒแƒ’แƒแƒ แƒช

... after a document was saved under a specified name (with File - Save As, or with File - Save or with the Save icon, if a document name has not yet been specified).

OnSaveAsDone

'Save As' has failed

Document could not be saved.

OnSaveAsFailed

-no UI-

When the document disk location has changed, for example after a File - Save As action.

OnStorageChanged

แƒ“แƒแƒ™แƒฃแƒ›แƒ”แƒœแƒขแƒ˜แƒก แƒแƒกแƒšแƒ˜แƒก แƒจแƒ”แƒœแƒแƒฎแƒ•แƒ แƒแƒœ แƒ’แƒแƒขแƒแƒœแƒ

...before a document is saved with File - Save a Copy, File - Export, File - Export as PDF or the Save icons.

OnCopyTo

แƒจแƒ”แƒ˜แƒฅแƒ›แƒœแƒ แƒ“แƒแƒ™แƒฃแƒ›แƒ”แƒœแƒขแƒ˜แƒก แƒแƒกแƒšแƒ˜

...after a document is saved with File - Save a Copy, File - Export, File - Export as PDF or the Save icons.

OnCopyToDone

แƒ“แƒแƒ™แƒฃแƒ›แƒ”แƒœแƒขแƒ˜แƒก แƒแƒกแƒšแƒ˜แƒก แƒจแƒ”แƒฅแƒ›แƒœแƒ แƒฉแƒแƒ•แƒแƒ แƒ“แƒ

Document could not be copied or exported.

OnCopyToFailed

แƒ“แƒแƒ™แƒฃแƒ›แƒ”แƒœแƒขแƒ˜แƒก แƒ“แƒแƒ‘แƒ”แƒญแƒ“แƒ•แƒ

...after the Print dialog is closed, but before the actual print process begins. This event occurs for each copy printed.

OnPrint

-no UI-

...after document security settings have changed.

OnModeChanged

'แƒจแƒ”แƒชแƒ•แƒšแƒ˜แƒšแƒ˜แƒ' แƒกแƒขแƒแƒขแƒฃแƒกแƒ˜ แƒจแƒ”แƒ˜แƒชแƒ•แƒแƒšแƒ

Modified state of a document has changed.

OnModifyChanged

แƒ“แƒแƒ™แƒฃแƒ›แƒ”แƒœแƒขแƒ˜แƒก แƒกแƒแƒ—แƒแƒฃแƒ แƒ˜ แƒจแƒ”แƒ˜แƒชแƒ•แƒแƒšแƒ

When the document title gets updated.

OnTitleChanged

แƒฅแƒ•แƒ”แƒ™แƒแƒ›แƒžแƒแƒœแƒ”แƒœแƒขแƒ˜ แƒฉแƒแƒ˜แƒขแƒ•แƒ˜แƒ แƒ—แƒ

...after a database form has been opened.

OnSubComponentOpened

แƒฅแƒ•แƒ”แƒ™แƒแƒ›แƒžแƒแƒœแƒ”แƒœแƒขแƒ˜ แƒ“แƒแƒ˜แƒฎแƒฃแƒ แƒ

...after a database form has been closed.

OnSubComponentClosed

แƒคแƒแƒ แƒ›แƒ˜แƒก แƒฌแƒ”แƒ แƒขแƒ˜แƒšแƒ”แƒ‘แƒ˜แƒก แƒ‘แƒ”แƒญแƒ“แƒ•แƒ แƒ“แƒแƒ˜แƒฌแƒงแƒ

...before printing form letters using File - Print or Tools - Mail Merge Wizard menus.

OnMailMerge

แƒคแƒแƒ แƒ›แƒ˜แƒก แƒฌแƒ”แƒ แƒ˜แƒšแƒ”แƒ‘แƒ˜แƒก แƒ‘แƒ”แƒญแƒ“แƒ•แƒ แƒ“แƒแƒกแƒ แƒฃแƒšแƒ“แƒ

...after printing of form letters using File - Print or Tools - Mail Merge Wizard menus.

OnMailMergeFinished

Printing of form fields started

...before printing form fields.

OnFieldMerge

Printing of form fields finished

...after printing form fields.

OnFieldMergeFinished

Change of the page count

When the page count changes.

OnPageCountChanged


note

Most events relate to documents, except OnStartApp, OnCloseApp, OnCreate and OnLoadFinished that occur at application level. OnSubComponentOpened, and OnSubComponentClosed events are fired by database's forms.


tip

Writer documents are triggering those specific events: OnLayoutFinished, OnMailMerge, OnMailMergeFinished, OnFieldMerge, OnFieldMergeFinished and OnPageCountChanged.


Assigning a Macro to an Event

  1. Choose Tools - Customize and click the Events tab.

  2. Select whether you want the assignment to be globally valid or just valid in the current document in the Save In listbox.

  3. Select the event from the Event list.

  4. Click Macro and select the macro to be assigned to the selected event.

  5. Click OK to assign the macro.

  6. Click OK to close the dialog.

Removing the Assignment of a Macro to an Event

  1. Choose Tools - Customize and click the Events tab.

  2. Select whether you want to remove a global assignment or an assignment that is just valid in the current document by selecting the option in the Save In listbox.

  3. Select the event that contains the assignment to be removed from the Event list.

  4. Click Remove.

  5. Click OK to close the dialog.

In addition to assigning macros to events, one can monitor events triggered in LibreOffice documents.

Please support us!