How to Add a Tick Symbol ✓ to Writer documents [LibreOffice, OpenOffice]

To insert the tick (✓) symbol into a Writer document, follow these instructions. From the menu (in Windows and Mac) click on Insert --> Special Character. From the Font dropdown, you need to select a font that will include the tick symbol. Times New Roman does NOT include this symbol. One font to use is OpenSymbol. Select OpenSymbol and then scroll down until you see the tick … [Read more...]

Reader Question: Showing and Hiding Themes [OpenOffice & LibreOffice]

Jerry left a comment saying that he had trouble with the following: "cannot find how to show/hide themes in calc" Thanks, Jerry. I'm not sure if this is exactly what you mean, but some refer to the Gallery in OpenOffice as 'themes'. (Please leave a comment below if this is not what you meant.) To show and hide the Gallery (in Calc, Writer or Impress) simply select the following in the … [Read more...]

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...]

FAQ: How to Show Column A in LibreOffice Calc

I recently had a comment in response to FAQ: How to hide columns in Calc [Show / Hide] and decided to answer it with a video. It details two methods: A method in which you can show (unhide) all columns (this can be applied to rows), and  A method for unhiding column A alone   … [Read more...]

Update notifications for 3.3.0 Installations [from Rob @ Apache]

I received this in my email this morning. Get your Upgrade! We have enabled the upgrade notification server for 3.3.0.  By default OOo 3.3.0 checks for updates once a week.  When an upgrade is available, a dialog pops up and notifies the user about the update, and directs them to a website where they can learn more and download Apache OpenOffice 3.4. The update … [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...]

Setting Delimiters when opening a CSV File (OpenOffice Calc)

I had a question recently concerning the opening of CSV files in OpenOffice. Sometimes when we open CSV files, they open in Calc by default, and the Text Import window doesn't appear. If this is the case for you, and the data is not being sorted into columns in a format you are happy with, then close the file and go to File >> Open. Then select the CSV file and the following window … [Read more...]

Question: Why does the header row keep moving when I sort?

In a previous post I have answered a question about sorting lists in Calc. This usually has no problems, but every now and then an occasion occurs where Calc doesn't recognise that the first row is a header row. To deal with this, in Step 3 of the previous tutorial you need to click on the Options tab and ensure that the "Range contains column labels" tick box is checked (or … [Read more...]

Replace any text with Carriage Return/Paragraph Marks in 5 Easy Steps

When you need to replace text with paragraph marks (end of paragraph) / carriage returns,, LibreOffice and NeoOffice Writer all are able using the following 5 steps (click on the image to view a larger version): Note: If you don’t know how to get to the find / replace button above, hit Ctrl-F (Windows) or CMD-F (Mac). Alternatively, you can go to the ‘Edit’ Menu, and select ‘Find … [Read more...]

6 Sigma Presentation Layout [LibreOffice,, NeoOffice]

I've put together this 6 sigma presentation layout for free download and use in Impress. ** UPDATE - now with a Microsoft Powerpoint version. … [Read more...]