
This is an example where Libre Office exceeds the capabilities of Microsoft Excel. Libre Calc allows you to view multiple sheets at the same time within one instance of the program, Excel does not.Looking at Calc specifically, since we're almost all reliant on Microsoft Excel, the differences are few, but some are substantial. Take a look at this chart for some of the major differences in the suites, and the individual programs. Libre Office also has a user community developing (often free) extensions to the suite, mimicking missing Microsoft Office features or, sometimes, increasing the Libre abilities past what Microsoft can do. With its latest update, Libre Office now offers the Group Policy options IT teams are accustomed to finding with Microsoft Office, which increases the potential deployments of Libre. Given that Libre Office has been making the biggest publicity push lately, we'll focus on them.įor 90% of the work performed by a typical company, Libre Office can be used without a problem in lieu of Microsoft Office. Open Office and Libre Office are free options that are installed on individual machines, and do their best to mimic the full Office experience. Basic ones like Google Docs offer minimal features, but are easily accessible in the cloud. Select a cell and click this icon to toggle "Automatic Row Break" (ie: "Wrap text automatically") on and off, just like you can do in Microsoft Excel!ĭemo'ed in LibreOffice 4.2.8.2, Ubuntu 14.04 LTS.But that's slowly been changing due to the free offerings out there.

Here's the icon I just added right after the "Justify" icon. It will have a check mark next to it to indicate it is visible.

When done, click Ok as necessary to exit the menus, then click on View -> Toolbars and ensure the "Formatting" toolbar we just added the icon to is visible. and choose an icon you think looks half-way decent. Now in the Toolbar Content section scroll down and click on Justified, since I want to add my cell wrap icon just after that one.Ĭlick Add, then choose Format from the "Category" menu and Automatic Row Break from the "Commands" menu. In the Toolbar drop down select Formatting. Here's how to add a shortcut icon to toggle "Wrap text automatically" on and off:ĭoing it one time through the Format Cells menu is great and all, but I use this operation all the time.
