Category: spreadsheets

LibreOffice, Microsoft Office can share package graphics

Modern office suites allow you to add graphics to any type of document. This includes pre-packaged graphics that comes with the suite.

LibreOffice and Microsoft Office have a series of graphics that are available to any document, regardless of whether it is a text document, spreadsheet, or presentation. Both suites have dialogs that allow for easy insertion of a desired graphic.

LibreOffice has 13 categories by default, and it allows you to create new categories as well as add more graphics. The section is called the Gallery.

In Microsoft Office, the dialog is called Icons. The graphics in this collection are all black and divided into 26 categories. No more can be added to the library, however. The icons are available in the Windows and Mac versions of Office.

Read more

LibreOffice Calc, Microsoft Excel bury insert rows and columns feature

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