Category: LibreOffice

Word gives table designers many more options than LibreOffice

word processor

word processor

Tables have been part of word processors for decades. They are useful for breaking up a wall of text with a graphic element. They are good for taking data from a report or another document and making it easy to find.

They are also used for document design. You can make a complex layout for a page by creating a table. However, most word processors have other tools, such as text boxes, for laying out a page and document.

Two of the most robust word processors are Microsoft Word and LibreOffice Writer. Both allow for the creation of complex tables.

Read more

LibreOffice makes it easy for programmers by allowing macros to be written in four languages

The best macros are not recorded through the user interface of an application. They are hard coded through the application’s coding interface.

In the last blog, I compared recording macros in LibreOffice to doing the same in Microsoft Office. In this article we will compare how each one handles macros in general.

Most Microsoft power users are familiar with macros in Office. The famous office suite uses Visual Basic for Applications (VBA). It has been part of it for two decades, being based on Visual Basic 6.0.

LibreOffice, by default, uses LibreOffice Basic, an open-source scripting language that was taken from Most programmers are not familiar with this language, so LibreOffice uses other languages that are familiar to many programmers.

The open-source suite uses JavaScript, Python, and BeanShell to create macros in addition to LibreOffice Basic.

This article will focus on creating new macros in LibreOffice and the Windows and Mac versions of Microsoft Office.

Read more

LibreOffice more flexible than Microsoft Office for macros

A macro is an instruction into a set of instructions to perform a particular task. There are actually two ways to create macros in both office suites.

Macros allow you to perform and automate various functions in a document. Those functions can either be natively performed through a feature built into the application or they can introduce a new feature.

The simple way is to record a macro with an icon in the ribbon or by clicking the record item in one of the menus. The more complex way is to write code.

Many Microsoft Office power users are familiar with Visual Basic for Applications (VBA). This is the language Office records macros in. VBA is also the only language you can use to manually write macros with.

LibreOffice supports LibreOffice Basic, JavaScript, BeanShell and Python for creating macros. When you click the record button, LibreOffice writes the macro in LibreOffice Basic. To use the other languages, you need to write the code yourself.

This article compares recording macros in Microsoft Office applications and LibreOffice. For Microsoft, it will explain how macros are recorded for the Windows and Mac versions of Word, Excel, and PowerPoint.

Read more

LibreOffice can compete with Microsoft Office’s new collaborative features

People have been working together on documents generated by office suite applications for decades now. One person would create the document and write his part before sending it to his colleagues, so she could create her part and make comments on his.

In the past 10 years, this collaboration has happened in real-time. Google’s office suite made it popular and easy for students, colleagues, and others to log in to their Google accounts to work on a document. A group of people work on a document, and they can see each other’s changes almost as soon as they are made. This is known as real-time collaboration.

LibreOffice and Microsoft Office have made strides to catch up to the new kid on the block. Both have taken slightly different directions. They allow for multiple people to collaborate on a document.

However, with its past two versions of its office suite, Microsoft has given users the ability to collaborate in real-time, like Google Drive users can do, through its desktop applications. With the 2013 and 2016 versions, users could work with others at the same time from the applications installed on their computers.

The latest versions of LibreOffice still don’t allow for real-time collaboration through its desktop applications, but they now have applications that can be installed on a server. These allow for real-time collaboration.

This article will mainly compare the collaborative features of LibreOffice and three of the applications from Office 2016: Word, Excel, and PowerPoint. Comparisons will be made with Google Drive as well since it is the office suite that is best known for real-time collaboration, and like the other two, is used by millions of people.

Read more

LibreOffice, NeoOffice: two great suites for your application toolbox

When OpenOffice was first released it was available for Linux distros and Windows natively, but it ran on Mac under Unix. A company called NeoOffice responded by forking the code into their own distribution for the Mac.

For the past 5 or 6 years LibreOffice and OpenOffice have run natively on Mac, but NeoOffice is still being developed. The suite is being sold through the Mac App Store for $29.99.
It has some different features than it’s other open-source counterparts. These include being able to sync with iCloud and having independent floating windows that are common to a lot of Mac applications.

This article will compare the two office suites.

Read more

LibreOffice, Google Drive partner through Web browsers

In the last blog entry, I talked extensively about connecting to your Google Drive account directly through LibreOffice and using the Google Drive application that can be installed on Mac or Windows.

There is another way to share and update documents created in LibreOffice using your Google Drive account, however. Simply launch your favorite Web browser go to your Drive account and upload the desired documents and folders.

A Web browser has several advantages over using the Google Drive application or a third-party application. One of the key reasons is that you don’t need to have all the documents from your Drive account downloaded to your computer.

Read more