Beautiful borders and backgrounds in OpenOffice [or LibreOffice]

I received the following query from Melissa: How do I create page borders that are nice, like ivy leaves or coloured swirly lines? All I can figure out are the straight black border lines. Thanks, Melissa. Personally, I've found that the border tool is generally only for variations on the straight border as you have mentioned. There are two scenarios where I want a "fancy" border for my … [Read more...]

How to Extract Media from PowerPoint Files (works for both Windows and Mac)

Lately I've been receiving a number of files in pptx format, but I present using my iPad and so convert these presentations to Keynote. If the slides contain images and text only, this conversion is relatively painless - usually there are just a few formatting and alignment issues that need to be addressed and then I'm good to go. All I need do is open the pptx file in keynote, either on my Mac or … [Read more...]

Hide Zero Values in LibreOffice Calc and Excel

Sometimes you don't want the zero values to show in your spreadsheet. Different Office programs can handle this in different ways. Below are some examples. Do you have any way that you remove zeros from your spreadsheets? If so, please feel free to contribute in the comments section below. OpenOffice / LibreOffice OpenOffice / LibreOffice has the option to hide the zero values … [Read more...]

How to Remove Duplicate Rows in Calc [OOo, LibreOffice & NeoOffice]

There is no automatic function to remove duplicate rows in Calc. In order to remove duplicate rows you need to perform some comparison tests. This tutorial will show you how to sort the data compare the data remove the duplicate rows There is a tutorial here that will show you how to check for duplicates on a single column value, however often we need to compare for more than one value … [Read more...]

5 things you should know to master your office software [Microsoft, Mac or Open Source]

Regardless of the flavour of Office Productivity software that you use, be it OpenOffice.org, LibreOffice, NeoOffice, Microsoft Office or Apple products including Pages, Numbers and Keynote… there are some basic skills that you should master to be really productive. This post highlights five of these skills. … [Read more...]

An introduction to “Page Styles” in Writer [Video Demonstration]

Often long documents are created in Writer, and these often have complex formatting. They consist of design elements such as text, objects, paragraphs, characters, tables, etc. One of these design elements are pages. Pages have different properties compared to paragraphs and text, e.g. size and width, margins etc. From Writer's point of view these properties make up an “instruction set” for … [Read more...]

7 Steps to Formatting Your School Assignment – just like THEY asked!

It's the pain that a large number of students share: you've received your assignment brief from your school/institution and the content you can write... no problem. But that pesky formatting!!! What is “12-point font”? What does “double line spacing” mean? Some schools even impose penalties (deduct marks) if you don't get this right! This guide has been put together with the aim of removing some … [Read more...]

Specifying the Default Magnification in Exported PDFs [OOo, LibreOffice, NeoOffice]

To set the default zoom for PDF documents, use File > Export as PDF... and select the "Initial View" Tab (see the screen shot below). On this tab, you can set the desired magnification (zoom) for your PDF. A Note on Default Zoom It has been noted that default zoom settings perform differently depending on the operating system (Linux, Windows, Mac, etc) and the software used to open the … [Read more...]

Useful Tutorial – How to Print an A5 Booklet with 4 or 8 pages

Quick update: Pop over to the OpenOffice.org template site to download a tutorial on printing an A5 booklet, allowing you to create the document in A4, but noting that it will reduce to A5 when printing. … [Read more...]

Spell Checker Issue in Word [Mac versions of Office 2011]

There seems to be a spell checker issue in Word where the following error is reported. On my Mac, this happens most often when I open a file that did not originate from MS Word 2011. If I create a document in MS Word 2011, and leave spell and grammar checks enabled for "as you type" (see below on how to disable this), then I do not get an error. If you do not disable the options below, … [Read more...]