Toolbar - Decimal Places - Minus

Decimal Places in LibreOffice Calc

This tutorial would explain how to show fewer decimal places in a Calc Cell.

Show Few Decimal Places

Any decimal number that contains multiple digits after the point can be entered in a Cell. However if the digits are huge, it is often wise to show only fewer digits for better visibility and understanding. For example, say a decimal number 4.175 is written in cell A1.

Before Reducing Decimal Places
Before Reducing Decimal Places

 

Now, click on the “Delete Decimal Place” button from the toolbar.

Toolbar - Decimal Places - Minus
Toolbar – Decimal Places – Minus

 

Each time you click the button, Calc would reduce one decimal places and show a round off view of the number.

After Reducing Decimal Places
After Reducing Decimal Places

Remember that, it is just the representation of the number that is changed, not the number itself. The internal number remains 4.175 but the representation is changed to 4.2.

If you want to perform any calculation on the decimal number while decimal view is reduced, Calc would consider the internal/actual decimal number with all decimal places i.e. 4.175 only.

Calculation when decimal is reduced
Calculation when decimal is reduced

To get back to the original number, click on the “Add Decimal Place” from the toolbar.

Toolbar - Decimal places - plus
Toolbar – Decimal places – plus

LibreOffice Calc - Data Validation

How to Add Numeric Data Validation in Calc Spreadsheet

This tutorial will explain the basics of numeric data validation in LibreOffice Calc worksheet.

Calc provides various ways of data validation in worksheet cells – numeric validation, range validation etc. When a worksheet is used to receive input data from users, data validation can be used to restrict user from invalid data input. Lets see how can it be done in Calc.

Validation

I have a worksheet where I want to restrict user to input any number from 1 to 10 only.

Select the input cell and click Data -> Validity

LibreOffice Calc - Data Validation in Menu

 

In the Validity window, choose Allow: Whole Numbers ; Data: valid range ; Minimum: 1 and Maximum:10.

Go to Input Help tab and enter the message you want to show to user when the cell is selected. The message would be shown as popup when the cell is selected by user.

LibreOffice Calc - Input Help

Go to next tab Error Alert and put the message which can be shown as popup error message to the user. You can opt it out by checking off the option – ‘Show error message when invalid values are entered’.

LibreOffice Calc - Input Help

Press OK once all the options are set. Now click the cell, you can see the popup message which set in Input Help tab:

LibreOffice Calc - Input Help on Display

Now, if you try to enter any value e.g. 20 which is invalid as per the Min and Max we have set in Criteria tab, the popup message box would be displayed:

LibreOffice Calc - Data Validation

This is the way you can input proper accepted values in Calc spreadsheet.

Feel free to leave a comment if you have any questions.

Calendar Template - Imported

How to Download, Import and Use Templates in LibreOffice Calc

This tutorial will show how to use templates in LibreOffice Calc. I will show how to download a template, import it, use it and manage it in LibreOffice Calc.

Download Templates

Templates are a great way to extend the functionality of LibreOffice. Huge numbers of community developed free LibreOffice Calc templates available in extensions.libreoffice.org/templates/.

Download any Calc template you want and save it in your computer. For this tutorial, I have downloaded Calendar Creator template.

Download calendar-creator template

Template files are having .ots (ODF Spreadsheet Template) extension which is used by LibreOffice Calc spreadsheet applications.

Import Templates

To open the manage templates dialog, from the menu choose File -> Templates -> Manage. On the Template Manager Dialog, go to Spreadsheet Tab and click My Templates. 

Template Manager_Import

Using Import button, choose the template .ots file you have downloaded. Template manager will import the .ots file and you can see it under My Templates. Select the template and click open.

Open Template - LibreOffice Calc

 

Use Templates

It might take a moment to load the template, once loaded you can see the template in Calc workspace. Now you can save it as .ods files and your use.

Calendar Template - Imported

 

This is how you can download and use a Calc spreadsheet template in LibreOffice. Feel free to leave a comment or if you are looking for something else using comment box down below.

Next Chapter Data Validation