In Calc I want to copy all values in a column.
My columns have data in ~10,000 rows.
If I click on the column letter it copies all of the blank cells, so when I paste them onto another spreadhsheet (further down). I get a ‘There is not enough space on the sheet to continue’ message.
I can’t click and drag because that would take too long waiting for the page to scroll down, any ideas?
I’m copying data from one spreadsheet to another.
Assuming you want to copy data in only one column: and you have no empty cells in the data range to copy
If there are empty cells, continue to hold Shift and press Ctrl+Down arrow repeatedly until you reach the end of the data.
See Shortcut Keys for Spreadsheets for more information on the shortcut keys available for Calc.
If this answer helped you, please accept it by clicking the check mark 
to the left and, karma permitting, upvote it. That will help other people with the same question.
Did nothing.
Perhaps the new version this was changed?
I just tested with 7.6.3.2 and it functions as I described above.
Version: 7.6.3.2 (X86_64) / LibreOffice Community
Build ID: 60(Build:2)
CPU threads: 16; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (wbp_AU.UTF-8); UI: en-US
SlackBuild for 7.6.3 by Eric Hameleers
Calc: threaded