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...]
LibreOffice Portable Apps v 3.5.4 released
June 8, 2012 by Leave a Comment
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
June 6, 2012 by Leave a Comment
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?
March 14, 2012 by 1 Comment
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...]
Replace any text with Carriage Return/Paragraph Marks in 5 Easy Steps
December 8, 2011 by 3 Comments
When you need to replace text with paragraph marks (end of paragraph) / carriage returns, OpenOffice.org, 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 … [Read more...]
OpenOffice.org, LibreOffice & NeoOffice on Mac Lion OSX – Part 2
July 23, 2011 by 1 Comment
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 OpenOffice.org, 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...]
OpenOffice.org, LibreOffice & NeoOffice on Mac Lion OSX
July 21, 2011 by 11 Comments
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...]
From a Reader: How to Install Templates?
July 21, 2011 by Leave a Comment
Hello Stephanie, I am using LibreOffice 3 which came with Ubuntu 11.04. I am also new to OpenSource. I would like to use new templates that I have found on OpenOffice.org and on your site, but can not figure out where to load the Templates or how to get them into the Template section. I know this might be a simple task, but I am totally lost as to how to get this done. Regards, J A K … [Read more...]
Turning off Capitalisation in Impress and Writer [OpenOffice.org, LibreOffice and NeoOffice]
July 15, 2011 by Leave a Comment
I was recently reading through a tutorial and noticed that the writer (Akkana) was frustrated with the auto-capitalisation at the beginning of sentences in OpenOffice.org Impress. Turning this feature off is relatively simple, however you need to do it in each of the programs to ensure it is applied to both Writer and Impress. I've also included links for those wanting to do this in … [Read more...]
How to Remove Duplicate Rows in Calc [OOo, LibreOffice & NeoOffice]
July 12, 2011 by 5 Comments
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...]
Recent Comments