This page is outdated. You will be redirected to http://wiki.services.openoffice.org /wiki/Documentation/FAQ shortly.
Why does deleting filtered rows remove other rows too?
When using Calc filters, selections that span a range of cells include filtered and hidden rows. Deleting a range of rows with a filter enabled will delete all rows in that range, whether they are visible or hidden, not just the visible rows. To select multiple rows individually, select the first row, then use Ctrl+click to select each additional row.