Menu customization saved in calc document doesn't show in menu when doc loaded

English
, , , ,
#1

I have written some complex macros to use LO as a MIDI controller editor. I added a menu option through Tools->Customize dialogs and saved them in the document name, not the “LibreOffice Calc”. I save the document (spreadsheet) as a .ods or .ots file and then quit LO. I restart LO and open the document. I would expect to see the new menu option (from customization) appear in the menu when the document is opened but it does not. I can re-Customize the UI and create the hooks to the Macros that are retained in the document, but I can’t distribute the template to others and exppect them to navigate customization of their UI just to use my template and macros. Is there some way that I can have my UI Customizations saved in the document/template and have them reappear when that document/template is loaded?

Thanks
-Gary

#2

I think you need to associated a macros with the open document event, in Menu/Customize/Event - Open document, saved in the document.

#3

Thanks, but that won’t help. I’ve tried it. If you save the association in the document, then it is never executed when the document is opened. Its the same problem.
Thanks for trying though. The whole point is to spare the user the task of customizing their UI. The document alone should do all the work. I believe that this is a bug in LibreOffice that is also present in OpenOffice.
-Gary

#4

Please take a look to this thread.
My macro does not trigger automatically

#5

Still, that is the very same problem. If I start a completely VIRGIN LibreOffice Calc with no document loaded, it should show all the usual menus and toolbars. If I then open a document that contains macros and customizations then the customizations should appear. They do not. If I send someone a document that contains sophisticated macros, they can’t access them unless they first customize their UI. That’s nonsense. If I load a document with additional menu options, I should see them. Thx.

#6

Gary,
I have not verified whether this solves your problem, but FYI I have noticed that, on my PC, the file “menubar.xml” in the “driveletter:\Users\username\AppData\Roaming\LibreOffice\4\user\config\soffice.cfg\modules\scalc\menubar” folder contains a menu item that I defined for a macro that I wrote for a Calc document.
However, there is a lot of other menu info in there with it.
-Steve

#7

Hi Gary,

I too had the same issue with saving a customized menu/toolbar for a specific sheet.

I went back to Portable Apps version 3.6.5 to eliminate a version 4 problem and it worked okay. So then I tried Portable Apps version 4.06 and it works correctly as well, that is, I can save my customized Toolbar, and it will reload okay (it also reloads okay in 4.1.3).

I then tried Portable Apps 4.1.1 and it is broken like 4.1.3 both in PA and regular LO version.

Something must have happened in v 4.1.0.

So the short version of the suggestion is to try version 4.0.6 to see if that works for you. I suggest using the Portable Apps version which is available on the Libreoffice.org website.

I see it’s been 3 months, so hopefully you found a solution earlier than this.

Tim

#8

It appears to be repaired in 4.1.4.2.

#9

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.