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

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

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

How to Remove Duplicate Rows in Calc [OOo, LibreOffice & NeoOffice]

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

Calculate an Internal Rate of Return (IRR) using OpenOffice Calc [Financial spreadsheet calculations]

Amazon affiliate: Net Present Value and Internal Rate of Return: Accounting for Time What is an IRR? IRR (Internal Rate of Return) is the average annual total return from an investment over a specified time period. It is also called the discounted cash flow rate of return (DCFROR) or simply the rate of return (ROR) (Ref: Wikipedia). How can I calculate IRR using Calc? Over at … [Read more...]

Free Download – 2011 Planning Chart

Amazon Affiliate: 2011 Monster Grid Calendar It's the tail end of the year and we start to plan for the upcoming year. This is a free 2011 planner template for you to download, allowing you to plan out the whole year at a glance. There are a few downloadable ods (spreadsheet) planners available including a plain, empty one, and ones with Singapore, Malaysia and Australian (federal) public … [Read more...]

FAQ: Locking/Freezing Heading Rows in OpenOffice Calc [and Freezing Columns, too!]

Amazon affiliate: Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting Let's say you have a number of rows of data, and you need to be able to scroll or search up and down them, but whenever you do, you lose sight of the headings. These instructions work for Calc in both AND NeoOffice. In order to freeze the header rows so that they don't … [Read more...]

FAQ: How to hide columns in Calc [Show / Hide]

Amazon afiliate: Calc Functions and Formulas Tips.: Essential Calc Skills In OpenOffice and NeoOffice, you can show and hide rows and columns. This is useful as you may want the data to be included in the sheet, however you may not necessarily want all the data viewable. Note that this does NOT delete the data. It merely hides the column. Hiding a Column To … [Read more...]