Tuesday, 27 November 2012

Make Xubuntu the ultimate Linux Operating System - Install LibreOffice

Posted by Gary Newell  |  at  23:06 5 comments

Introduction

This is the 4th part in the series looking at how to make Xubuntu the ultimate operating system.

Part 1 was all about the initial review of Xubuntu. The article looked at the base install of Xubuntu and commented on the performance benefits that Xubuntu provides over Ubuntu. 

Part 2 I looked at how to customise the desktop in Xubuntu. I showed how it is possible to customer the panels and how to adjust the menus and background themes so that Xubuntu looks just the way you want it to.

In part 3 I looked at the default music player in Xubuntu and reviewed  4 of the best music applications in Linux.

This is part 4 and today I will be looking at office software. To do a review comparing different office suites would take a considerable amount of time and would bore you long before you made a decision over which package is suitable for you.

Instead I have decided to write just about LibreOffice. For me LibreOffice is the ultimate office suite within Linux and even within Windows. 

There was a time when Microsoft Office was head and shoulders above every other office package but there are only so many features you can add before you are either adding for the sake of adding or you are adding features that nobody wants (ribbons anyone).

LibreOffice has managed to incorporate a whole raft of features that makes it comparable with Microsoft Office at a feature level and it has something that Microsoft Office now lacks which is familiarity. The menus are laid out how I'd expect them to be and I don't find myself hunting for features lost in tabs and ribbon bars.

Now you might ask what is wrong with Abiword and Gnumeric. To be honest if you just want to type a letter then Abiword works just fine but for me that is all it is useful for. With Gnumeric it is ok for basic calculations and very simple spreadsheets.

If you have the disk space and you have the resources available then I cannot see a good reason for not having LibreOffice installed.

LibreOffice Writer


LibreOffice Writer is a Word Processing application similar to Microsoft Word. It has a full set of features including access to a wide array of templates, wizards for creating letters and a mail merge facility.

Wizards


To start of with I will highlight the wizard feature. There are wizards for creating letters, fax cover sheets, agendas and even web pages.

For this review I will look at the letter wizard but the other wizards work in a similar way.

The letter wizard starts off by asking you the type of letter you wish to create, the choices being a business letter, a formal personal letter or a general personal letter.




The second page of the wizard lets you determine the items that will appear in the letter such as return addresses, subject lines, salutations and footers.







The third step of the wizard lets you determine the addresses that appear on the letter and you can use the mail merge feature to produce multiple copies of the same letter. I will come to this in more detail later on.

The fourth step enables you to enter a footer for the letter and finally on the fifth step you can choose whether to store the settings you have entered as a template.

What is produced is a series of place holders which you then click into and amend in order to write your letter.

Writing one letter this way is far too overkill but if you had to write one letter and then send it to 50 people stored in an address database then you can easily use this system to create a template that can be used again and again.

Templates

Sometimes you will want to create a document that has been created a million times before and rather than reinvent the wheel you can choose to install a template from the LibreOffice Template library.

Now there is a button that says Install Template Pack but despite clicking this button and following the instructions nothing appears to have happened.

Fortunately there is a link next to the button which says "Get more templates online" which takes you to the Template Library.

There are templates for a large number of document types including Curriculum Vitaes (Resumes), Calendars, Budgets, Certificates, EBooks, Fax Templates, Magazines, Newsletters, Notes, Labels, CD/DVD labels, Invoices and well to be honest too many to list here.




Mail Merge


To demonstrate the mail merge feature I created a spreadsheet with two rows in it. Quite simply it has the first and last names of 2 fictional people and their address details and contact phone numbers.



Within LibreOffice Writer I can use a spreadsheet with a list of names and addresses to create a mail shot.

You can either use the letter wizard and then import the addresses or just choose the address data source wizard and pull in the parts you need.

The first thing you need to do is select the data source.

The datatype can be anything from a simple spreadsheet to a complicated MySQL database.

After choosing the database type you can then choose the file to retrieve the addresses from, or if the source is a MySQL database the database name and server to connect to.



Once you have selected the database you can then map the database fields to the fields on the letter template.

Using the simple spreadsheet above all I had to do was match the first name column in the spreadsheet with the <firstname> tag within the letter template.

When you have finished mapping the fields you will then see the document with the tags still in place for example <firstname>, <lastname> etc and you might think that nothing has happened.





At this point you are still in the edit mode so you can drag the fields to other parts of the document. For example you might see the word Hello and want to place the <firstname> field after it so that every letter says hello to the person you are sending it to. 

To actually generate the letters click the mail merge button and a further wizard will appear which will take you through the actual letter generation process.


Creating Web Pages

It is possible to use the LibreOffice Writer to create basic web pages.

Personally I would never use a word processor to create web pages as there are far better tools capable of producing web pages and I find that word processors have the habit of adding bloat to your HTML.



The interface within LibreOffice is a little bit clunky but as WYSIWYG HTML editors go it works quite well and looking at the source code the HTML generated isn't too bad.

General Functionality

