OpenOffice.org Calc misses a feature that has been present in Microsoft Excel
since at least MS Excel 97: it cannot copy to the clipboard rows (or columns)
that are not continuous. For example, say I want to copy rows 2, 4 to 11, 23, 39
to the clipboard, then paste them in another sheet so that they are now
consecutive. I can do so in MS Excel 97 (and XP, I am quite sure) but not in
OpenOffice Calc 2.2.0.

When I try to do so in OpenOffice Calc, it comes up with the following message
in a dialogue box upon pressing Ctrl+C:
This function cannot be used with multiple selections.

However, I can successfully copy non-continuous rows to the clipboard in MS
Excel 97 running on Windows XP (odd combination, I know!). If I paste these rows
into a new Excel sheet, they will appear continuous (no blank rows between them).

Interestingly, when I go to C:\WINDOWS\system32\clipbrd.exe (Windows XP Home
edition), the clipboard contents show a continuous range of rows. That is, using
the example above, rows 2 to 39 are present on the clipboard.

The feature is missing on the version for Windows XP, and for Kubuntu 7.04
GNU/Linux, which I have personally tried.

Background:
I personally found this feature useful when performing statistics coursework in
high school. We were given a spreadsheet of data, much like the attached file.
In order to do random sampling, I used a random number generator, then I
selected those rows corresponding to the ones produced by the random number
generator (in MS Excel 97). I would then copy them to the clipboard, then paste
them into a new spreadsheet and save it as a separate file. Hence, I could
perform statistics on this sample of data.

Perhaps there is another way of solving this problem, but I think that the
aforementioned functionality in a spreadsheet is a great help!

(I have searched for this in the Query Issue section of this website, as well as
a search engine (Google), but there seems to be no solution.)