LibreOffice macro doesn't work after saving and exiting

[answerquest]

I followed the visualbasic instructions for LibreOffice and it worked, I was able to run a function in my cells to generate pluscode : =OLCENCODE(A2,B2)

But after saving and closing the file, on opening it again, I got a macros-disabling notification, and the functions no longer worked. They simply return the latitude value.

I followed the steps shown here to set my LibreOffice security settings to ask me whether to enable macros or not. But even after that these functions are no longer working. I get a prompt on loading the file asking about macros, I choose to enable them. But to no avail. I tried rummaging about the Organise Macros settings but LibreOffice crashed.

When I create the macro all over again, THEN it works. But I want to have people use this without having to do it all over again.

Has anyone else created a .ods (Calc) file where the OLC macro works? I even tried doing the macro in a .xlsx file, in LibreOffice. Same problem - it doesn't run things differently for .xlsx in this matter.

Environment details : Lubuntu 18.04 64-bit OS, LibreOffice 6.1.0.3

If anyone wants to see the .ods file, you can download it here.

[zongweil]

Assigning to @drinckes, who wrote the plugin.