Ask Your Question

Menu customization saved in calc document doesn't show in menu when doc loaded. [closed]

asked 2013-08-28 19:13:51 +0100

bwanagary gravatar image

updated 2014-01-07 00:32:54 +0100

oweng gravatar image

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

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-16 00:12:51.500181

3 Answers

Sort by » oldest newest most voted

answered 2013-08-28 23:17:25 +0100

m.a.riosv gravatar image

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

edit flag offensive delete link more


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

bwanagary gravatar imagebwanagary ( 2013-08-28 23:44:58 +0100 )edit

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

m.a.riosv gravatar imagem.a.riosv ( 2013-08-29 00:44:39 +0100 )edit

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.

bwanagary gravatar imagebwanagary ( 2013-08-29 02:09:15 +0100 )edit

answered 2013-11-19 16:06:18 +0100

ssepan gravatar image

updated 2013-11-19 16:07:49 +0100

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

edit flag offensive delete link more

answered 2013-12-04 23:02:50 +0100

Rugslug gravatar image

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 website.

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


edit flag offensive delete link more


It appears to be repaired in

Rugslug gravatar imageRugslug ( 2013-12-30 03:51:04 +0100 )edit

Question Tools



Asked: 2013-08-28 19:13:51 +0100

Seen: 425 times

Last updated: Dec 04 '13