Im using libreoffice as follows:
Version: 5.1.6.2 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: 6.3.2.2 Build ID:
libreoffice-6.3.2.2-snap1 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?
Screenshot from 2019-10-31 16-32-52.png
Screenshot from 2019-10-31 16-38-47.png
