This tutorial would explain various ways of COUNTIF function in LibreOffice Calc which can be used to count strings, numbers from a cell, range, rows, columns etc. Read More
Tag: calc
Data Validation Using Double Dependent Dropdown List – LibreOffice Calc
This tutorial would explain how to create a dependent dropdown list in LibreOffice Calc.
Read More
Data Validation Using DropDown List – LibreOffice Calc
This tutorial would show how to use a basic range based data validation in LibreOffice Calc using a drop down list.
Read More
How to Delete Empty Rows in LibreOffice Calc Sheet
This tutorial will explain how to delete blank rows from LibreOffice Calc sheet. Read More
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.
Now, click on the “Delete Decimal Place” button from the toolbar.
Each time you click the button, Calc would reduce one decimal places and show a round off view of the number.
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.
To get back to the original number, click on the “Add Decimal Place” from the toolbar.
How to Zoom In, Zoom out in LibreOffice Calc Sheet
Here’s how you can perform zoom in and zoom out in LibreOffice Calc sheet.
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
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.
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’.
Press OK once all the options are set. Now click the cell, you can see the popup message which set in Input Help tab:
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:
This is the way you can input proper accepted values in Calc spreadsheet.
Feel free to leave a comment if you have any questions.
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.
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.
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.
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.