The dropdown menus for ‘Document type’ and ‘Always save as’ lets you specify the file format. The ‘Load/Save’ menu lets you change the saved default file format in the ‘General’ section. You can find the Open Office settings in the ‘Tools’ tab under ‘Options’.

Although OpenOffice has a clean home screen, the settings section can be confusing to navigate. While you do not need to set up any settings to make OpenOffice show you Microsoft files in the interface, you will need to customise preferences to save your files as the Microsoft file types. OpenOffice will automatically display your Microsoft documents into the user interface for you to edit. OpenOffice is a suitable alternative to Microsoft Office 365 considering you can create and open Microsoft file formats like. Open Office is compatible with the files that are already on your PC in your file manager.Īn ‘Open’ button lets you conveniently launch your file directory to choose a file to use. A blank document will appear when you click on the options. Based on the selected designation, all the other columns are also filtered.The user interface is intuitive to use, as the home screen clearly labels the tools. In the below image, Researcher designation is filtered. In the below image, Researcher designation is chosen. Step 4: Click the drop-down arrow and choose the value to filter the column. Step 3: When you click the AutoFilter option, a combo box will appear in the selected column header. Step 1: Select the column which you want to filter. Based on the selected value from the drop down, data in the columns will be filtered. When you select autofilter, a drop down box will be created in the first cell of the each column. In OpenOffice, there are three types of filter,Īutofilter is used to quickly filter the columns based on the selected data. In OpenOffice, Filter option allows you to narrow down the search to work with the particular set of data.

How to filter data in OpenOffice Spreadsheet? Explanation

Open office spreadsheet