Calc Guide

= 2 does not work (because you set the Row on the copy to 2, but do
not change the original).
Manipulating filtered data
Filtered data copied to a new location may be selected, modified, and
deleted at will. Data that is not copied, however, requires special
attention because rows that do not match the filter criteria are simply
hidden. OpenOffice.org behaves differently depending on how the cells
became hidden and what operation is done.
Cells may be hidden using an outline, data filter, or the hide command.
When data is moved by dragging or using cut and paste, all of the cells
are moved—including the hidden cells. When copying data, however,
filtered data includes only the visible cells and data hidden using an
outline or the hide command copies all of the data.
Calc functions similar to database
functions
Although every Calc function can be used for database manipulation,
the functions in Table 17 are more commonly used as such. Some
functions’ names differ only by the letter appended at the end;
AVERAGE and AVERAGEA, for example. Functions that do not end with
the letter A operate only on numeric values and cells that contain text
or are empty are ignored. The corresponding function whose name
ends with the letter A, treats text values as a number with the value of
zero; blank cells are still ignored.
Table 17. Functions frequently used as database functions.
Function Description
AVERAGE Return the average. Ignore empty cells and cells that
contain text.
AVERAGEA Return the average. The value of text is 0 and empty cells
are ignored.
COUNT Count the number of numeric entries; text entries are
ignored.
COUNTA Count the number of non-empty entries.
COUNTBLANK Return the number of empty cells.
COUNTIF Return the number of cells that meet the search criteria.
Chapter 13 Calc as a Simple Database 375