Creating a odt doc with a date and time macro Collabora Online (Filr)

Hi all:

We are using Collabora 6-4 as part of the Micro Focus Filr Content Editor package. I am attempting create a odt template that will execute a macro that will print the date and time exclusively in the 1st column and any row in the 1st column the user wishes.

The document will be shared with others in this Filr collaboration platform. Basically this is a log. Can this be done? Can I execute a macro with this Filr platform? See attached.

Hey @BetterThanThis.

It looks like soon after you asked this, Macro functionality was introduced:

As long as you are on a newer version of Collabora Online, this should be possible.

(I just tested 23.05 and it worked.)

How To Enable Macros in Collabora Online

  1. Go into your coolwsd.xml file.
  2. There is a line for the enable_macros_execution setting:
<enable_macros_execution desc="Specifies whether the macro execution is enabled in general. This will enable Basic and Python scripts to execute both installed and from documents. If it is set to false, the macro_security_level is ignored. If it is set to true, the mentioned entry specified the level of macro security." type="bool" default="false">false</enable_macros_execution>

Change that from falsetrue.

  1. Now, when you open a document, there should be a new “Run Macro” option available.

    • In the default Tabbed UI:
      • File > Run Macro
    • In the “View > Compact View”:
      • Tools > Run Macro
  2. That should open up the “Macro Selector” menu:

From there, you can choose your macros.


For more info, you may also want to check out: