Bar and column graphs are some of the most used in presentations. They are great visuals for different data in a spreadsheet. Most spreadsheet applications have them as one of the charts that can be created.
LibreOffice and Microsoft Excel for Windows are the most advanced spreadsheets on the market. They have several bar and column charts to choose from, and both allow users to edit and modify every aspect of the charts they create.
This article will compare how many bar and column charts the two applications have to offer, the options each has for stylizing the charts, and they create them.
Spreadsheets are the tools of number crunchers. Stockbrokers, financial analysts, and mathematicians are a few of the professionals who use this type of application heavily. When it comes time to share their information with others, however, they cannot rely on the rows and columns of figures to be clear to their audience.
This is why they create charts that can be inserted into presentations and word processor documents. Most spreadsheet applications have features to create charts from the data in their cells.
Like with other functions, Microsoft Excel for Windows and LibreOffice Calc, are the two most feature-rich applications for creating charts. Other popular spreadsheets, such as Google Sheets and Apple Numbers, don’t have the number of categories or the number of charts that these two have.
While the Mac version of Excel has many of the same charts as its Windows counterpart, it is still not quite as feature rich. It also doesn’t have the same number of charts as Calc.
This article will compare the number of charts available for Calc and Excel for Windows. It also will compare the user interfaces for the two.
Spreadsheet applications are not used as much as word processors, but they are used for just as diverse purposes. Grocery shoppers can use them to create lists. Financial managers use them to create charts from data showing forecasts for organizations. There are many other users and uses.
Though people from diverse walks of life use spreadsheets differently, they all typically perform some of the same functions. These include adding and deleting columns and rows.
This article compares how these are done in LibreOffice Calc to how they are done in Microsoft Excel 2016 for Windows.
While these to spreadsheet applications are considered to be the most powerful and feature-rich applications. However, they are not as user-friendly as some other popular spreadsheets, when it comes to adding or deleting rows and columns.
First the article will explain how these are performed. Read more
Most word processors treat different styles such as headings and titles as paragraphs. Lists are no different. Many of these applications make the individual points lists.
This means that, while most word processors have special settings for lists and their points, their settings for paragraphs also can be applied to lists and their points. Paragraph settings can be used to indent the left and right sides of a list item. There are also settings to add space above or below an item.
In LibreOffice Writer and Microsoft Word for Windows users can use their various paragraph settings to make adjustments to lists and their items. Both have Paragraph dialogs with similar settings. Their other settings is what sets the two word processors apart from each other.
This article will focus on the settings for indentation and spacing before and after paragraphs in Word and Writer.
Writer’s other indentation and paragraph spacing settings are in the Formatting toolbar and the Properties tab of the sidebar. Like the settings in the dialog, these icons will affect individual bullet and number points.
In Word, they are in the Paragraph section of the Home ribbon. These icons, unlike the Paragraph dialog settings, only affect the entire list. They do not make adjustments to individual items. Read more
Lists have many styles, and many word processors have multiple settings for them. Severalof them give you tools and settings to indent and align bullet and number points.
The two word processors that are the most feature rich, LibreOffice Writer and Microsoft Word 2016 for Windows, have many of the same settings for lists. They give users a lot of control over aligning and indenting points in those lists.
These settings can work on simple lists, with only one level of numbers or bullets. However, the dialogs for the lists are designed for multilevel lists, that have a combination of numbers and bullets.
Though many of their setting features are the same, Writer and Word have advantages over the other. This article will cover the tools both have for aligning and editing lists and discuss the advantages each one has over the other.
The addition of lists to word processors have helped writers keep their readers engaged in their articles and other documents. Different documents have different themes, and many word processors have different styles of bullets and numbering to fit with the variety of documents.
Bullets and numbering lists break down information in documents and make them easier to read. Bullets and numbering can be combined to create multilevel lists.
LibreOffice and Microsoft Word have various styles and features for bulleted and numbering lists. This article will compare list styles for LibreOffice Writer and Microsoft Word 2016 for Windows.
Tables are one of the most integral parts of a document. Common advice is to plan a table, so you know how many columns and rows you need.
However, many times you receive more data and need to add rows. Data parameters also change, so you need to add columns and create new categories.
Documents are also designed with tables. When designs need to change columns and rows in those tables also will need to change.
Most word processors offer easy ways to add columns and rows to tables.This article will examine how to add columns and rows in LibreOffice Writer and Microsoft Word 2016 for Windows are inserted or deleted.
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.
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 OpenOffice.org. Most programmers are not familiar with this language, so LibreOffice uses other languages that are familiar to many programmers.
This article will focus on creating new macros in LibreOffice and the Windows and Mac versions of Microsoft Office.
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.
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.