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

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

FAQ: How to sort lists in OpenOffice.org Calc

I addressed sorting in OpenOffice Writer in a previous post, and have since had a request for a tutorial on sorting in Calc, so here it goes. Step 1 Select the entire data range that you want to sort. This includes all the columns that have data that need to be kept in line with the column that you want to sort. Include the headers of the column as well, as OpenOffice will pick these up as … [Read more...]