Ask Your Question

libreoffice calc cant find macro - name?

asked 2019-10-31 06:42:14 +0100

colic gravatar image

Im using libreoffice as follows:

Version: Build ID: 1:5.1.6~rc2-0ubuntu1~xenial10 CPU Threads: 8; OS Version: Linux 4.15; UI Render: default;

Today I was presented with a recovery dialogue, which I accepted. However all of my macros had disappeared.

I re-entered them and ran them with the debugger. However I cannot reference them from my spreadsheet. Attempting to call them by name gives NAME?

It looks like Calc has crashed and reset a whole load of things.

I checked security was MEDIUM, no change. I also checked a JRE was installed and enabled in Advanced Settings. No change.

So I upgraded to version 6 on Ubuntu 16.04.6 LTS as follows:

Version: Build ID: libreoffice- CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: en-AU (en_AU.UTF-8); UI-Language: en-US Calc: threaded

The results are no different (security and JRE checked as above)

Attached is a screenshot of a simple test macro running in the debugger, and a screenshot of the attempted call to the same macro from my spreadsheet. I get the same result with the other macros in the editor.

Obviously something has been reset/changed. Anyone got any ideas?

C:\fakepath\Screenshot from 2019-10-31 16-32-52.png C:\fakepath\Screenshot from 2019-10-31 16-38-47.png

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-10-31 08:19:01 +0100

colic gravatar image

Eventually I worked out that because I had to rewrite my macros (as they all mysteriously disappeared after the crash), I forgot to use Function instead of Sub. Its that long ago sice I first wrote them.

Why they disappeared is another question. A nice feature of Calc it seems :-)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-10-31 06:42:14 +0100

Seen: 26 times

Last updated: Oct 31