LibreOffice 3.4

I have featured OpenOffice.org on this blog a few times in the past. It is a free office suite featuring a word processor, a spreadsheet program, and a presentation maker. Until recently the software was produced by Oracle Corporation, but fears that they would cease to support the project or stop it being open-source resulted in many of the programmers setting up their own project: LibreOffice.



LibreOffice is a fork of OpenOffice.org (now produced by Apache Software Foundation), so users of the latter will make an easy transition to the former. The application names have been carried over: Writer is the word processor; Calc for spreadsheets; Impress for presentations; and so on. Furthermore, the look and feel of the packages has changed little.



Version 3.4 of LibreOffice offers many improvements on version 3.3. There is much better memory management and less of a reliance on Java. Calc is more compatible with Microsoft Excel. But the most improved application is Impress, which flies along compared to the old version.



The continuing development of LibreOffice seems assured, whereas OpenOffice,org appears to be in limbo. For that reason LibreOffice is now my office suite of choice and I would recommend users of OpenOffice.org switch over to its latest version.

Read More

Linux commands for OpenOffice applications

In order to create a launcher for a particular OpenOffice application, or if you wish to run one from a terminal in Linux, you will need to know which command opens each application. Unlike Microsoft Office, for example, there is one command to run OpenOffice to which you can add a parameter to run a particular application.

Command to run the Writer word processor: openoffice.org -writer

Command to run the Calc spreadsheet application: openoffice.org -calc

Command to run the Impress presentation application: openoffice.org -impress

Command to run the Base database application: openoffice.org -base

Command to run the Draw vector graphics editor: openoffice.org -draw

Read More

How to copy charts into a word processor

When copying charts into a word processor, whether in Microsoft Office from Excel to Word or in openoffice.org from Calc to Writer, the software embeds a special object that links back to the original spreadsheet. If you then change the details in the Excel spreadsheet the chart in the Word document will change accordingly. In many cases this is advantageous; however, it can cause problems if the Word document cannot 'see' the Excel file, for example, if you email the Word file to someone without the Excel file. It is generally better to paste the chart as an image in the first place using the 'Paste special' facility.

I will start by explaining how to do this in Microsoft Office:

Once you have created your chart in Excel you select it and copy it, as shown here.


In older versions of Word you pull down the 'Edit' menu and select 'Paste Special'. You may have to wait a moment for all the menu items to be revealed.


In the latest versions of Word, 'Paste special' is in a menu underneath the 'Paste' button.


A box will open, from which you select 'Picture (Enhanced Metafile)', and click OK.

This will then insert the chart as a picture, which you can manipulate like any other imported image.
In openoffice.org, the procedure is pretty much the same as above, with 'Paste special' is in the 'Edit' menu, or alternatively you can use a keyboard shortcut: Ctrl + Shift + V. The major difference from above is that the following box will open when you select 'Paste special'. Simply select 'Bitmap' and click OK to paste the chart as a picture.

Read More

Adding custom lists to Excel and OpenOffice.org

In the last post I demonstrated how to easily enter lists of numbers, days of the week and months of the year in Excel and Calc (the OpenOffice.org spreadsheet application). Both programs offer the option to add custom lists to this feature. In this post I will show you how to add the colours of the spectrum as a new list.

Excel 2003 and earlier
Open up Excel and type the colours of the rainbow into one of the columns, then select the cells as shown below.

Pull down the 'Tools' menu and select 'Options', then go to the 'Custom Lists' tab.

You should see an entry in the 'Import list from cells' box. Click on the 'Import' button to the right of this to add the list.

The colours list will appear in the 'List entries' box. Rather than type the entries into cells, you could just type the list in this box, pressing Enter after each item, and then click the 'Add' button to save the list.

Click 'OK', and the list is available to use. Simply type 'Red' in a cell and drag the handler down to automatically fill consecutive cells with the other colours.


Excel 2007 and later
Follow the previous instructions, except to open the 'Options' box click the Microsoft Office Button (shown right), and then click the 'Excel Options' button.

On the 'Popular' page, click the 'Edit Custom Lists' button and continue as above.

OpenOffice.org Calc

Type the list of colours into a column of cells and select them as shown.

From the 'Tools' menu, select 'Options', then click the + next to 'OpenOffice.org calc' in the list, to expand its entries, then click on 'Sort Lists', as shown.

You should see an entry in the 'Copy list from' box. Click on the 'Copy' button to the right of this to add the list.

