This beginner’s tutorial explains different ways of counting characters in LibreOffice Calc. Counting characters in a cell, sheet, range of cells is often useful when doing certain activities. Counting characters very simple in Calc using various functions. Here’s how. Count Number of Characters in a Cell To count number of […]

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.

This tutorial will explain the basics of custom number format in LibreOffice Calc. Calc provides different types of number formats which is explained in earlier tutorials e.g. Decimal, Numbers, Date and Time etc. All the formats that comes as default caters to basic needs. But if you want to format […]

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 […]

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 […]

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 […]