page1
This will illustrate the correct behavior, as seen in OpenOffice. Create a spreadsheet with thousands of rows of data in column A. Then in cell B1 create a formula that you want to copy down through all the cells from column A.
Press <Control><C> on B1 and then move to cell B2. This is where you want to start copying your formulas.
Now, while pressing and holding <control> and <shift>, press <down>
(which will jump to the bottom of the sheet)
Then <left> (which will jump to the far left of the sheet)
Then <up> (which will jump to the end of the keyed data in that column, column A)
Then let go of <control> (continue holding <shift>) and press <right> (which will finally place you at the perfect end point for your paste operation)
Now press <control><v> to paste your data through the 2047 cells below where you copied it.
Done.