Notes regarding external formats and file typesĮven if they are not installed, some filters can be selected in the Open and Save dialogs. The last option is an effective protection against viruses within the Microsoft Office documents. You can set the behavior of LibreOffice as desired: Either the VBA macros are saved in commented form as a subroutine of LibreOffice and when the document is saved in MS Office format are written back correctly again, or you can select the Microsoft Office macros to be removed when loading. Often you only want to use LibreOffice to change the visible content of a Word, Excel or PowerPoint file and then save the file again in Microsoft Office format without changing the macros they contain. VBA macros are unable to run in LibreOffice they must first be converted and adapted. In LibreOffice - Preferences Tools - Options - Load/Save - VBA Properties you can specify the settings for the VBA macro codes in MS Office documents. BASIC Macros in Microsoft Office Documents For example, if you have a database table in text format that you want to open as a database table, you need to specify the file type 'Text CSV' after selecting the file.

There may be cases where you have to select the file type yourself in the Open dialog. LibreOffice normally recognizes the correct file type automatically on opening a file. In UNIX, certain file formats cannot be recognized automatically.

In LibreOffice, apart from its own XML formats you can also open and save many foreign XML formats.

Openoffice calc database