If you use macros in one of the applications and want to use the same functionality in the other application, you must edit the macros. The most recent versions of LibreOffice can run some Excel Visual Basic scripts if you enable this feature at LibreOffice - Preferences Tools - Options - Load/Save - VBA Properties.

Although the programming language is the same, the objects and methods are different. Microsoft Office uses VBA (Visual Basic for Applications) code, and LibreOffice uses Basic code based on the LibreOffice API (Application Program Interface) environment. With a few exceptions, Microsoft Office and LibreOffice cannot run the same macro code. Macros in Microsoft Office and LibreOffice You can specify the folder to be read, and the folder where the converted files are to be saved.Ĭhoose File - Wizards - Document Converter to start the wizard. The Document Converter Wizard will copy and convert all Microsoft Office files in a folder into LibreOffice documents in the OpenDocument file format. If these steps do not apply to your brand of Microsoft Windows, search your Microsoft Windows Help for instructions how to change the file associations.Ĭonverting Many Microsoft Office Files into OpenDocument Format Make sure that “Always use this app” is checked. In the list of applications that appears, select the program that should open the current type of files. In the context menu, choose Open with - Choose another app. In Windows’ File Explorer, right-click a file of the type that you want to assign to another application. Opening Microsoft Office Files by Default

Of course, you still can select another file type in the file save dialog. In the Default file format and ODF settings area, first select a document type, then select the file type for saving.įrom now on, if you save a document, the File type will be set according to your choice. Saving Documents by Default in Microsoft Office FormatsĬhoose LibreOffice - Preferences Tools - Options - Load/Save - General. In the File type box, select a Microsoft Office file format. Microsoft PowerPoint, *.ppt, *.pps, *.pptx Select a Microsoft Office file in the LibreOffice file open dialog. Opening a Microsoft Office FileĬhoose File - Open. LibreOffice can open and save documents in the Microsoft Office file formats, including Microsoft Office Open XML formats.

Libreoffice calc excel