Libre Office is an awesome tool which enable you to write your own macro to automate different repetitive tasks. This tutorial will help you to write a macro using BASIC in LibreOffice calc.
Libre Office
Suppose you are working in spreadsheet and you want to display two different pivot table in the same spread sheet. Usually if you create pivot table without choosing the result sheet, it will create a new sheet. So let us check how we can display the result in our desired sheet so that we can show different pivot tables in the same sheet.
When we combine different CSV files using ‘cat’ command, the resulting CSV file contain repeating headers. This usually happens when we combine different CSV files having the same headers. Let us check a simple method to remove the repeating headers in Libre office - Calc document.