LibreOffice writer can open and store files in multiple formats including ODT, Microsoft Word and PDF.

The document can be sent electronically via email in various formats.

You can expect all the standard functionality that is in other word processors including headers, footers, the ability to add images, videos and other objects. 

There is a spell checker and there is also a macro facility similar to the one in Word.

LibreOffice Calc

The largest corporations around the world have full ERP solutions supplied by SAP and Oracle. The truth is though most large corporations would fall apart if Microsoft Excel didn't exist.

Spreadsheets are the backbone of business and they are perfect for data analysis, tracking of information, charting, basic relational data, bug lists and address lists. Every office has resident experts who know how to use all the functions and how to write complex VBA code.

Spreadsheets are also the scurge of many an IT department as the spreadsheets become unwieldy and people have a habit of connecting spreadsheets to databases by hardcoding connection strings.

Microsoft Excel is brilliant. I don't often praise Microsoft but there are a few things that Microsoft have created that are really good. Excel is one of them and Visual Studio is another and of course the XBOX 360 is by far the best gaming machine on the planet.

LibreOffice Calc though is now potentially every bit as powerful as Excel although it will be difficult to get companies to rewrite all that VBA code in LibreOffice Basic.

Every function that you can think of using in Excel is covered in LibreOffice Calc. Named ranges are catered for in an almost identical way.

LibreOffice Calc has full support for PivotTables and Charting and using LibreOffice Basic you can create functions every bit as complex as those within Excel.

LibreOffice Impress


LibreOffice Impress enables you to create presentations in much the same way you would with Microsoft Powerpoint.

Creating presentations is very easy. You can either use the wizard or you can create a presentation from scratch.

The image above was created by using the wizard. To demonstrate some of the features of Impress I will create a presentation from scratch.

LibreOffice Impress has a range of default layouts that can be applied to pages.

The image to the left shows a simple title page with centred text.

You can choose from a large number of layouts. For example you can have a title with images on the left and text to the right, or text on top and an image at the bottom.

You can change the slide design and pick from a range of templates.

Instantly a dull white slide can be transformed to be something that looks a little more professional.




You can go one step further and make it look great by adding a background image.

The image to the right is just the default background from Xubuntu 12.10 used as a background for the slide.

Ironically I don't like it as a desktop background but as a slide background it looks good.

You can add slides simply by right clicking on the slide panel on the left and by choosing the add slide option. Slides can be moved around by dragging them up or down.

You can add images, videos, sounds, charts and text to your presentations.

Everything on the slide is customisable.

You can add different transition effects to every page to make the presentation visually pleasing.

Presentations can be saved in ODP or PPT format. As there is a portable version of Impress available it is possible to store a copy with the presentation on a USB drive which means you do not have to worry whether Powerpoint will destroy the layout or transition effects.

I have used LibreOffice Impress to produce presentations for work purposes and for my son's school presentations. I think because I can carry LibreOffice around on a USB drive I feel more comfortable creating presentations within LibreOffice. I know how the presentations will look wherever I have to present them because I'm using the software it was created with.

LibreOffice Database

A program I really love to hate is Microsoft Access. 

The reason for my hatred of Microsoft Access is that every department in every big company has used Microsoft Access as a way of circumnavigating the IT department in order to create an application that is fit for purpose.


The problem with circumnavigating the IT department is that the resident Access expert ends up leaving and the users need new fields, new reports or they just don't know how to use Access well enough to keep it tidy.

Microsoft Access has a purpose and that purpose is not to create huge applications with lots of VBA code. The purpose of Access is to provide small relational databases that can be shared between 1 and 6 users.

It is perfect for address books, bug tracking, inventory databases such as music collections or for listing all the items in your house in case you get burgled. (Obviously you would need a backup in case the machine containing Access is stolen).

Within LibreOffice there is a database application that works very similarly to Microsoft Access and it is really easy to use. 

There are two ways to create tables. You can use the design view or you can use the wizard.

The design view makes it easy to add columns including setting their types, whether they are nullable and whether they autoincrement.

The wizard view lets you choose from a pre-determined set of table types such as addresses, customers, bank accounts etc.


You can create relationships between tables using the relationship wizard. Simply drag from one table to another and a link is made.

You can create one-to-one links and one-to-many links.





Creating forms for entering data is very easy. You can simply right click on the table and choose the form wizard.

If the table you have chosen has relationships to other tables you can add subforms within the main form.



The LibreOffice Database application has everything you would expect from a small relational database including tables, views, queries and reports.

Reports are as easy to create as forms. Simply right click on a table and click the report wizard.



Summary

The one tool I have not mentioned is LibreOffice Draw.

LibreOffice Draw is similar to Microsoft Visio and would therefore be used to create process diagrams, flow diagrams or network diagrams.

I think LibreOffice is the perfect office tool to go with the ultimate Xubuntu operating system. 

So what are the alternative office suites? Well you could go for Open Office, Calligra or stick with individual tools for individual tasks.

As with audio software it is about finding the tools that work for you. Fortunately the Ubuntu repositories are huge and so finding that perfect application should be fairly easy.

