Why does deleting filtered rows remove other rows too? (OpenOffice.org 2.x)
Filtered rows are not longer deleted in OpenOffice.org 3
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.