LibreOffice Calc allows to select a large number of cells without using the mouse (which might be rather awkward if the area is extremely large). To select the area, it is necessary to enter the range in the Name Box. For instance, to select the cells between A1 and I20, as in the picture on the left, you enter A1:I20 and press Enter on the keyboard.…
12 Dec 2015
LibreOffice: Advent Tip #12
11 Dec 2015
LibreOffice: Advent Tip #11
LibreOffice allows to add comments to Writer documents, with the menu Insert > Comment (shortcut: Ctrl+Alt+C). Comments can be added to a single word, a sentence, a paragraph, a link, or a specific point in the text. This feature is useful, for instance, to collect comments on a document before the final version. Comments have a different color for each user, to make it easier to attribute them to the right person.…
10 Dec 2015
LibreOffice: Advent Tip #10
LibreOffice offers a powerful search and replace option of regular expressions – like, for instance, tabs, soft line breaks and empty paragraphs – based on the powerful International Components for Unicode (ICU) Regular Expressions engine. A complete list of the regular expressions can be found on the ICU Project website.
A list of the regular expressions most used by LibreOffice can be accessed via the dialog windows which opens when you enter Edit > Find & Replace… Clicking on the Other Options… arrow, you expand the list, from which you can select Regular Expressions.…
10 Dec 2015
The Document Foundation announces LibreOffice 4.4.7
Berlin, December 10, 2015 – The Document Foundation announces LibreOffice 4.4.7, the seventh and final minor release of the LibreOffice 4.4 family, with a few key fixes over the previous version. LibreOffice 4.4.7 is the “still” version targeted to more conservative users and enterprise deployments.
The Document Foundation suggests to deploy LibreOffice in enterprises and large organizations with the backing of professional support by certified people (a list is available at: http://www.documentfoundation.org/certification/…
09 Dec 2015
LibreOffice: Advent Tip #9
Libreoffice offers a number of different icon sets, which can be selected from the menu Tools > Options > LibreOffice > View. The default Linux icon set is called Human, while the default Windows icon set is called Tango.
Together with Galaxy and Oxygen, they have been the available options for quite a long time (although there have been several improvements to the design of the icons).…
08 Dec 2015
LibreOffice: Advent Tip #8
Hybrid PDFs are a peculiar feature of LibreOffice, and are extremely handy for interoperability. They are standard PDF files, which embed a standard ODF document.
Because of this characteristic, although they have a PDF extension they can be opened by LibreOffice as fully editable documents (please note that they cannot be opened with a double click on the icon, as any regular ODF document, but they must be opened from within LibreOffice by using the menu File > Open).…