LibreOffice 7.5 released Thursday 2 February 2023. This free libre and open source office suite is now available for all computer users especially those who use GNU/Linux, Microsoft Windows and Apple MacOS. It brings out a lot of improvements and new features, and among them, visual identities. Thank you to all the developers and contributors. Congratulations to the whole LibreOffice Community!

(Writer, Calc and Impress 7.5 opening two documents from the official Press Kit)

Subscribe to UbuntuBuzz Telegram Channel to get article updates.

This tutorial will help you to add version 7.3 of OnlyOffice Desktop Editor to your Ubuntu computer. You can do it easily using Ubuntu Software or alternatively Terminal. Happy writing!

Subscribe to UbuntuBuzz Telegram Channel to get article updates.

This tutorial will help you create course marketing using LibreOffice Writer. This can also be used for other marketing purposes such as culinary and medical. We have already prepared the pictures and text and you can download them then try the exercises at home step by step to achieve the final product. We make this as avid users of Ubuntu and fans of Canonical. Happy writing!

This is a LibreOffice Calc calendar of 2023 made ready for you to download, import as template and print. We offer it as editable OpenDocument Spreadsheet (ODS) files and PDF. We use a template by Claus Kofoed Nielsen from Denmark. Feel free to download and make yourself more productive!

Subscribe to UbuntuBuzz Telegram Channel to get article updates.

This tutorial will show you how to create Pivot Table using LibreOffice Calc -- the complete, free spreadsheet program for everyone. We will learn with examples and pictures by using a simple sales table to create sales report with multiple pivot tables we want. Now let's exercise!

Subscribe to UbuntuBuzz Telegram Channel to get article updates.

This tutorial will help you to create mail merge with LibreOffice explained step by step with pictures and examples. Mail merge is a method of making stuffs consisted of multiple personalized copies like official letters, invitations, envelops, identity cards, student score reports etc. using word processor, spreadsheet and database. Finally, in this exercise we will make school letters for students' parents as an example so you can practice and then adapt it to your own needs. Let's study now!

Subscribe to UbuntuBuzz Telegram Channel to get article updates.

This tutorial explains how to create and insert Quick Response (QR) codes in Writer, the word processor program of LibreOffice. Why we learn to make QR Codes? Because today, QR Codes are popular thanks to smartphones so people can quickly access  address you're point to in your publications like books, registration papers, flyers, posters, etc. This requires Writer 6.4 or later and does not require other program. Now let's do it!

Subscribe to UbuntuBuzz Telegram Channel to get article updates.

Continuing LibreOffice Shortcuts poster, here's educational poster I made to spread LibreOffice's ODT - ODS - ODP to all people in all countries. These formats are known with the name Open Document Format and these are better than Microsoft's. The goal of this poster is to invite people to change their habits of saving as DOC - XLS - PPT formats into saving as ODT - ODS - ODP formats which are better. This poster is an English adaptation of my Indonesian version few years ago. I encourage you to place this on your schools, offices, websites, blogs, social media, and other places. You are free to adapt and share it with your own language. If you are curious, download LibreOffice application here for Windows, macOS and GNU/Linux. Okay, now let's share once again!

Original version:

Individual versions:

Open Document Text (Writer):

Open Document Spreadsheet (Calc):

Open Document Presentation (Impress):

Open Document Drawing (Draw):

Downloads:

Page Styles are page designs. It is similar concept to Headings and Paragraph Styles but applied to pages instead. With them, you can make different page numbering in one document such as Roman first and Arabic later just like in academic writings. Alternatively, you can also make a document with different page orientations and/or margins as you wish. You can either use existing or create new ones of them. However, the secret of success in using Page Styles is a thing called Manual Break. This tutorial explains step by step to use them with examples. Enjoy writing!

Paragraph Style is paragraph design with a certain name. This is about how text looks around another text in same document. As you have learned from previous article, Headings in turn are actually Paragraph Styles for titles. With Paragraph Styles, you can make for example a small story book with a group of text which is normal surrounding another group of quotation text with different look, named NormalText and QuotesText respectively. To write your book, you just need to write whole text without formatting as plain text. To finish it, select some text to apply NormalText Style and select another to apply QuotesText Style. That's it! This way you save your time to do repetitive formatting as you have already designed their Paragraph Styles. For most cases, you even do not need to create a custom one as LibreOffice Writer already prepared many you can choose. You can also modify Paragraph Styles available if you wish.In this article we will learn how to use Paragraph Styles with examples. Happy writing!

(Writer text document with several different Paragraph Styles applied)

Subscribe to UbuntuBuzz Telegram Channel to get article updates directly.

After learning about LibreOffice Writer's user interface and basic text formatting, we will learn about Views and Document Navigation so we can see better and moving around text more quickly. You will learn about two views, Normal and Web, and also three paging modes, Single-Multiple-Book. You will also learn about how to use zoom features and Navigator dialog. Lastly, you will learn to hide and show several important stuffs such as Rulers, Grid, and Pictures which in turn can help you reduce computer memory usage. Happy learning!

Subscribe to UbuntuBuzz Telegram Channel to get article updates directly.

Subscribe to UbuntuBuzz Telegram Channel to get article updates directly.

With LibreOffice Draw, you can make network diagram just like you did with Visio (or GNS3 or even Cisco Packet Tracer). The problem is that icons for networking, such as server, router, firewall, workstation, cloud, etc. are not included by default. Fortunately, the solution is you can add such icons as plugins in Draw and then use it to make diagram.  Thanks to the awesome VRT project, now we have it on LibreOffice. This tutorial explains step by step to install VRT extension into LibreOffice Draw until you can see networking icons available. Enjoy!

Subscribe to UbuntuBuzz Telegram Channel to get article updates directly.

In this article, you will learn the basics of LibreOffice Writer which are how to create, save, and open document & understand what formats are supported. You will learn the menubar, dialog window, and options available for that. You will find Writer useful because it supports both Open's and Microsoft's formats which are ODT and DOCX along with others like PDF, EPUB, RTF, and HTML. By learning this article, you will be able to create any document with any format on Writer. Happy learning!

Subscribe to UbuntuBuzz Telegram Channel to get article updates directly.

On our computer, if LibreOffice is installed, then we will find Writer word processor in the start menu. This article explains how to run and close Writer on Ubuntu GNU/Linux as an example for other systems. I also added advanced method here we can use whenever some problem occurred. Let's start learning.

Subscribe to UbuntuBuzz Telegram Channel to get article updates directly.