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

LibreOffice Portable Apps v 3.5.4 released

On June 1, 2012, 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...]

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...], LibreOffice & NeoOffice on Mac Lion OSX – Part 2

Note: For those that don't have a Mac, we'll be back to regular programming shortly. :) On Thursday I did a quick take on what my experience was on, LibreOffice and NeoOffice after installing Mac OSX Lion. There is a website that can assist you in identifying programs that work with Lion OSX - including our favourites! … [Read more...], LibreOffice & NeoOffice on Mac Lion OSX

Today I decided to bite the bullet and install the new Lion OSX on my Macs. So far so good, however when you do the upgrade and if you use an Open Source Office software product, I suggest that you immediately open them after the installation of Lion and go through any recommended upgrades. … [Read more...]