Click 'OK', and the list is available to use.

As with Excel, you can enter a list manually by clicking the 'New' button on the 'Sort Lists' option box, typing in the entries, and then pressing the 'Add' button.

Read More

How to quickly enter lists in Excel and OpenOffice

Excel spreadsheets often have a column or a row of incremental data. That is, information in the form of a list of numbers (1, 2, 3, 4, etc), times (09:00, 10:00, 11:00, etc), the names of months or the days of the week. You could type all this information into the row or column yourself, or you can let Excel handle it for you.

To try this out open Excel and type 1 in any cell, and 2 in the cell below it. For lists of numbers you need to enter a couple of numbers so that Excel knows where to begin and what interval to use.

Select both the cells (by hovering the mouse pointer over the top of one, holding down the left button, moving to the other cell and letting go).

You will notice that there is a small square in the bottom right hand corner of the selection box. If you hover the mouse pointer over this square the pointer will change to a + symbol. If you hold down the left mouse button and drag downwards Excel will fill in the cells continuing the series of numbers.

You can do the same with larger increments too. The images to the left show the same process being used to generate is a list of numbers with an interval of 10.

But that is far from all you can do with this process. You can drag these lists in any direction so that you can create rows as well as columns. Also, you are not limited to numbers; you can produce lists of months, days of the week, and times. I have included a video in this post showing this feature of Excel in action creating a few of these lists.

Calc, the OpenOffice spreadsheet package, works in pretty much the same way, except that there are no default intervals for times. So, if you enter 00:00 and drag the handler down selecting consecutive cells they will all also be filled with 00:00, but this is easily solved by entering 00:00 in the first cell and 01:00 in the second, then selecting both cells and dragging the handler down.

In the next post I will show you how to set up your own custom lists in Excel and Calc.

Read More

OpenOffice Keyboard Shortcuts

Writer, the word processor in OpenOffice.org, uses many of the same keyboard shortcuts as MS Word. The shortcuts for selecting, editing and formatting text follow established standards. Whereas Writer has a keyboard shortcut for 'Paste special' (Ctrl + Shift + V) - something missing in Word - it does not have one for changing the case of selected text. It is possible to set up new shortcuts in Writer, and I will show you how to set up one to make the selected text upper-case and another to make it lower-case.

In Writer pull down the 'Tools' menu and click 'Customise'.

Select the 'Keyboard' tab, as shown below.

You can see all the default keyboard shortcuts, and some spare key combinations.

I have chosen Ctrl + Shift + U to make selected text upper case, and Ctrl + Shift + L to make it lower case.

Find Ctrl + Shift + U in the 'Shortcut keys' list. Select 'Format' from the 'Category' list, and then 'Uppercase' from the 'Function' list. Click the 'Modify' button to make the change.

Repeat the process selecting Ctrl + Shift + L, the 'Format' category, and the 'Lowercase' function, not forgetting to click the 'Modify' and then the 'OK' buttons when you are done.

Read More

Linux applications: Part 1 - Productivity

As I mentioned in a recent post, I have recently switched to a Linux distribution as my operating system of choice. Many other users may be put off from making a similar switch because they are concerned that they may not be able to use the applications that they know from the Windows environment. While some applications are not available on Linux, there are a number of alternatives that offer all the most important features and have the benefit of not costing a penny.

Office Software
OpenOffice.org from Sun Microsystems is a decent replacement for Microsoft Office. It includes a word processor called Writer, a spreadsheet package called Calc, presentation authoring software called Impress, a database management system called Base, and a vector graphics program called Draw, which doubles up as a simple desk top publishing package. Using OpenOffice.org you can open and save files in Word, Excel and Powerpoint file formats and even save them in pdf format too. So far I have had no problems transferring files between OpenOffice.org and Microsoft Office, although you may be advised to install the default Microsoft fonts. For Ubuntu users the MS font package is called msttcorefonts. OpenOffice.org is not only available for Linux, but also for Windows and Mac OS.

PDF Reader
While Adobe Acrobat is available for Linux, it is as bloated as its Windows equivalent. Evince is a good lightweight alternative, with the added benefit of support for djvu files. If you use KDE as your windows manager then you may also want to consider KPDF.

Graphics software
As with OpenOffice.org, GIMP is available for Linux, Windows and Mac OS; although I have had problems using it on Windows in the past. It is a feature rich graphics manipulation program that supports all commonly used image formats.

In the next part I will look at for entertainment software available for Linux.

Read More