A commonly needed entity is the date of the last day of a particular month or a range of months, usually when payments are due or when interest is calculated. We show two approaches to this.
SMALL returns the kth smallest value in a range of cells, LARGE returns the kth largest value in a range of cells.
When do we use REPLACE and when do we use SUBSTITUTE?
We will answer this question with some basic examples of both functions.
To select all the cells of a sheet, click in the space above the 1 and to the left of A - see below.
With the help of the Web Page Query OpenOffice.org Calc import filter, you can insert tables from HTML documents in a OpenOffice.org Calc spreadsheet.
Let us step through the relatively straightforward process of importing data from tables in a HTML document.
The data for this example was obtained from an excellent website with tons of population data from all over the world : citypopulation.de
Here is what the source HTML file looks like : swiss.html
For this example, we will be importing awebpage from the local disk.
The External Data dialog is activated by Insert-External Data.
Once we fill in the path to the local copy of the HTML file and the table inside this file we wish to import - we hit OK and we are done - it is that easy.
Like the other Openoffice tools, it is possible to add hyperlinks to OOo Calc. In this tutorial, we will activate the Hyperlink toolbar and link to an external website from a spreadsheet.
Goal Seek allows you to perform a special analysis on a formula wherein you specify the result in order to determine the value of an input parameter required to achieve the specified result.
In OOo Calc, there exists the concept of Data Sources. A data source can take many forms - including MySQL database, text file, address book and spreadsheet. We will eventually examine each of these in more detail.
The OOo Calc Advanced Filter is similar in functionality to the AutoFilter wherein lists are filtered according to a combination of multiple criteria.
What is different is the mechanism by which we define these criteria.
In the previous article on Data Filtering - we looked at the AutoFilter option.
We will now look at the Standard Filter.
You are currently browsing the OpenOffice Calc Tips weblog archives for October, 2004.