×

Install LibreOffice on CentOS 8 - Step by Step Process ?

This article covers LibreOffice installation on CentOS 8 distribution. LibreOffice is a powerful and open-source office suite that can be used on Linux, Mac as well as on Windows.

It provides various features such as word documentation, spreadsheets, data processing, drawing, presentation design, Math calculation, and more.


How to uninstall Old LibreOffice or OpenOffice Versions ?

If any previously installed LibreOffice or OpenOffice versions you have, remove it using following command.

# yum remove openoffice* libreoffice* [on RedHat based Systems]
$ sudo apt-get remove openoffice* libreoffice*	[On Debian based Systems]


Remove Duplicates in LibreOffice - Step by step process to do it ?

This article will guide you on how to get rid of duplicates from either the single column or from the multiple columns in LibreOffice. Removing duplicate entries is necessary to clean up the data. With LibreOffice advanced filter tool, you can easily remove these duplicate values from your data.

You can use Libre Office to open and edit existing #MS Office documents like excel word power point etc. 

Libre Office is a free alternate to MS #office and offers same functionality. Its easy to install and use.

The #VLOOKUP function (short for Vertical LOOKUP) is a built-in Calc function that is designed to work with data that is organized into columns. 

For a specified value, the function finds (or looks up) the value in one column of data, and returns the corresponding value from another column.


To find duplicates in #LibreOffice Calc:

1. Go to the worksheet that has the duplicate entries, and select 'Data' > 'Filter' > 'Standard Filter' (it seems to automatically select the data in the sheet that it will filter, you may want to do this manually beforehand).

2. It should then filter the data, and hide any duplicate records.


To insert a date in Libreoffice #Calc:

To enter a current date as a static date, press CTRL+; (semicolon). It will insert today's date as a static value in the corresponding cell. 

Similarly to enter current time as staic value, press CTRL+SHIFT+; .


Different useful LibreOffice writer shortcut keys ?

This article will guide you on how to use shortcut keys when dealing with #LibreOffice Writer documents.

These #shortcut key combinations will ease your life a lot as they will save your time that is spent in performing the most frequently used operations.

If the active cell is empty Ctrl+A selects the whole table; otherwise it selects the contents of the active cell. Depressing Ctrl+A a second time selects the entire table. If the active cell is empty Ctrl+Home moves the cursor to the beginning of the table.

To make a table in LibreOffice writer:

1. Place the cursor in your document where you want to insert the table.

2. Choose Table - Insert - Table.

3. In the Size area, enter the number of rows and columns.

4. Select the options that you want, click OK.


Enable dark mode in latest LibreOffice under Ubuntu 20.04 LTS

This article will guide you on how you can enable the dark mode across all the applications of #LibreOffice in #Ubuntu 20.04. Also, it also gives you the direction of reverting back to its regular mode whenever you want. To Enable #Dark #Mode in LibreOffice on Ubuntu, Linux : 1. Open LibreOffice. 2. From menu, click Tools -> Options. 3. Go to Application Colors, select document background as Black. 4. If you would like to change to a dark icon #theme, change it from View options on the left side for better visibility of the #toolbar icons.


Install latest LibreOffice on Ubuntu 20.04 LTS - Different methods to do it ?

This article will guide you on different methods to have the latest version of #LibreOffice installed on your #Ubuntu 20.04 system. To #install LibreOffice Ubuntu 20.04 step by step instructions: 1. Use the top left Activities menu to open the #Software application. 2. Search for LibreOffice software. 3. Click the Install button to begin the LibreOffice installation. 4. Enter your username and password. 5. Start the LibreOffice #application.