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]
June 14, 2012 by Leave a Comment
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
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...]
Setting Delimiters when opening a CSV File (OpenOffice Calc)
April 24, 2012 by Leave a Comment
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?
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...]
Read ODS, ODT & ODP Files on your iPhone or iPad
December 12, 2011 by 2 Comments
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...]
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...]
6 Sigma Presentation Layout [LibreOffice, OpenOffice.org, NeoOffice]
July 30, 2011 by Leave a Comment
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...]
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...]
Recent Comments