Open Source

Help migrate users from Microsoft Office to LibreOffice 4.1

If your small business is looking for an alternative to Microsoft Office, a good choice may be LibreOffice 4.1. Read these migration tips.

It's arrived -- the release of Microsoft Office that I think will have users flocking to alternatives. I'm talking about the train wreck that is Microsoft Office 2013. It's a challenge to work with (especially when there's a problem), and it's pricey.

For small businesses, a logical alternative to Office 2013 is LibreOffice 4.1. After just a few short years, LibreOffice has grown to be one of the finest locally installed office suites available. Not only will it save your company budget dollars, it will save users the headache of having to learn yet another iteration of the Microsoft Office interface.

It won't take long for your end users to feel comfortable with LibreOffice 4.1 because of the interface. When you break it down, almost every office suite works the same -- it's how and where you click that makes a difference. But just in case you find the migration a challenge, here are tips to make the process smoother.

Forget the Ribbon

Your end users might have acclimated to the Microsoft Office Ribbon interface. LibreOffice, on the other hand, held steadfast to the tried and true menu drop-down system. As soon as your users see this interface, they will feel right at home.

You should remind users that they used this interface for years (and probably still use it on most of their other applications). This point will ease the transition more than you know.

Understand default document formats

Most office suite users aren't accustomed to making a lot of changes to how their tools work. This is the one area that can trip up users who are new to LibreOffice.

Out of the box, LibreOffice works great, but minor changes should be made before users start working with their first document. The most important change is the default document format. 

LibreOffice defaults to the open document format. In other words:

  • odt – text documents
  • ods – spreadsheets
  • odp – presentation

If your users create documents using the default file type and then send those documents to Microsoft Office users, there could be problems. You can configure LibreOffice to use the Microsoft Office defaults instead. Although I prefer to leave the defaults as-is, it's less of a headache for your end users if the defaults are changed. This is done by going to Tools | Options | Load/Save | General. From this section (Figure A), select each file type (Text Document, Spreadsheet, Presentation) and associate the Microsoft Office file type with each one.

Figure A

libreoffice_migration_1_082213.png

Be sure to select each file type from the drop-down.

Introduce users to Wizards

A very nice but often overlooked LibreOffice feature is the Wizards tool. This handy feature guides users through the process of creating template-based documents for letters, faxes, agendas, presentations, and web pages, and even offers a wizard for document conversion and address data source (for mail merge). To get to the Wizards tool, go to File | Wizards and select the appropriate Wizard for what you want to create.

For example, with the Letter Wizard, the end user is walked through the steps of creating a document (Figure B). These steps include:

  • Page Design
  • Letterhead Layout
  • Printed Items
  • Recipient And Sender
  • Footer
  • Name And Location

Figure B

libreoffice_migration_2_082213.png

The Wizard for creating a letter.

The document created will be a professional looking letter; the user would have had a much more difficult time creating it manually. 

Use that status bar

Unlike Microsoft Office, the LibreOffice status bar (which is at the bottom of the LibreOffice window) has some useful bits. You can:

  • See a real-time update on word count
  • Get quick access to styles
  • Change the language (language packs must be installed)
  • Change the selection tool
  • Do a quick-save of the document
  • Change the page layout
  • Zoom in or out

With the help of the fast-access status bar tools, users can interact with their documents much more efficiently. Make sure they know how to use this tool right out of the gate.

A smooth transition

The transition from Microsoft Office to LibreOffice 4.1 doesn't have to be a challenge. With just a little thought and care, your end users can be humming away with LibreOffice 4.1 before you know it.

About Jack Wallen

Jack Wallen is an award-winning writer for Techrepublic and Linux.com. As an avid promoter/user of the Linux OS, Jack tries to convert as many users to open source as possible. His current favorite flavor of Linux is Bodhi Linux (a melding of Ubuntu ...

9 comments
Condemned
Condemned

FreeOffice would be a better suggestion.

That’s the only free office suite that lets you open, edit, and save all Word, Excel, and PowerPoint formats faithfully. It's fast and slim.

LibreOffice has plenty of problems with interoperability with doc(x), xls(x) or ppt(x), (mainly formatting losses going back and forth. It's slow, buggy, has a quirky ui, and is full of oddities.

Try it out:

freeoffice.com

wmroc
wmroc

When one want's the best, go with the best.

Who says MS Office of any version is the best?  It's just more commonly used, due to MS marketing practices and user inertia. 

steve
steve

Hi, I have also tried LO and OO and currently installing Office 2013 for clients.

Office 2013 is a pain to install I have done 15 over the last 3 weeks) it needs to know everything about your user e.g. DOBs MS mail accounts to be setup to access the MS site etc, the total install takes around 1 hour!

With regards to LO I also have to say that when using in office enviroments its not comapatible with MSO Office docs dont always display the way they should and combined with the fact that it does not contain a MS Outlook equivalent will make it difficult to push into a small business office even on a cost basis.

dl_caldwell
dl_caldwell

In my experience Office 2013 is stable and generally well received.  The change from office 2010 is evolutionary rather than revolutionary.   If we followed the author's premise that change and being asked to learn new things are "bad" we would still be working on WordPerfect for DOS - or even vi and scribe.  I spent a fair amount of time yesterday upgrading a student's PC from Ubuntu to Windows 7.  The driving force behind the switch?  Microsoft Office 2013!


LibreOffice works fine for many tasks, it's excellent for a high-school student or home user who can't afford MS Office.  However, compatibility issues and the lack of training resources limit it in the professional arena.  Until someone can make the argument that LibreOffice is noticeably BETTER than MS Office instead of CHEAPER it will always be considered second best. 

Doug Vitale
Doug Vitale

In my view, the biggest barrier preventing widespread adoption of LibreOffice is compatibility with MS Office. For LO to succeed, it needs to display MSO files exacltly as they look in MSO. Conversely, MSO must be able to open files created in LO and display them exactly as they look in LO.

If LO users create documents and send them to colleagues, partners, and clients who use MSO, and those documents end up looking crappy in MSO, that would be a "show stopper" for LO.

adornoe
adornoe

No matter what the alternative, and no matter who makes it, one will always be stuck with the feeling that, they're settling for second or third best, if it's not Office from Microsoft.  That's a feeling that always seems hard to overcome, and that's after trying LO and OO several times myself.  The promises of good enough, or adequate, just never get me to stick with LO or OO.  

When one want's the best, go with the best. 


IndianArt
IndianArt

Jack your article is packed with useful info yet the info is accessible & easy to get.


... & the best part, LO is getting even better at a rapid pace.

guy
guy

The biggest stumbling block to all Office alternatives is Outlook. it doesn't matter how good or how compatible the other programs are, if there is no Outlook compatible alternative built into the office suite then  many users aren't interested.

wmroc
wmroc

@adornoe

When one want's the best, go with the best.

Who says MS Office of any version is the best?  It's just more commonly used, due to MS marketing practices and user inertia.

Editor's Picks

IT Buying Cycle

Learn more