Learn the basics of relative, absolute and mixed reference in LibreOffice Calc with additional examples and usage notes.

Simple tutorial explains how you can type various UNICODE characters in LibreOffice Writer and other modules.

A simple tutorial which explains how to track changes in LibreOffice Writer document with Accept, Reject changes.

The Document Foundation (TDF) announced the release of LibreOffice 7.0.2 (Fresh). This is the second point release on the LibreOffice 7.0.0 series. And both the first and second point release brings almost 100+ bug fixes which makes it a more robust free…

The LibreOffice board announced their take on OpenOffice via an open letter today. And it seems a big deal. Often people get confused about OpenOffice and LibreOffice. There are numerous articles and posts about the difference between them. However many people…

Tutorial on how to crop a shape in LibreOffice Draw. Step by step example with images inside for better understanding.

The bleeding-edge version of LibreOffice 7.0.3 is released by The Document Foundation (TDF) and it is immediately available for download or update. This is the third point release in the LibreOffice 7.0 release which brings a huge set of changes to this free…

Step by step guide on how you can export LibreOffice Impress Slides as Images. You can export single slide and multiple slides at one go.

Two methods of removing duplicates from LIbreOffice Calc sheet which includes an easy and a comparatively difficult method.

This beginner’s guide explains how you can find the weekday, workday in LibreOffice Calc. LibreOffice Calc has dedicated functions that you can use to find out the weekday, the number of weekdays, etc. Using these in the formula and combining them, you can…

Learn how you can split cell content into the multiple columns in LibreOffice and OpenOffice using examples.

This quick tutorial explains the steps required to Count Words in LibreOffice Calc Cell. There are no direct features available in LibreOffice that can help you to count words. In the early article, I explained how to count characters in LibreOffice Calc.…

This tutorial explains the basics of how you can find the characters position in LibreOffice Calc. While processing data, it is often required to find a particular position of a character in a string. And you may want to repeat the search in multiple cells…

A simple tutorial which explains various ways to remove spaces using formula, find/replace methods using functions.

A simple guide that explains how you can compare two columns in LibreOffice Calc sheet with examples.

This article explains two essential functions of REPLACE and SUBSTITUTE in LibreOffice Calc. Often, you need to use the SUBSTITUTE function to replace a portion of a text in a cell. It can be in a single cell or a range of cells. So, to do that, you need…