Providing tips, tutorials and templates for various Office applications
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...]
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 OpenOffice.org AND NeoOffice. In order to freeze the header rows so that they don't … [Read more...]
Amazon afiliate: OpenOffice.org Calc Functions and Formulas Tips.: Essential OpenOffice.org 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...]
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...]
This is a green and cheerful invoice template that does all the automatic calculations for you. Information in the top of the invoice is echoed in the payment slip. You will need to customise by: Adding company information (name, address, phone) Adding payment information in the payment slip at the bottom Download >> View the download... To download the file, you will … [Read more...]
For those interested in using Calc as a simple database, there is a simple step-by-step tutorial available to show you how. From the tutorial: A Calc document is a very capable database, providing sufficient functionality to satisfy the needs of many users. This chapter presents the capabilities of a Calc document that make it suitable as a database tool. Where applicable, the functionality is … [Read more...]
If you are looking for the feature in OpenOffice Calc that automatically fills in cell values based on previously entered values in the same column, this is something that is called AutoInput in OpenOffice Calc. In Microsoft Office Excel, this is called AutoFill. You can see this in action here: In the above illustration, I only type the 'P' and the rest of the word Pears is filled in for … [Read more...]
If you are interested in applying a format for a cell based on the value in a cell, then you are interested in something called conditional formatting. Below is a tutorial for OpenOffice.org, NeoOffice and LibreOffice users. Links to tutorials for MS Excel and Mac Numbers users are provided at the bottom of the page. This tutorial is designed to assist in setting the formats and applying rules … [Read more...]
In addition to the guides for Writer and Impress, there is also a downloadable manual for OpenOffice Calc. Download the 516-page guide for OpenOffice Calc from Scribd. … [Read more...]
A lot of people think that most word-processing applications like Writer and its competition, are just like typewriters, with basic formatting like bold and underlining. This is OK for starting the document, but if it's something that may require a format change in the future, then it could be a long and painful process. Fortunately, over at World Label, they've put together some basic … [Read more...]
Recent Comments