Ask Your Question
0

Does LibreOffice support MS-CUSTOMUI

asked 2017-02-22 17:26:18 +0200

mammlouk gravatar image

I'm expecting that the answer to this question is no, but I thought it would be worth finding out for sure. I know that an interface option similar to the Ribbon UI in Microsoft Office has only just made it to users. In my day job I primarily work with a custom application built on top of Microsoft Excel with quite a bit of VBA and more recently a custom interface built using Microsoft's MS-CUSTOMUI capabilties. As an exclusive Linux user at home I started wondering the other day if it would be even remotely possible to open our Workbook with LibreOffice. MS-CUSTOMUI allows users to create custom application interfaces implementing standard control groups or custom control items using standardized objects via an xml specification. Custom interface objects can then be handled in VBA using callback functions. It is actually a pretty elegant solution once you know what you are doing.There are a few different tools out there for creating a custom Ribbon based UI, but I have done all of my work by hand writing my XML due to restrictions on untrusted files/applications.

Transferring the workbook for testing isn't a small task due to my work environment so I figured I'd ask some questions before wasting my time. So is this implemented at all? Assuming it has not, what sort of roadblocks would prevent someone from implementing these capabilities?

Here are a few relevant MSDN links for MS-CUSTOMUI.

XML Markup Specification: https://msdn.microsoft.com/en-us/libr...

Breakdown of Elements: https://msdn.microsoft.com/en-us/libr...

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2017-02-24 01:25:56 +0200

LibreTraining gravatar image

updated 2017-02-24 01:31:36 +0200

DIY UI: How to create your own Notebookbar
https://design.blog.documentfoundatio...
Basic overview of user interface files, locations, etc.

Developer's Guide Examples
http://api.libreoffice.org/examples/D...
Includes examples for spreadsheets.

LibreOffice API
http://api.libreoffice.org/

OpenOffice Basic
https://wiki.openoffice.org/wiki/Docu...

Macros documentation
http://www.pitonyak.org/oo.php

If you download the original .ODT files you can then Export to PDF with bookmarks.
Makes it a lot easier to find things with bookmarks.

And I renamed the files to something more descriptive:
- OpenOffice.org.Macros.Explained.3rd.Edition.June.12.2015.Andrew.D.Pitonyak.pdf
- Useful.Font.Information.Andrew.Pitonyak.pdf
- Useful.Macro.Information.for.OpenOffice.org.Nov.2007.Andrew.Pitonyak.pdf

.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-02-22 17:26:18 +0200

Seen: 91 times

Last updated: Feb 24 '17