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

LibreOffice Portable Apps v 3.5.4 released

On June 1, 2012, PortableApps.com and The Document Foundation announced the release of LibreOffice Portable 3.5.4. LibreOffice Portable is a full-featured office suite -- including a word processor, spreadsheet, presentation tool, drawing package and database -- packaged as a portable app, so you can take all your documents and office suite wherever you go. This release updates LibreOffice to … [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 OpenOffice.org 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...]

Read ODS, ODT & ODP Files on your iPhone or iPad

I always struggle with opening OpenOffice.org open format documents on my iPhone - Apple doesn't have this as a standard format that other applications can use. I don't know of any applications that can edit Open Document Format files, however recently I downloaded the IBM Lotus Symphony Viewer. This works a treat in at least allowing me to view the data inside, which is certainly better than … [Read more...]