In the next instalment I will be listing the other applications that I think would make the perfect Xubuntu operating system.

Thankyou for reading.


Click here to buy Xubuntu on DVD or USB





About the Author

Gary Newell started the Everyday Linux User blog in 2010 and has written reviews on dozens of different Linux based operating systems. He has also written a number of tutorials.

Get Updates

Subscribe to our e-mail newsletter to receive updates.

Share This Post

Related posts

5 comments:

  1. Nice overview of the capabilities of LibreOffice. Will bookmark it for a convenient time.

    ReplyDelete
  2. Almost everyone and every reviews are missing the most powerfull part of LibreOffice: it's style functions. Styles are used in every module: not only in Writer but also in Calc, Draw, Impress... LibreOffice also offers hybrid pdf, a gem!
    As every module sares about 90% of the code, mixing elements from one module to another is a breeze. Competition can't beat that!

    ReplyDelete
  3. I’ve been reading a lot of good reviews regarding LibreOffice application. And I’m thinking of using it in organizing modules for our business, I just hope it’s compatible with rfid technology in retail app.

    ReplyDelete
  4. Allo, I found this article looking for an alternative to Abiword, since I use Xubuntu on older computers. I wish to mention two issues on : a) editing and b), bugs

    a) editing

    I question the integration of editing and publishing into bulky Office suites, and would suggest the provision of an extended features text editor, along with a true publishing application if there is.

    I'm not any kind of developer, and need to write and edit productively (for volunteer work, to thank for your development skills).

    Thefore I use a text editor to compose, and eventually format using a work processor by lack of better options. I do not need any templates, neither web and mail integration. From a text editor, I'd rather expect basic capacities for basic text (letter) composition such as the control of font's kind, size, style (italic and bold) as well as basic paragraph spacing (and complete default setting and shortcuts for these attributes). I would expect a glide-and-paste feature and maybe page representation and printing ...The very basic stuff from an Office editor.

    On Mac OS10, I used to find some of these feature in TextEdit.

    As for document composition, I would argue for the use of a simple but keenly constructed publishing application, integrating geometrical and stylistic dimensions and capacities.

    ...Where tollbars and menus are organized in a logically discriminated (or consecutive) manners; where features are reduced, and graphically rendered to their simpliest expression (with a keen differenciation between menus and toolbars). And where objects, be they characters, lines and polygons are well integrated by essential dimensions of size, positionning (absolute and relative) along with limits, inclusion and exclusion, level (above, below), and status (a square becoming a text frame or a polygon to draw), etc. The application can include a layer and an historical presentation, and flat visual rendering.

    I used to find these characteristics in Adobe InDesign which is simple to use for these reasons. For these logical reasons, ID is almost as easy to learn as Office is, but allows one to be fast and fundamentally creative. ID was also fitter to generate and view "slide" presentations (of PDF format), just by designing a template that would not impose a bullet form of thinking.

    Could this tandem of an extended text editor and simple publishing app be found in Xubuntu one day? Personnaly think it would be a much more agile - and fit to open source- option than any Office suite which are, conversally, filled with ill-categorised (menu)features, offering restrained capacities through fastidious menu-routes. This, given the lack of toolboxes but evenmore, creative reliance on conventions rather than logical thinking. Office is a typical product from Microsoft. While a publishing app could be simplier than InDesign but organised similarly, in direct opposition to Microsft Publisher.

    b) bugs

    I am truly dissatisfied with Abiword for it keeps corrupting the format of documents, mostly by omitting characters such as numbers when saving, or "creating" new characters. Not to mention bugs like inert scrolling capacities but layout skidding on key striking.

    I'm worried because this "creative" corruption of documents has also been a behaviour experienced in OpenOffice before, in Ubuntu10.10. Again, numbers would disapear, as embeded images but URL references would be repeated several times continually. Therefore, much more important than feature for a text editor (a word processor) would be flawlessness and sturdy, simple cross-format handling.

    While any small text editor I used work very sturdily, quickly and flawlessly; this being another reason why I stay away from words processors.

    Thanks for your engagement! (and please apologize my ESL).

    ReplyDelete
    Replies
    1. Thankyou for the comment Louis. I will look to see if I can find the sort of editor you are looking for and a separate publishing application and maybe write an article on them. If you already have applications that suffice maybe you can suggest them here or even write a guest article. Thanks again.

      Delete

Feel free to comment on any of the blog posts. Please try to be constructive.

Offensive messages will be removed as will blatant adverts for misleading products and sites.

Thanks for visiting my blog

    Popular Posts

    Total Pageviews

    Subscribe

    Enter your email address:

    Delivered by FeedBurner

    Popular This Month

    What are other people buying?

    Zorin OS Buy
    Ubuntu Buy
    Linux Mint Buy
    Lubuntu Buy
    PCLinuxOS Buy
    Lubuntu Buy
    Xubuntu Buy
    Linux Lite Buy

    Followers

    Feedburner Followers

Blogger templates. Proudly Powered by Blogger.
back to top Google