LibreOffice Calc allows to show quite easily the top 10 values in a spreadsheet column with the AutoFilter function, which is activated with the menu Data > Filter > AutoFilter (image on the left). Once active, the function shows a down arrow in the first cell of each column, which opens a drop down menu with different options (image on the right).…
LibreOffice allows to select the language to check the spelling of a document – or a paragraph – by clicking on the language area of the status bar. The action opens a menu with different options: first, the available dictionaries for the document, and then other choices from disabling the spell checker to choosing a language for a paragraph.…
LibreOffice allows to save different versions of the same document in the ODF file. The feature can be accessed with the menu File > Versions…, which opens the dialog windows on the left.
The different options on this dialog window allow to save a new version of the document, or to force the software to always save a new version on closing the document.…
LibreOffice can be configured according to user needs with the menu Tools > Options, which opens a context sensible dialog window with a menu on the left and many corresponding option pages on the right.
One of the least known options pages is the Paths one, where the user can modify (or add to) the default directories used by LibreOffice to store – among the others – Images, Documents and Templates.…
To change the number of a page – for instance, if you add a new document to a series which has to be compiled into a single book at the end of the year – you must put the cursor somewhere in the first paragraph of the page and access the menu Format > Paragraph. Inside the multi tab dialog window, you have to open the Text Flow tab (shown in the image on the left), and in the Break section check the Insert box – with Type “Page” and Position “Before” – and the With Page Style box, using Default Style.…
LibreOffice Presenter Screen is a useful tool for presenters, as the name implies. Unfortunately, only a minority of Impress users are leveraging this feature, which can be activated with a few easy steps:
Configure the Impress Slide Show Settings with the menu Slide Show > Slide Show Settings, and in the Multiple Display area select the appropriate screen for the presentation (usually, it is named “screen number 2” or “alternate screen” or “secondary screen”).
